Wallpapers Forums Login

How To Backup Database Using MYSQL Dump Linux Command

I would like to know how to backup my entire database using mysqldump. I know there is a command i can execute but i forgot..
lookcrabs Wed May 05, 2010
I think your symbol is wrong. try using

mysqldump -all-databases -u username -p password >thisismysqldump.sql

or something like that
braker Sun Dec 03, 2006
I tried the example you gave me, but it doesn't work, i get this error when i try it:
CODE:
-bash: sqldump_name.sql.gz: No such file or directory


i find that his works better...
CODE:
mysqldump --opt -u username -p db_name | gzip > backup_file_name.sql.gz
braker Thu Aug 17, 2006
sure just run this command:


CODE:
mysql -h hostname -u user -p password db_name < sqldump_name.sql.gz


example: i want to backup a database called "forums_db", my login is welrose my password is ert345 my hostname is localhost and i want to name the sql dump as forums_db_backup.sql.gz - This is the command I would use to execute:

CODE:
mysql -h localhost -u welrose -p ert345 forums_db < forums_db_backup.sql.gz

Related Content

Information

Share

wallpaperama | Wallpapers | Forums | Terms Of Service

copyright © 2013 wallpaperama - All Rights Reserved - Last Updated Mon May 06, 2013 (-8 GMT)
Powered by: Webune Forums V5