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

[Tsuyoshi Nagata <nagata3333333@xxxxxxxxxxxxxx>]

I move 1giga size of 'JPetstore' record(sql text) from RH4.6 to RH5.2.
 mysqldump&mysql commands are no problem.
pg_dump&psql commands are same result.
It takes about 10 minutes of my Celeron 1G.hz note.
First I gziped sql text to small size, then ftp, unpacked on Target(Linux).
I forgot any of databases have binary dump&restore.

Tsuyoshi.

samk@xxxxxxxxxx さんは書きました:
> 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=royale@xxxxxxxxxx