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/