Linux Shell Command - mysqldump --opt -u username -p

RegisterLogin

Webune Forums » MYSQL » Linux Shell Command - mysqldump --opt -u username -p

Linux Shell Command - mysqldump --opt -u username -p
Post Description: Linux Shell Command - mysqldump --opt -u username -p
Tags: Linux, Shell, Command, -, mysqldump, --opt, -u, username, -p
This Post Was Posted On Feb 29, 2008 By web hosting #1460

Linux Shell Command - mysqldump --opt -u username -p by web hosting

I also want to backup my database using mysqdump, I used to use a command that started like:

Code:

mysqldump --opt -u username -p

But i dont remember the rest of it.

Can you help me to show how the whole commnad looks like?

Thanks

Leave Your Comments

Related Pages: [Add Your Website]

Post New Topic

hostman

#1889 1

The command that I know of looks like this:

Code:

mysqldump --opt -u username -p db_name | gzip > backup_file_name.sql.gz

Then you will be promted to enter your user password

Code:

Enter password:

if you want to know more information on how to backup and restore a mysql database, i think this post is better, it will take you into two simple steps. in this scenario, a customer was moving from one server to another server.

http://www.wallpaperama.com/forums/how-to-backup-and-restore-entire-whole-mysql-database-linux-shell-command-t730.html

hope this helps

Aug 17, 2006 Reply Report abuse