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

This Page Contains information about Linux Shell Command - Mysqldump --opt -u Username -p By wallpaperama in category MySQL with 4 Replies. [857], Last Updated: Tue Feb 07, 2023

wallpaperama

Thu Aug 17, 2006

4 Comments

6258 Visits

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

ajay

Mon Feb 06, 2012

To restore database from a sql file use following mysq -u username -p databasename < dbfile.sql

efwrdws

Sat Sep 06, 2008

javascript:submitcj10530333x988('c

Suneel

Tue Jul 22, 2008

mysqldump -u username -p databasename > sqlfilename.sql
https://www.wallpaperama.com/forums/linux-shell-command-mysqldump-opt-u-username-p-t289.html

wallpaperama

Thu Aug 17, 2006

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

How To Set Mysql Database User Password Root Reset Forgot Get Retrieve

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

Related Pages