lauraccc Posted February 18, 2019 Share Posted February 18, 2019 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 Quote Link to comment Share on other sites More sharing options...
wolstech Posted February 18, 2019 Share Posted February 18, 2019 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. Quote Link to comment Share on other sites More sharing options...
Krydos Posted February 18, 2019 Share Posted February 18, 2019 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.