backup programs and mysql

[fneergaard]

Hi I have a lot of programs and mysql on my server and I would like to automate backups.

I have a php program and I would like it to maintain and execute a cronjob!

Is it possible?

Frank

[fneergaard]

Re: backup programs and mysql

Please tell why this is giving no feedback...

Thanks

[IndyTim]

Re: backup programs and mysql

I'll not address the cron side of your problem but will respond to the MySQL portion.

There is a backup capability built into the phpMyAdmin MySQL administration. If you use the export portion for each table, it will provide the option to save the export as file. You may select either the structure and/or the contents with a good variation on the structure output.

There is also a backup utility built into the MySQL engine. I believe it is MySQL dump, but I'm not 100% on this as I don't use it.

The other option that you might want to consider if your table sizes are getting quite large is to write a small program to do the data extraction in chunks that are easily handled on a reload.

There are also a lot of backup scripts available written in PHP. One good source if you're interested in pursuing is http://www.hotscripts.com/

Hope this helps.

IndyTim