How To Backup Database Using MYSQL Dump Linux Command

Forums Index
» MYSQL Forums
» » How To Backup Database Using MYSQL Dump Linux Command

How To Backup Database Using MYSQL Dump Linux Command
Post Description:
Post Tags: how, to, backup, database, using, mysql, dump, linux, command, mysql database, support, help, answers, questions, help
This Post Has Been Viewed 2000 Times Since Thu Aug 17, 2006 3:44 pm Posted By braker with 2 replies
Next Post »» Linux Shell Command - mysqldump --opt -u username -p

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..

Leave Your Comments

Share
URL:

You can use this HTML code to put it on your website to show your friends this wallpaper. Use this code on your profile like myspace, friendster, Facebook or others. Just Copy and Paste it in your HTML on your websites

Fourms BBCODE:

BBCODE is use on forums. You can put this code on all your BBCODE enabled forums like PhpBB, vBulletin® and others. Just Copy and Paste this code on your Posts and Replies on your forums

Comments and replies About How To Backup Database Using MYSQL Dump Linux Command

:: 1 :: Reply #87 Reply By braker On Thu Aug 17, 2006 3:53 pm

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

:: 2 :: Reply #88 Reply By braker On Sun Dec 03, 2006 5:28 pm

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