Re: mysqldump ?
- From: Terry A Haimann <terry@xxxxxxxxxxxxxx>
- Date: Wed, 17 Jan 2007 19:52:27 GMT
Never mind, I needed to use the --compatable=mysql40 switch.
On Wed, 17 Jan 2007 14:55:40 +0000, Terry A Haimann wrote:
I am having trouble moving several of my databases from my linux server to
my win/xp laptops.
My Linux box is running mysql 4.1.11 and the laptops are running 4.0.26-nt.
When I had 3.23 on the windows boxes, I used to be able to run something
like the following from the linux server:
mysqldump -u user --password=password MyDatabase > mydb.txt
and then at the mysql prompt on the windows boxes do the following
use mydb
\. mydb.txt
And the data would import successfully.
Now the table creation aspect of the dump no longer works. I am having to
go back to the database creation scripts that I originally wrote on the
linux box, run them and then cut and paste the inserts into a seperate
document and then execute them individually.
There has to be an easier way to move my data to the windows boxes.
Thx in advance, Terry
.
- References:
- mysqldump ?
- From: Terry A Haimann
- mysqldump ?
- Prev by Date: Re: SAN Tape rewind during Boot
- Next by Date: wierd pure-ftp prob on fc5
- Previous by thread: mysqldump ?
- Next by thread: Re: SAN Tape rewind during Boot
- Index(es):
Relevant Pages
|
