[CentOS] Help to restore mysql data on CentOS 5
Tomasz 'Zen' Napierala
zen at allegro.pl
Tue Dec 4 12:01:54 UTC 2007
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/
More information about the CentOS
mailing list