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
Mysql download script to extract rows from table
Moderator: General Moderators
-
Mark Baker
- Forum Regular
- Posts: 710
- Joined: Thu Oct 30, 2008 6:24 pm
Re: Mysql download script to extract rows from table
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.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?
Excel is better used for formatted data, or for data that requires calculation or formulae.