Mysql download script to extract rows from table

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

kbensch
Forum Newbie
Posts: 6
Joined: Thu Jan 29, 2009 11:42 am

Re: Mysql download script to extract rows from table

Post 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
Mark Baker
Forum Regular
Posts: 710
Joined: Thu Oct 30, 2008 6:24 pm

Re: Mysql download script to extract rows from table

Post 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.
Post Reply