MySQL Database Export and Import by using command prompt || Leela Soft Technologies || Madhu

preview_player
Показать описание
Backup and Restore MySQL Database Using "mysqldump":
How to BACKUP OR Export MySQL database:
1. Backup a single database:
Syntax:

2. Backup multiple databases:
Syntax:
mysqldump -u root -p[root_password] --databases [database_name_1]

3. Backup all the databases:
Syntax:

4. Backup a specific table:
Syntax:
mysqldump -u root -p[root_password] [database_name] [table_name] >

How to RESTORE OR Import MySQL database:
1. Restore a DATABASE
Syntax:
Рекомендации по теме
Комментарии
Автор

Thanks for sharing your knowledge with us sir ❤

groot
Автор

Sir MySQL, SQL
Sir which one is best learning. For beginner sir

thirupathi-veir