MySQL Forums
Forum List  »  MySQL Administrator

Re: Mysql Command Line Client ARRGH
Posted by: Barry Galbraith
Date: October 29, 2009 03:13PM

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.


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

Options: ReplyQuote

Written By
October 28, 2009 03:21PM
Re: Mysql Command Line Client ARRGH
October 29, 2009 03:13PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.