Web development basic and advance tutorial, php basic tutorial, laravel basic tutorial, React Native tutorial

Thursday, May 14, 2020

Backup and Restore MYSQL Database using Command Prompt

0 comments
Backup and Restore MYSQL Database using Command Prompt


For small business website design and development. Most of common platform is use php and mysql database.in this tutorial I will explain how you can take dump file and restore database using command line (cmd).

Dumping and Restoring  MySQL databases on the Windows command prompt is a simple process.

in windows 10 find with cmd then you can see this screen then right click on the command prompt select Run as Administration.


If MySQL has been added to your Windows path variable, If you open a  mysql command in first time you can see image is like this. It will show error. Check the image link below.



go to the xampp directory C:\xampp\mysql\bin

















No comments:

Post a Comment