Export/Import data

[lpantos]

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.

[webwesen]

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