Hi there,
Thanks for the heads up on HiediSQL. Another app that I have used in the past is NaviCat from Premium Soft. This is a great commercial application for creating, managing and transferring.
You can learn more about NaviCat from the web address I have included below.
index.html
As I mentioned in my last post we will aim to include coverage of transferring a MySQL database to a remote server in the next version of the Database Starter Kit for PHP.
Originally Said By: mrs256259
Basically, there are two ways that I know of in which you get your MySQL db uploaded. The first is through phpMyAdmin which is hosted on your hosts servers. You log in there and simply paste the dumped MySQL code in to the SQL pane and click go... database uploaded. The second is use use something like HiediSQL which is a free GUI (google it). You log on to the remote server through the HiediSQL application on your local PC and paste your sql... remotely.With HiediSQL, I build all of my databases locally, enter content into the tables and then build my sites. It's dead easy to build a site this way as you can see exactly what you're doing and you have content to test with. Once built, I export the database as sql, open it in wordpad, copy the dumped sql, use HiediSQL to log on to the remote server and simply paste the sql and click go (well, actually, it's a triangle, but you get my point).
