|[B]thornton wrote on Wed, 22 April 2009 21:26[/B]|
And yes, I tried mysqldump but I keep getting an error that says
mysqldump:command not found.
I am running this from the command line and not from inside MySQL and I am running it as a superuser. I also tried running it after navigating to the directory where I have mysql and also from mysql/bin where I can see mysqldump
If you are in the mysql/bin directory you have to write:
./mysqldump -uroot -p yourDatabase yourTableName > yourDumpFile.sql
The important part is the ./ at the beginning.
Because in contrast to Windows the current directory is not part of the PATH in Unix.
Then on your new server:
./mysql -uroot -p yourDatabase < yourDumpFile.sql
And you should be able to do this without restarting mysql.
Hopefully the DROP TABLE yourTable; command will still work, even though you can’t insert/update to the table.
If this doesn’t work you will have to restart the server.
The impact will most probably only be that the database is not available during the few moments it takes to restart it.
So could you tell me what the impact of restarting MySQL would be? And is there any workaround?
The workarounds are the ones I have mentioned in my posts.