News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

PHPBuilder.com:
Implementing Automatic Database Backup and Optimization in PHP
November 27, 2013 @ 10:52:31

On PHPBuilder.com today they have a new article posted sharing a few different methods you can use to do backups of your (MySQL) database and a few handy tricks/tools you can use to optimize it as well.

Every computer system has a backup. Nevertheless, the number of problems caused by a lack of a recent backup is huge. One of the reasons for that may be the fact that the backup process is not entirely automated. So, let's see how to automate the database backup process in PHP.

There's three recommendations for the (simple) database backup that can produce a file of the current database contents - mysqldump, mysqlhostcopy and a "SELECT INTO OUTFILE" statement. On the optimization size they suggest mysqlcheck, an OPTIMIZE query to help find trouble spots. There's a script included at the end showing how these methods can be combined into a simple PHP script, something that can easily be dropped into a cron job to perform every so often.

0 comments voice your opinion now!
automatic database backup optimization

Link: http://www.phpbuilder.com/articles/databases/mysql/implementing-automatic-database-backup-and-optimization-in-php.html

blog comments powered by Disqus

Similar Posts

MongoDB Blog: MongoDB for the PHP Mind, Part 1

Pádraic Brady's Blog: Automatic Output Escaping In PHP & The Real Future Of Preventing XSS

Quoderat's Blog: Three simple tips for LAMP web site developers

Guilherme Blanco's Blog: register_superglobal("¯name"¯);

Ryan Malesevich's Blog: iTunes Stats for Macintosh with PHP & MySQL Part 2


Community Events





Don't see your event here?
Let us know!


install laravel refactor wordpress podcast introduction api opinion release testing community list interview series threedevsandamaybe language developer unittest framework code

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework