Thursday, October 22, 2009

Exporting and Importing MySQL Database

1. Export
# mysqldump -u [username] -p [database-name] > [database-name].sql
2. Import
# mysqladmin -u [username] -p create [database-name]
# mysql [database-name] < [database-name].sql

No comments:

Post a Comment

Hi, for all of those who already put comments on my blog post, thanks.. really appreciate it. And for those who have not, just put your comments here :)