MySQL Database Export and Import by using command prompt || Leela Soft Technologies || Madhu
Backup and Restore MySQL Database Using "mysqldump":
How to BACKUP OR Export MySQL database:
1. Backup a single database:
Syntax:
mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql
2. Backup multiple databases:
Syntax:
mysqldump -u root -p[root_password] --databases [database_name_1]
[database_name_2] .... > dumpfilename.sql
3. Backup all the databases:
Syntax:
mysqldump -u root -p[root_password] --all-databases > dumpfilename.sql
4. Backup a specific table:
Syntax:
mysqldump -u root -p[root_password] [database_name] [table_name] >
dumpfilename.sql
How to RESTORE OR Import MySQL database:
1. Restore a DATABASE
Syntax:
mysql -u root -p[root_password] [database_name] < dumpfilename.sql