I would suggest running something like this from your new linux server: mysqldump -u USERNAME -p -h WINDOWS_HOST --opt DATABASE | mysql -u root -h localhost DATABASE
This will pump the ouptut directly from mysqldump into mysql running on the linux machine, so you don't need another transfer mechanism (FTP, scp, etc.). -Aaron On Thu, Jun 26, 2008 at 5:09 PM, <[EMAIL PROTECTED]> wrote: > See Thread at: http://www.techienuggets.com/Detail?tx=42035 Posted on behalf > of a User > > Hi, > > I'm running MySQL 5.0.51 Community edition. I have a half a gigabyte sized > database that I'd like to move from a Windows 2000 based server to a Linux > server. What's the best way to do this? I normally take complete backup using > MySQL administrator which creates a file with sql to recreate the tables and > insert the data. Can I simply ftp this to the Linux box and restore it to a > database there? Is there a MySQL administrator for Linux? > > Thanks > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
