Aaron
Aaron Blew さんは書きました:
> mysqldump -u USERNAME -p -h WINDOWS_HOST --opt DATABASE | mysql -u
> root -h localhost DATABASE
perfect answer..
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 mechan
See Thread at: http://www.techienuggets.com/Detail?tx=42035 Posted on behalf of
a User
Because of the fundamental difference between binary data files under Windows
and under Linux.
In Response To:
At 07:09 PM 6/26/2008, you wrote:
>See Thread at: http://www.techienuggets.com/Detail?tx=42035
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 dat
At 07:09 PM 6/26/2008, you 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 th
