Re: Help to restore mysql data on CentOS 5

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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/
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos


[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux