MySql database?

[lauraccc]

Hi I have a mysql database that I created on mysql workbench which is running locally on my laptop. I was wondering if it is possible to have this database running on heliohost? Thanks

[wolstech]

Yes. You just need to export it to a .sql file (I'm not sure how you do this on workbench, the docs should explain this though).

 

After that, create an empty database here, then go into phpmyadmin, select the database, then import tab, and upload the file. The structure and data will all import.

[Krydos]

When you dump a whole database one of the first commands in the .sql file is a "CREATE DATABASE dbname;" which will not work through phpmyadmin so you may need to comment that line out. You have to create the database through the cpanel mysql button first. Also keep in mind that all database names have to start with your username and an underscore. So on your laptop your database may be named dbname, but on HelioHost you would have to change it to lauraccc_dbname. Let us know if you have any issues.