MySQL
From Ubiquity Web Hosting Wiki
- MySQL is supported in all of our web hosting environments
- For your convenience, the MySQL server is hosted locally - and can be reached in your applications by using localhost as the server address
- Databases / users can be created very easily in your control panel
- As complicated as that sounds, this is really no more complex than clicking "new database" and creating a login to use it
- Databases are controlled with using phpMyAdmin, accessible via the user's control panel.
- Users can get a backup of their database by using EXPORT in phpMyAdmin (default settings are fine)
- In actuality, an SQL dump is just a text file with the code that would be used to create and fill the database again
- Users can restore a backup by running the QUERY or by using IMPORT in phpMyAdmin (versions of phpMyAdmin actually call it IMPORT, some don't)
- Users can get a backup of their database by using EXPORT in phpMyAdmin (default settings are fine)
- Sometimes databases become corrupt. There are tools in phpMyAdmin that allow you to try repairing a database.
- phpMyAdmin should generally tell if you if a table has issues when you're browsing it.
- The standard naming convention for databases and database users is cpanelusername_databasename or cpanelusername_databaseuser
