Re: Mysql Command Line Client ARRGH

[Barry Galbraith]

Hi James,

I won't hold being an English Rugby fan against you.;)

I have no idea why your output file is empty, mine's not.

(inserted with edit)
I stopped my server and tried a mysqldump. I got an error which indicated the server could not be reached (expected) but I also got an empty file!!!
Are you getting an error message when you try to do a dump?

~~~ end edit~~~

To try something, can you get a backup of database mysql? I know it must exist, and be readable by user root.

Can you get a backup of your database using MySQL Adminstrator?
You'll get a dump similar to what mysqlbump --opt -Q gives if on the Advanced tab you set
"Lock all tables"
"Add DROP statements"
"Disable keys"

All other options should be unchecked.

If you can then it can be loaded on your new linux host using either MySQL Administrator using a remote connection to your linux host, or mysql commandline client, again using a remote connection, as long as the remote machine's mysql server allows <your_user>@<your_windows_host> to login.

Cheers,
Barry.



Edited 3 time(s). Last edit at 10/29/2009 08:47PM by Barry Galbraith.