This content has been marked as final. Show 3 replies
the MySQL administration tool you used for creating the tables (probably "PhpMyAdmin"), certainly provides an "export" module. Use this one to export the desired tables with/without the data to an SQL file, and import this file into the MySQL administration tool provided by your host, what will be replicating your local tables.
Adobe Community Expert, Dreamweaver
Download the mysql admin gui from here : http://dev.mysql.com/downloads/gui-tools/5.0.html
If your host server allows connections from other hosts you can use the mysql gui to connect to the local database as well as the host database and export the tables to your new database on the host. This is the way I prefer to do it... but some hosts only allow SQL connections from the localhost itself which basically means you won't be able to connect to it using the mysql gui tools.
However you can still generate the database scripts from the gui tools and login to your hosts mysql manager - possibly phpMyAdmin and then simply execute the SQL script.
Hope this helps,
Thank you both for your help. I really appreciate it.