Tag Archives: MySQLDump

How to save a MySQL Database quickly with MySQLDump in Linux?

mysql-backup

Summary:

In a previous tutorial, we have seen how to save a MySQL Database with MySQLDump in Windows (WAMP). Today, we will see the quickest way to save a MySQL Database in Linux. For information database, the backup can also be done through a script which allows saving a database or set of databases. But the script can be a little too complex for easy to use tool for backup, natively available in MySQL. So here, we are going to see how to save a MySQL database by using Linux command line.

So we will use the command line for mysqldump that can save a database to store it in a .sql file that can be back later as well. In short, the sql file will contain a set of commands that, when it will be read by MySQL and will present the data to its original state (when it was backed up). MySQLDump is directly included in the installation of a MySQL Server. Suppose I want to save the database “bod007″ 🙂 in the file “bod007_nil84aug.sql”, I will use the following command:

read more

Posted in FAQs | Tagged , , , | Comments Off on How to save a MySQL Database quickly with MySQLDump in Linux?

How to Save a Database with MySQLDump in WAMP?

database-backup-in-wamp
Summary

Today, we will learn how to save a MySQL database on Windows environment, after installing a web server WAMP. We will use a native tool that comes with MySQL i.e. MySQLDump.

In this tutorial, we are going to use WAMP 2.5 and will name the backup as “mydb”.

Database Saving

We will have to open a Windows command prompt. Building on the executable “mysqldump” then can quickly backup a database.

We jump by assigning the directory where the executable file is located and then mysqldump.exe with the –u option to the user name, –p option to be asked the password and following your options as it is necessary to indicate the name of the database. Then the end of the line to record the output to a file named “mabase.sql” and located the directory “C:\Backup”.

read more

Posted in FAQs | Tagged , , | Comments Off on How to Save a Database with MySQLDump in WAMP?