Move Your Database Don’t

As wonderful as Google Cloud is for giving new users $300 to get started, it sure is easy to burn through it. As my credits started getting low, I started to get worried about hosting MySQL Database through Google Cloud. The solution? Move my Database hosting. It sound simpler, turns out it is, if you know where to look.

Most of the articles I could find talking about building from scratch. Since I had a fulled formed database, that is the last thing I wanted to do. All those populated tables, oof, don’t want to loose that work.

The only thing that really matters though it setting it up and the backup, which I didn’t realize when I first tried this. Lucky I had my EER table build, so I didn’t loose everything, but still nightmarish.

Sign up for free GearHost account, click on Database and Create Database

If you choose a name at the top of the page and then select the free option for MySQL and click on “Create Empty Database”

Create Empty Database, just means the host is empty, it will override your current tables!

If you want to use your current database, select Restore Database and select your backup files.

Once you click that button, it will take you to this page:

The name of your database will appear on the top left corner. This is all the information you need to transfer hosting.

GearHost does a great job of exampling the connection process.

All you have to do is insert the information above into your MySQL table.

Log in to your MySQL, go into Manage Server Connections, select the database whose connection you want to alter.

Input the selections as such from your database details page on GearHost:

Hostname: database server name

Port: 3306

Username: username — name you used for the database.

Password: password — click on the left eye icon on the right side to see it.

Make sure to test your connection, take down the Google Cloud if you don’t ant to worry about that license and update your any information on your webpage host if application and your in business!

Hope you find this helpful!

A Full Stack Developer passionate about learning. I love puzzles, problem solving & hang out with my dog. https://highermay.dev/