[CentOS] Help to restore mysql data on CentOS 5

2007-12-04 Thread Indunil Jayasooriya
Hi , Help is needed to restore mysql data This is the the setup. 2 Servers running on CentOS. one server has both apache an mysql. the other server only has mysql database. This server has about 12000 records in the database. Last week, It had about 6000 records. then, Someone has backed up

Re: [CentOS] Help to restore mysql data on CentOS 5

2007-12-04 Thread Tomasz 'Zen' Napierala
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 dat

Re: [CentOS] Help to restore mysql data on CentOS 5

2007-12-04 Thread Jim Perrin
On Dec 4, 2007 6:11 AM, Indunil Jayasooriya <[EMAIL PROTECTED]> wrote: > mysqldump -u root -p databasename > database.txt You might also want to use -Qc, so that you quote the data and do complete inserts. This depends mostly on the version of mysql that you're running, which I didn't see in you