How to Create mysql database Backup Using Command.

In this tutorials we will learn that how to create mysql database backup using cmd.

1- First of all open cmd.

2- Go to C -> Program Files -> MySql -> MySQL Server 5.7 -> Bin.

3- Copy Bin Directory address like "C:\Program Files\MySQL\MySQL Server 5.7" .

4- Pasted in cmd like "cd C:\Program Files\MySQL\MySQL Server 5.7" hit Enter.

 5- Now try to connect with mysqldump like C:\Program Files\MySQL\MySQL Server                      5.7>mysqldump -h localhost -u root -p databaseName.

 6- Now Create New folder in C: Drive and rename it with "backup" name.

 7- Copy that backup Folder Directory address like "C:\Program Files\MySQL\MySQL Server       5.7>mysqldump -h localhost -u root -p databaseName >C:\backup".

 8- Finally at the end write a database name like "C:\Program Files\MySQL\MySQL Server       5.7>mysqldump -h localhost -u root -p databaseName >C:\backup\databaseName.sql" hit Enter.

 9- Enter your password if you give your correct address which i mention in point 8.

 10- After Enter your mysql server password Now check your backup folder you have successfully create your database backup.

 You can check my video tutorial here also.

Comments

Post a Comment

Popular posts from this blog

The value for column 'IsPrimaryKey' in table 'TableDetails' is DBNull

Image
Video Tutorial In this tutorial we will learn how to fix The value for column 'IsPrimaryKey' in table 'TableDetails' is DBNull error while adding ado.net Entity Data Model. 1- In  below Image i have show that error which occurs during adding ado.net Entity Data Model. 2- Now go to the following Address"Start->All Program->MySQL->MySql Server 5.7 ->MySQL Command Line Client". 3- Run the MySQL Command line Client and Enter your MySql Server Connection Password. 4- Paste Follow Code. set global optimizer_switch='derived_merge=off'; set optimizer_switch='derived_merge=off'; select @@optimizer_switch; select @@GLOBAL.optimizer_switch; 5- Hit Enter two time. 6- Now Once again add Ado.net Entity Data Model and you will notice that your model will generate successfully with the following tables in the database. Remember . After running following code than Restart Visual Studio once again than add ado.net Entity data ...
Read more

How to Disable Skype on Windows Startup.

Image
Video Tutorial to Disable Skype Step by Step.      In this tutorial we will learn how to disable skype when  computer startup. To do this just follow my simple steps. 1- Click on Start button and search for "msconfig". 2- After Opening System configuration Click on startup button. 3- Now you can disable those software which is running during startup. 4- Click on checkbox to uncheck skype option. 5- After apply and ok they will ask to restart your computer and after restarting     you will notice skype will not start. Notice. Your computer will fast when you disable those software which is not necessary to  use when computer startup.  
Read more