MySQL Dump

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?

Todd


dynamo mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

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.

Walter


dynamo mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

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.


dynamo mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options