Sep 09 2010
Support Center
»
Knowledgebase
»
How can I backup a MySQL database?
How can I backup a MySQL database?
Solution
/path/to/bin/mysqldump -u $mysqlusername -p$mysqlpassword $mysqldatabasename > backup.sql
OR:
mysqldump -u user -p --opt database > backup_file
Not that there is no space after the -p . If the password was "pass" you would
use -ppass
Article Details
Article ID:
23
Created On:
Mar 07 2008 08:25 AM
This answer was helpful
This answer was not helpful
Back
Login
Username:
Password:
Remember Me:
Search
-- Entire Support Site --
Knowledgebase
Downloads
Article Options
Print Article
PDF Version
Email Article
Add to Favorites
Home
|
Submit a Ticket
|
Knowledgebase
|
News
|
Downloads
Language:
English (U.S.)
Help Desk Software By Kayako SupportSuite v3.50.05
