How To Backup Database Using MYSQL Dump Linux Command

This Page Contains information about How To Backup Database Using MYSQL Dump Linux Command By braker in category MySQL with 3 Replies. [856], Last Updated: Tue Feb 07, 2023

braker

Thu Aug 17, 2006

3 Comments

8613 Visits

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

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

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

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

How To Backup Database Using MYSQL Dump Linux Command

Related Content

Related Pages