MySQL Forums :: Newbie :: what should i do when backup ?


Advanced Search

what should i do when backup ?
Posted by: liou zhaoxing ()
Date: January 31, 2010 08:54PM

hi everyone ,
those days,i face a problem. when i want to backup mysql data with innodb engine,there is some one who advised me to use mysqldump .so ,this is the puzzle i confused .
when i adopt the command mysqldump to backup with innodb engine,should i use the option --opt or not ?
i got the answer on this forum to use it --opt (advised to me )
but when i read a book writen by Michael Kofler ,he(she)recommands me like this :
mysqldump -u root -p
--skip-opt --single-transaction --add-drop-tables \
--create-options --quick --extended-insert \
--set-charset --disable-keys databasename >backup.sql (The Definitive Guide to Mysql 5 the third version,page 324)
so ,it seems like paradox for me to do ,so what should i do ?when i backup mysql data with innodb engine ?

Options: ReplyQuote


Subject Written By Posted
what should i do when backup ? liou zhaoxing 01/31/2010 08:54PM
Re: what should i do when backup ? Rick James 02/02/2010 12:10AM
Re: what should i do when backup ? liou zhaoxing 02/02/2010 03:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.