Who's got some command line goodness for dumping a mysql db on a dev site and then importing and overwriting to my local instance?

the simple: mysqldump -u USER -p DB_NAME > FILE.SQL

seems to have exported fine, producing a nice 82 meg file (which I assume is all the data) but on the import end it didn't seem to write new db fields and/or data.

OMGTHX!

mysql -u user -p -D DB_NAME < FILE.SQL

Should do it, IIRC.

i'm guessing the -D is the key operator there?

Well, the -D, and the less-than sign < that reads the FILE.SQL into the msql command.

yeah, still not importing correctly..weird. I think this MAMP install gives me a weird mysql dump version or something. I don't ahve the option for -D and --add-drop-tables seems to be more of an export functionality.

looks like i have a mysqlimport command. I'm going to explore that. I'm guessing I should be using that

Try not putting a space between the -D and the database name.

i'm just gonna ditch this MAMP crap and set up mysql for real. I've been needing to do it and this is just the reason i need to.

Originally posted by Tha.Riddla

i'm just gonna ditch this MAMP crap and set up mysql for real. I've been needing to do it and this is just the reason i need to.

If you're on mac, check out Sequel Pro. I think it's free and it makes it super easy to move db's around.

Originally posted by RobotDeathSquad

If you're on mac, check out Sequel Pro. I think it's free and it makes it super easy to move db's around.

Just used this...awesome. It's the combo of gui and command line that i need for sure.

:thumbsoup:

Oh, I see how it is. "gui". A soft g I'll bet - like Jewy. Of course, it's always about the Jews because they "command" everything. You fucking fascist.

*stomps off angrily

fack off, ya guibag.

XO

you should be able to use phpmyadmin and export it ... it comes built into MAMP i think...

phpMyAdmin was giving me errors on the import...plus we have disabled it on our live server, so I needed another solution anyway.