jyr / MNPP

Mac + Nginx + Percona + PHP a high performance web server in a one-click installer
http://getmnpp.org
314 stars 49 forks source link

How to copy existing database on MNPP? #41

Closed nathan-zhu closed 11 years ago

nathan-zhu commented 12 years ago

when i reinstall mnpp, i hope can copy old db data to new system, don't need reinstall all db. please help on it. how to do it.

jyr commented 12 years ago

You should runs mysqldump or generate your backup from phymyadmin.local I recommend to use mysqldump, for example:

mysqldump your_db_name > your_backup_name.sql

more information:

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

mrded commented 11 years ago

Also you can use SequelPro app