View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

msql php question

Thread began 3/17/2009 11:57 pm by tlpirc372764 | Last modified 3/25/2009 10:20 pm by tlpirc372764 | 2442 views | 11 replies

Mark Fletcher

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).  

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...