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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]
-- Panos Tsapralis, Senior Software / Systems Engineer, +306948076902, Athens, GREECE.