[CentOS] Help to restore mysql data on CentOS 5

Tue Dec 4 12:01:54 UTC 2007
Tomasz 'Zen' Napierala <zen at allegro.pl>

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,
-- 
Tomasz Napierala
System Administrator
QXL Poland - Allegro.pl Team
http://www.allegro.pl/