Instead of specifying one single database name, we could use either –databases or –all-databases to backup every single database on our MySQL server. : The name of the database that we would like the mysqldump utility to backup. password=: The password for the user account mentioned above.
#Mysql backup database code
You can view a list of users and their permissions for your MySQL server by inserting the following code at the MySQL command prompt: use mysql MySQL user accounts are stored in the "user" table of the "mysql" database. user : The -user flag followed by a valid MySQL username tells MySQL the username of the account that we want to use to perform the database dump. Let’s take a look at each of the arguments that can be passed to the mysqldump utility, as shown above: In its simplest form, the mysqldump utility can be used like this: mysqldump -user -password= The mysqldump utility accepts several command-line arguments that you can use to change the way your databases are backed up. The mysqldump utility can usually be found in c:mysqlbin on Windows operating systems, and in the /usr/local/mysql/bin directory on Unix/Linux systems where MySQL is installed. Rather, it creates a set of "CREATE TABLE" and "INSERT INTO" commands that can be executed against a MySQL server to re-create our database(s). I’m using the word "backup" rather loosely here, because MySQL doesn’t actually backup our data per se. The mysqldump utility is a console-driven executable that lets us specify a host of options to backup a database to an external resource, such as a file, or even a completely different MySQL server running on the other side of the world! I’ll also assume that you’ve had at least a small amount of exposure to MySQL and the SQL language syntax. I’ll assume that you have MySQL installed locally on a Windows, Unix or Linux machine, and that you have administrative privileges on that machine. We’ll review several examples using mysqldump, including the backup of your database to a file, another server, and even a compressed gzip file.
#Mysql backup database how to
In this article we’ll look at how to backup your databases using the mysqldump utility that comes with MySQL. As with all other popular database management systems, MySQL offers several methods to backup your important data. MySQL is one of the most popular database management systems for the development of interactive Websites that need to utilize persistent data sources.
0 kommentar(er)
