How to backup MySQL Database in command line

Posted On Wednesday, November 28, 2007 at at 11/28/2007 02:25:00 AM by null  

Normal Method

$ mysqldump -hlocalhost -uUSERNME -pPASSWORD -Q --opt --databases DATABASE > backup.sql

Compressed Method ( useful if you have bigger database )

$ mysqldump -hlocalhost -uUSERNME -pPASSWORD -Q --opt --databases DATABASE > backup.sql.gz

Posted in |

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)