Page 2 of 2

Re: Mysql download script to extract rows from table

Posted: Tue Feb 03, 2009 2:47 am
by kbensch
Hi

For backup I use a sourceforge script called automysqlbackup.

Look for it here:

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

To aut schedule it i either make a copy of it in the cron.daily or create a symlink to it there.

An extract from the SF site: "A script to take daily, weekly and monthly backups of your MySQL databases using mysqldump. Features - Backup mutiple databases - Single backup file or to a seperate file for each DB - Compress backup files - Backup remote servers - E-mail logs - More.."

Kobus

Re: Mysql download script to extract rows from table

Posted: Tue Feb 03, 2009 3:08 am
by Mark Baker
Skoalbasher wrote:Is it possible to do this as a backup? Like download as an excel file or whatnot (this is actually something i need to do), and then upload it back if need be?
It is, but I would suggest that there are far better options for backing up a database than to an Excel file.... including simple CSV.
Excel is better used for formatted data, or for data that requires calculation or formulae.