Home › Forum › Software › db backup – be aware › Reply To: db backup – be aware

February 9, 2015 at 8:33 pm #1314
vinz
Member

that’s it; what I wanted to say:
You must not use mysqldump for big production databases.

One way would be, to master-slave replicate the DB and dump the copy:
https://dev.mysql.com/doc/refman/5.0/en/replication-howto.html

Other way, the one I’d investigate in, would be XtraBackup.

Btw. Radu, could you install vim, screen and htop on the dev-server? This would enlighten my commandline-feeling.