How to Backup and Restore MySQL Database?
Problem
If without MySQL manager installed, how to backup and restore MySQL database?
Solution
Login to MySQL server, open command window, input an run:
Backup MySQL Database
C:\> mysqldump --user=[DatabaseUserName] --password=[Password] [DatabaseName] > [DatabaseBackupFile]
Restore MySQL Database
C:\> mysql --user=[DatabaseUserName] -p [DatabaseName] < [DatabaseBackupFile]
Other Resources
- User Manual
- How to restore your MySQL database from dump file.
Navigator
Other Knowledgebase Articles
Basic SQL Hosting
# of Domains:
4
# of SQL Server Databases:
4
Disk Space:
50GB
Bandwidth:
Unmetered
SQL Server 2016
Monthly:
$4.99
Express Hyper-V Hosting
Dedicated Memory:
2GB
Disk Space:
120GB
Bandwidth:
Unmetered
Windows 2016/2012:
Free
Monthly:
$11.99
Dedicated SQL Server
CPU:
Quad-Core X3440 CPU
RAM:
16GB RAM
Disk:
2x120GB SSD + 300GB SATA
RAID:
RAID 1
Bandwidth:
Unmetered
Windows 2016/2012:
Free
Monthly:
$79.00