Let mysqldump help you!

I used to dump mysql data using PHPMyAdmin. People should get kicked in the nuts for doing that.

Dumping a (remote) database:

mysqldump -uroot -proot –host=mysql.openminds.be my_database > Desktop/dump.sql

Restoring a database:

mysql -uroot -proot my_database < Desktop/dump.sql

Disclaimer: I know that it’s stupid to set the password in the command, but this is just for the example. /cc @adeepersilence

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Post Navigation