Mantis Bug Tracker - Forums

Posted: **05 Feb 2007, 19:25**

I have mantis on another box right now and need to find a quick and easy way to get the stuff from my old database into the new one.

Suggestions?

Also, what's the best method to backup mysql databases?

Thanks.

Posted: **05 Feb 2007, 20:06**

Code: Select all

mysqldump --opt -uUSER -pPASSWORD mantisdb > /tmp/mdb
cd /tmp
gzip mdb
scp mdb.gz # copy your db snapshot to a new box
... # on a new box:
unzip mdb.gz 
mysql --force -uUSER -pPASSWORD mantisdb < mdb

Mantis Bug Tracker - Forums

Export/Import data

Export/Import data