mysql backup restore suggestion
Posted: Mon Dec 10, 2007 10:30 am
I'd like to make a full backup of one mysql i386 server:
/usr/bin/mysqldump -uusr -ppwd --single-transaction --all-databases > /home/dump.sql
and restore it on an x64 one.
Is it a safe operation or the best result will be a messy ?
What do you suggest to backup/restore databases ?
/usr/bin/mysqldump -uusr -ppwd --single-transaction --all-databases > /home/dump.sql
and restore it on an x64 one.
Is it a safe operation or the best result will be a messy ?
What do you suggest to backup/restore databases ?