Backup and Restore MySql Database

MySQL Provides the Basic backup using command mysqldump. This is powerful command and can take backup as a SQL CREATE TABLE and INSERT INTO TABLE commands. The output is in a text file and you can directly run this text file on the command MySQL command prompt for restoring the database.

Backup Database :

Using mysqldump command is one of the way to take backup. This command runs through the windows command prompt or the Linux shell prompt. You can use the command as follows :

C:>\ mysqldump -p -u root --databases db_name > backup1.sql

 

This will prompt you for entering password for the user “root”. After successful authentication and authorization the SQL file “backup1.sql” will be created in your C:\ .

While having this command as a backup tool, MySQL provides the LOCK TABLES , UNLOCK TABLES , DISABLE KEYS and ENABLE KEYS command . This helps you while restoring database.

Me MySelf and I

I am a simple guy originally from a small town Sangameshwar in Maharshtra , India. I had been man places nearby like Dapoli, Chiplun, Ratnagiri. As basically from town , I love the nature more than the busy scheduled cities. but at the same time I invest my most of the time on internet, keeping in touch with technology news. For me most important things are family , relatives and friends.

As a Profession I am a Programmer. I have worked in many technologies under various platforms for past few years. My main expertise are in Java related technologies and related Open source technologies. I have worked on all JAVA editions namely JAVA, J2EE and J2ME. As a web developer I have also worked with the other web development languages such as PHP 5.0 and Ruby on Rails. I have also worked on J2ME , Blackberry as a mobile developer