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

|
| Programming tutorials All Knowledge Info and links to posted here |
![]() |
|
Restore MySQL database from a backup file
|
LinkBack | Thread Tools | Display Modes |
|
|
#1 (permalink) |
|
Administrator
Posts: 18,715
Join Date: Jan 2006
Rep Power: 10
IM:
|
mysql -h hostname -u username -pthepassword databasename < dumpfile.sqlHere’s an example: mysql -h localhost -u root -p72aDufi8 db01 < thedumpfile.sql |
|
|
|
|
|
|
![]() |
| 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 |
| Backup Watcher for MySQL 1.9.8.9 | ErrorFix | Application Downloads | 0 | 26-Feb-2008 06:28 PM |
| MySQL Move to Another MySQL Database Software 7.0 | iTouch | Application Downloads | 0 | 26-Feb-2008 07:03 AM |
| MySQL Backup & Restore Databases Software 7.0 | iTouch | Application Downloads | 0 | 26-Feb-2008 06:59 AM |
| Vista Backup and Restore Center | Anilrgowda | Microsoft windows vista error | 0 | 12-Feb-2007 06:59 AM |
| Backup MySQL Database to a file | Anilrgowda | Programming tutorials | 0 | 20-Dec-2006 04:13 AM |