![]() ![]() GRANT LOCK TABLES, SELECT ON *.* TO IDENTIFIED BY 'PASSWORD' If you want the user to have read access to any database Replace Database with your database name and password with a strong random password, you could also rename mysqldump to a different user. GRANT LOCK TABLES, SELECT ON DATABASE.* TO IDENTIFIED BY 'PASSWORD' I recommend you create a read-only user for reading the database you want to export.Ĭreate user granted to just one database via localhost Export MySQL Databaseįor exporting we will use mysqldump the command if very easy to run If your Droplet has an extremely active database it's worth exporting the data into a static file just before taking a snapshot, this way you guarantee your data is safely backed up and restorable without corruption.įor this guide, we are going to base it on using MySQL but this is possible for any database where you can export into a static file. Did you know that SnapShooter offers support for backing up MySQL on DigitalOcean now? Learn more about MySQL backups
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |