Tuesday 04 December 2007 12:11:50 Indunil Jayasooriya napisaĆ(a):
> 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
QXL Poland - Allegro.pl Team
CentOS mailing list