I have a SQL instance hosting 117 MySQL databases. A daily routine creates backups of all databases. However, to restore a specific database, I have to restore the entire backup to a new instance, and only then can I download the specific database.
Is there a simpler process that allows me to download just one database from my automatic backup?
Thank you from my heart.
If you just need one database, you don’t have to go through the hassle of restoring the whole backup. You can export that specific database directly to Cloud Storage—either as a SQL dump file or as CSV files. This way, you can download exactly what you need without spinning up a new instance.
Hi @mcbsalceda ,
Thank you very much for your feedback. The references you sent me only show how to download production databases. My goal is to download databases from a Google backup or even download the entire backup.
I can’t find this solution.
Did you ever get a solution for this? We are wanting to do the same, but it doesn’t seem to be possible with GCP, which is pretty odd. Why should we not be able to just download a backup file?
We could issue a dump from the production DB, but that’s very less than ideal, as, even if it’s considered safe, it’s consuming resources from the prod DB.