mysql database backup

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

mysql database backup

Postby 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?

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

Re: mysql database backup

Postby 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).

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

mysql database backup

Postby 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.

http://sourceforge.net/projects/automysqlbackup/