***BOGO*** Re: Moving Database from Windows to Linux

["Aaron Blew" <aaronblew@xxxxxxxxx>]

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,  <samk@xxxxxxxxxx> 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/mysql?unsub=aaronblew@xxxxxxxxx
>
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx