mysql database backup

Support for webhosts that use CentOS
Post Reply
Posts: 74
Joined: 2007/11/05 16:08:34
Location: Pune

mysql database backup

Post by hi_vkkadam » 2007/11/27 15:34:18

I have one question about mysql database backup, i have huge database in my mysql server
i taken backup through phpMyadmin, and using command line import into another system in same database,
but my website's performance is slow, also some tables not working properly,
can i take backup through phpMyadmin or using command line mysql database backup command?

Posts: 2629
Joined: 2007/01/07 02:18:02
Location: Central IL USA

Re: mysql database backup

Post by pjwelsh » 2007/11/27 17:20:41

"mysqldump" is the command line default tool for doing what you ask. There are alot of options to consider. Please read the man page for it and google for more generic mysql help.

Note: if it's large, compress the archive with bzip2 (or pbzip2 for multi-cpu bzip action).

Posts: 1478
Joined: 2006/05/29 16:50:11
Location: San Francisco, CA

mysql database backup

Post by michaelnel » 2007/11/27 20:24:16

I use "automysqlbackup", which is a script that makes several generations of daily, weekly, and monthly backups. It uses mysqldump, but wraps it in a bunch of badly needed features.

Post Reply

Return to “CentOS 4 - Webhosting Support”