Mmm, software

Showing posts with label mysqldump. Show all posts
Showing posts with label mysqldump. Show all posts
Wednesday, August 04, 2010

Quickly dropping all the tables in a MySQL database without dropping the database itself

›
I've recently come across a case where I need to drop all the tables in my database (ie effectively truncate the database) but MySQL has...
Tuesday, August 03, 2010

Quickly dumping a MySQL database out to a file

›
I've found that sometimes, I just need a quick and dirty copy of a database to test changes against, and it doesn't matter if the da...

Piping a MySQL database from one server to another

›
I know that there's a lot of great, wonderful things that can be done on-the-fly through SSH. It's one of the greatest tools out th...
Thursday, January 21, 2010

Dumping just your schema with MySQL dump

›
A simple one-liner : mysqldump -u root -p mydatabasename --no-data=true --add-drop-table=false > test_dump.sql With this command, you...
›
Home
View web version

About Me

Alex Marshall
View my complete profile
Powered by Blogger.