Rob, are you getting any error messages when trying to restore your MYSQL
backups (I assume that you have backed up your databases on the XP system by
using the MYSQL Administrator's backup function)? What are these messages?

I also suppose that creating blank databases on the Linux system and
directly copying the files of each database from the Windows system into
their directories on Linux would do the trick (however, I have never tried
it between heteregoneous systems - Windows versus Linux).

HTH,

Panos.

On 11/5/06, Rob Cochrane <lists@by-rob.com> wrote:
>
> Hi All,
>
> I am a Web developer and have been using MySQL for a couple of years. I
> have just changed to a new development machine away from WinXP to Ubuntu
> Linux. My Dbase administration in the past has been via MySQL-Admin and
> SQLYog. I am now trying to bring all my databases into localhost and
> even under sudo MySQL-admin will not allow a restore!
>
> I am not a great command line expert, preferring a GUI.
> Using phpMyAdmin export/import gives a "#1046 - No database selected "
> error.
>
> I know I am doing something really stupid but I have been setting up
> this box for 5 days and had minimal sleep.
>
> Thanks
> Rob
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=ptsapralis@gmail.com
>
>


--
Panos Tsapralis,
Senior Software / Systems Engineer,
+306948076902,
Athens, GREECE.