[CentOS] Help to restore mysql data on CentOS 5

Jim Perrin jperrin at gmail.com
Tue Dec 4 14:31:10 UTC 2007


On Dec 4, 2007 6:11 AM, Indunil Jayasooriya <indunil75 at gmail.com> 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 your initial post. Better safe
than sorry.


-- 
During times of universal deceit, telling the truth becomes a revolutionary act.
George Orwell



More information about the CentOS mailing list