PHPMyBackup - A PHP MySQL differential backup script
A PHP MySQL differential backup script
PHPMyBackup is a PHP script designed for backing up an entire MySQL server on the command line. What makes it unique is it only uses use differential methods to dump only the changes as it keeps a local copy of all the synced databases & tables.
Software features
- Only download changed/altered tables (checksum)
- Allows specifying subset of databases for backups (supports wildcard)
- Allows skipping of specified databases from backups (supports wildcard)
- Allows skipping of specified tables or table-data (supports wildcard)
- Integrates with
mysqldump
client for individual sql dumps - Backup rotation
Limitations
- No database locking during backup. because a separate `mysqldump` is called for every table download, only table locking is used.
- This has been tested in several environments, but your own full testing is always advised!
Requirements
- A MySQL user on the server with ‘SELECT’ & ‘LOCK TABLES’ permissions
tar
withxz
support (used for compressing backups)- PHP CLI on backup host with MySQLi support
mysqldump
(used for actual table dumping)
Usage Example
require('phpmybackup.php');
$db = new MYSQL_DUMP;
$db->dbhost = 'server.com';
$db->dbuser = 'backup-user';
$db->dbpwd = 'backup-password';
$db->backupsToKeep = 30;
$db->showDebug = false;
$db->backupDir = '/mnt/backups/mysql/';
$db->ignoreDatabases = ['test','unimportant_db'];
$db->emptyTables = ['largedb.large_table1','largedb.cachetable'];
$db->dumpDatabases();
- The above command will dump all databases except for
test
andunimportant_db
fromserver.com
- The data from two tables,
large_table1
&cachetable
, (found in databaselargedb
) will be ignored, however the table structure will be backed up. This is especially handy if you have temporary tables or large tables which contain unimportant / cached data. - A total of 30-days of backups will be kept. Note: Backups are named by date (yyyy-mm-dd.tar.xz), so a maximum of 1 backup per day can be kept. If the script is re-run on the same day, the repository is synced and the existing daily backup overwritten.
Notes
By default all databases are backed up (
$db->includeDatabases = ['*']
). You can limit this to a subset of your databases if you like.
Package of more pieces of information. Thank you.
ReplyDeletePHP Course in Madurai
PHP Training Institutein Madurai
PHP Training in Madurai
PHP Course in Coimbatore
PHP Training Center in Coimbatore
PHP Training Institute in Coimbatore
Thanks to the admin for sharing this blog as I am able to get an idea of more updates in a clear way.
ReplyDeleteComputer Education Franchise
Education Franchise India
Computer Center Franchise
Education Franchise Opportunities in India
Education Franchise India
Spoken English Franchise
Franchise For Spoken English Classes
Top Education Franchise in India
Best Education Franchise in India
Thanks for your efforts in sharing this information in detail. This was very helpful to me. kindly keep continuing the great work.
ReplyDeleteSpoken English Class in Anna Nagar
Spoken English Class in Porur
Spoken English Class in T Nagar
Spoken English Class in Adyar
Spoken English Classes in Chennai
Best Spoken English Classes in Chennai
IELTS Coaching in Chennai
IELTS Coaching Centre in Chennai
English Speaking Classes in Mumbai
IELTS Classes in Mumbai
Oh my goodness! Amazing article dude! Many thanks, However I am encountering problems with your RSS. I don’t understand why I can't subscribe to it. Is there anyone else having the same RSS issues? Anyone who knows the solution will you kindly respond? Thanks!! Click Here for more
ReplyDelete"NICE
ReplyDeleteDigital Marketing Training Course in Chennai | Digital Marketing Training Course in Anna Nagar | Digital Marketing Training Course in OMR | Digital Marketing Training Course in Porur | Digital Marketing Training Course in Tambaram | Digital Marketing Training Course in Velachery
"
That's great information. Thanks for sharing this blog. I did a search and found your blog and glowing review. It's been a big help! Thanx for sharing
ReplyDeleteDigital Marketing Training Course in Chennai | Digital Marketing Training Course in Anna Nagar | Digital Marketing Training Course in OMR | Digital Marketing Training Course in Porur | Digital Marketing Training Course in Tambaram | Digital Marketing Training Course in Velachery
If you are interested in PHP Job Script Solutions but you need small customizations. So you need to do it? Do we offer access to source code? Yes, we can give the entire access to source codes so that you can customize as per your own ideas whatever you need in design-wise or else functionality wise.
ReplyDeleteNice post, i hope really gather more informative information,thanks for sharing such a great information.
ReplyDeletePHP Online Training
PHP Online Course
PHP Online Training in chennai