Re: MySQL backup

From: "Matthew Oatham" <matthewoatham@hotmail.com> > > > I am using MySQL database accessed via myphp admin - > > > there is an export option which allows me to export the structure > > > and data to an sql file but this is a manual procedure is there > > > anyway to automate this via myphp admin i.e. using a cron job? > > > > The mysqldump program in the mysql/bin folder is used for this. Make a > > call to it through cron or a PHP script. > > Mmmm my provider doesn't give me access to this area ! I would double check and ask them about that, but if that's really the situation, then look on phpclasses.org or hotscripts.com for a script that emulates mysqldump. Or, not sure on this one, see if you can just get a copy of the program and place it in one of your own directories to run. It comes with MySQL. ---John Holmes...