I use lunarpages as my host. I’ve had to derive over time how to add databases to Backup Machine.
Here are the steps:
- Click on “add MYSQL database”
- For the database server, fill in the host name or the IP, not localhost. Find the IP on Cpanel (or probably LPCP)
- Fill in the database name
- Fill in user name. (You first have to create a user name in PHPMYADMIN. I suggest creating a username specifically for backupmachine.com)
- The password is whatever you assigned to the user name you just created.
Notes:
If you run into an error, take note of the error message because backupmachine will tell you their IP address in the error message. Then go into Remote MYSQL on CPanel (or probably LPCP) and put backupmachine’s IP address in. Then try again.
In LPCP you can add the IP address on the same page and at the same time as creating the user.
If LPCP assigns your user with an “@” appendage, remove that part of the user name when you type into backupmachine.
If all else fails, add a wildcard to as the Access Host in Remote Database Access Hosts. The wild card is a lone percent sign.
Category: Too good for a category