Host ( -host= or -h ): The IP address or hostname of the remote database server. For more details about password security, see MySQL’s End-User Guidelines for Password Security. In the password is omitted, mysqldump prompts you for the password before connecting to the database. The password can be entered directly in the command itself (though that is not recommended due to security concerns) or the password can be omitted (by just using the -password option with no value). Password ( -password= or -p): Specifies that the user’s password is required for the connection. This user must have proper grants to access the database. Username ( -user= or -u ): The username of your MySQL user. When backing up a Linode MySQL Managed Database with mysqldump, review the Connect to a MySQL Managed Database guide for instructions on viewing the connection details (including the username, password, host, and port). Multiple specific databases: mysqldump -databases > backup.sqlĪll databases: mysqldump -all-databases > backup.sql Specific tables in single database: mysqldump > backup.sql See Common Command Options for a list of available options. Within the commands, represents all of the command options required to perform the backup according to your own needs. The following list represents mysqldump commands for various scenarios. If mysqldump and mysql are not installed, see the Installing MySQL guide.Įnsure your MySQL user has proper grants: The MySQL user you intend to use to export your existing database must have SELECT, LOCK TABLES, SHOW VIEW, and TRIGGER grants. This should inform you which version you are using as well, needed when referencing the documentation. Run the following command to verify that mysqldump is installed: mysqldump -version This system needs a MySQL command-line client installed (which should come with the mysqldump utility). Log in to the system where you intend to capture or store your backups. For future news and announcements related to Managed Databases, please sign up using the form on our product page. If you have an existing database already deployed, you will continue to be able to deploy, provision, and manage the service exactly as you do today, and we’ll fully support your Managed Database workloads until our next-generation database solution is available. We recognize the need for a product that offers higher performance and the capacity to handle more complex workloads. As part of our ongoing commitment to innovation and better serving our customers, we have made the strategic decision to pause the sale of our Managed Database offering for all customers who do not have an active database deployed.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |