How To Backup Database Using MYSQL Dump Linux Command

RegisterLogin

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

How To Backup Database Using MYSQL Dump Linux Command
Post Description: How To Backup Database Using MYSQL Dump Linux Command
Tags: How, To, Backup, Database, Using, MYSQL, Dump, Linux, Command
This Post Was Posted On Feb 29, 2008 By braker #1459

How To Backup Database Using MYSQL Dump Linux Command by braker

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

Related Pages: [Add Your Website]

Post New Topic

braker

#1888 1

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

Dec 03, 2006 Reply Report abuse

braker

#1887 2

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

Aug 17, 2006 Reply Report abuse