![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]()
![]() |

|
| Programming tutorials All Knowledge Info and links to posted here |
![]() |
|
Backup MySQL Database to a file
|
LinkBack | Thread Tools | Display Modes |
|
|
#1 (permalink) |
|
Administrator
Posts: 18,715
Join Date: Jan 2006
Rep Power: 10
IM:
|
Syntax: mysqldump -h localhost -u root -pmypassword databasename > dumpfile.sqlExample: mysqldump -h localhost -u root -p2Uad7as9 database01 > dumpfile.sqlThis will give you a text file containing all the commands required to recreate the database. |
|
|
|
|
|
|
![]() |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| MicroOLAP Database Designer for MySQL 1.9.6 | ErrorFix | Application Downloads | 0 | 26-Feb-2008 06:53 PM |
| Backup Watcher for MySQL 1.9.8.9 | ErrorFix | Application Downloads | 0 | 26-Feb-2008 06:28 PM |
| Sync Database MySQL Edition 3.2 | ErrorFix | Application Downloads | 0 | 26-Feb-2008 08:11 AM |
| MySQL Move to Another MySQL Database Software 7.0 | iTouch | Application Downloads | 0 | 26-Feb-2008 07:03 AM |
| Restore MySQL database from a backup file | Anilrgowda | Programming tutorials | 0 | 20-Dec-2006 04:12 AM |