Re: [CentOS] Help to restore mysql data on CentOS 5

Tuesday 04 December 2007 12:11:50 Indunil Jayasooriya napisał(a):

[snip]

I think I will have to do following steps.

first, I will have to dump the mysql server backup from database server.

This is the command I will have to enter from the database server.

• mysqldump -u root -p databasename > database.txt*

You might want to add --add-drop-table to your mysqldump

then, I will have to mount a flash drive and copy *database.txt* to the flash drive.

Then, I will have to go to the web server and mount it there.

Then, finnaly, I have to restore *database.txt* to web server as follows.

*mysql -u root -p databasename < databas.txt*

Am I RIGHT?

Is second DB RW or RO?

This data is extremely essential. I should be able to do it properly.

Most production data is extremely essential ;)

Regards,