MySQL

From Ubiquity Web Hosting Wiki

Jump to: navigation, search
  • 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)
  • 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


MySQL Help Topics

Personal tools