I’m trying to duplicate my remote db locally with MAMP and Sequel Pro.
Using SP I did a MySQL dump of a table (call it ‘beta’) and then tried
to import the table data into my local db (call it ‘alpha’) using
phpMyAdmin in MAMP. Not happening so far. Seems like it should be
pretty straightforward, what am I missing?
If you dumped the entire database, then you might not have the actual table definition parts done yet. In Sequel Pro there’s a nice command that will get that part for you:
Main menu: Table / Show Create Table Syntax
You’ll need to do this for each table, run it in phpMyAdmin first, then restore from the dump.
I have the table definition parts all set but I still can’t get the
data into the table. I exported the data as sql and csv files but no
luck importing either.
Todd
On Feb 18, 2009, at 3:23 PM, waltd wrote:
If you dumped the entire database, then you might not have the
actual table definition parts done yet. In Sequel Pro there’s a nice
command that will get that part for you:
Main menu: Table / Show Create Table Syntax
You’ll need to do this for each table, run it in phpMyAdmin first,
then restore from the dump.