How to export / import MySQL database
Posted by Martin Perron on Jan 27, 2009 in HowTo - Linux • No commentsFor migrate a database or just backing up a database, here’s the howto:
Export:
mysqldump -u username -pThePassword –opt DatabaseName > /tmp/DatabaseName`date +%Y_%m_%d`.sql
Import:
mysql -p -h localhost DatabaseName < DatabaseName.sql
Voilà!
Loading ...