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
Linux Shell Command - Mysqldump --opt -u Username -p
Linux Shell Command - Mysqldump --opt -u Username -p
Post Description:
Post Tags: linux, shell, command, mysqldump, opt, u, username, p, mysql database, support, help, answers, questions, help
This Post Has Been Viewed 1967 Times Since Thu Aug 17, 2006 3:57 pm Posted By hostman with 3 replies
Post Description:
Post Tags: linux, shell, command, mysqldump, opt, u, username, p, mysql database, support, help, answers, questions, help
This Post Has Been Viewed 1967 Times Since Thu Aug 17, 2006 3:57 pm Posted By hostman with 3 replies
| Linux Shell Command - Mysqldump --opt -u Username -p |
I also want to backup my database using mysqdump, I used to use a command that started like:
Code:
But i dont remember the rest of it.
Can you help me to show how the whole commnad looks like?
Thanks
Code:
But i dont remember the rest of it.
Can you help me to show how the whole commnad looks like?
Thanks
Leave Your Comments
Share
URL: 
You can use this HTML code to put it on your website to show your friends this wallpaper. Use this code on your profile like myspace, friendster, Facebook or others. Just Copy and Paste it in your HTML on your websites Fourms BBCODE:
BBCODE is use on forums. You can put this code on all your BBCODE enabled forums like PhpBB, vBulletin® and others. Just Copy and Paste this code on your Posts and Replies on your forums
|
Comments and replies About Linux Shell Command - Mysqldump --opt -u Username -p
:: 1 :: Reply #89 Reply By hostman On Thu Aug 17, 2006 4:00 pm
The command that I know of looks like this:
Code:
Then you will be promted to enter your user password
Code:
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
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
:: 2 :: Reply #62818 Reply By Suneel On Tue Jul 22, 2008 4:18 am
mysqldump -u username -p databasename > sqlfilename.sql
:: 3 :: Reply #69579 Reply By efwrdws On Sat Sep 06, 2008 5:12 am
javascript:submitcj10530333x988('c