Developing (v7+)

Importing local mySql to live server hanging

Permalink October 23, 2009 at 5:20 PM

Everytime I try to import the mySql dump from my local server into phpMyAdmin on my live server it hangs. I attach a screen dump of my export screen. Not sure what I'm doing wrong but I've only ever had one successful import. What setting should I use to export and import into phpMyAdmin? I use cpanel.

ryan replied on Oct 24, 2009 at 10:59 am Permalink Reply

I've had nothing but problems with moving dbs using phpmyadmin. Last time I messed with this it kept missing large amounts of content.

mysqldump > export.sql
mysql dbname < export.sql

You can also use a desktop client and connect remotely if you host allows that.
I use this on my mac:
http://www.sequelpro.com/