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. [EMAIL PROTECTED] さんは書きました: > 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]
