- Install cPanel on a Virtual Server Running CentOS 6 with 7 Simple Steps
- Clear Your System Cache in Ubuntu with These Quick Steps
- Install MariaDB on CentOS 7 with these Simple Steps
- What is an A Record?
- Smartermail vs. Mailenable – What does it hold for you?
- Common Issues with Website Migration
- Tips to Evade Spamming
- Dirty Cow Vulnerability – Check How Dirty It Is?
- It’s Time to Update Your Server
- How to Change the Listening Port for Remote Desktop?
Tag Archives: mysql backup with mysqldump
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: