Wallpapers Forums Login

How To Backup Database Using MYSQL Dump Linux Command

Posted On Thu Aug 17, 2006 By braker In MySQL Forums And Topics Discussions About Open Source Database Forums

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

Information

Forums »
MySQL Forums And Topics Discussions About Open Source Database »
How To Backup Database Using MYSQL Dump Linux Command

Title: How To Backup Database Using MYSQL Dump Linux Command

Description: How To Backup Database Using MYSQL Dump Linux Command

Tags: how ,to ,backup ,database ,using ,mysql ,dump ,linux ,command

Info: This Post Has Been Viewed 0 Times Since
Date: Thu Aug 17, 2006
Author braker Received 3 Replies #856

Linux Shell Command - Mysqldump --opt -u Username -p

How To Backup Database Using MYSQL Dump Linux Command

Related Content

Information

Share