Simple: use mysqldump (Linux CLI software, available on most webservers) to dump the database to a .sql-file and copy it to you backup location using you favourite tool (in my case: duplicity to write encrypted and signed backups to off-site backup servers).
I can't think of an easy way to make incremental backups... maybe someone else has some ideas about it.
I personally use Zmanda Community edition.
You're going to have to set up a cron job for that. I set my cron job up to execute the artisan command provided in this library:
https://github.com/CoreProc/laravel-db-backup
This library gives you the option to upload your database backup to Amazon S3 and specify a data retention duration.
Backing up your default database in laravel is as easy as executing this artisan command once you have this library installed:
php artisan db:backup
If you need help with the cron job, let me know.
I'm using http://sourceforge.net/projects/automysqlbackup/ on my homestead dev, though it should work with most any linux server.
On my dev vm I have it configured to backup the database on vm shutdown and it creates the daily/weekly/montly archive structure.
From my opinion you can use CloudBacko (http://www.cloudbacko.com/mysql-backup.jsp?r=1d) MySQL database backup solution. CloudBacko is one of the fastest cloud and local backup software for MySQL Database available in the market because of its built-in speed boosting technologies. I hope this will be helpful for you.
chrisbjr said:
You're going to have to set up a cron job for that. I set my cron job up to execute the artisan command provided in this library:
https://github.com/CoreProc/laravel-db-backup
This library gives you the option to upload your database backup to Amazon S3 and specify a data retention duration.
Backing up your default database in laravel is as easy as executing this artisan command once you have this library installed:
php artisan db:backup
If you need help with the cron job, let me know.
Can you help me with the cron job please ?
You can use https://github.com/sebastianfeldmann/phpbu Create a phpbu config file (check http://phpbu.de for a getting started tutorial) In combination with a cronjob Edit your crontab file
$ crontab -e
Add a line like this
13 4 * * * phpbu --configuration=/var/www/myProject/backup/phpbu.xml
Backup will run every day at 4:13 With phpbu you can Monitor your Backup creation and send emails if something is going wrong You could even easily sync your backups to cloudservices like dropbox or copy.com or just another server of yours with rsync or sftp.
I've made a Laravel 5 package that provides you with an artisan command to backup not only your database but also your entire application: https://github.com/freekmurze/laravel-backup
The backup is a zipfile that contains all files in the directories you specify along with a dump of your database. The backup can be stored on any of the filesystems you have configured in Laravel 5.
As my personal experience i would like to suggest Ahsay backup software(http://www.ahsay.com/jsp/en/ho.....&r=1d) for VMware backup. Ahsay Unifies VMware Virtual Machines Backup. Ahsay VMware backup module is designed for using in conjunction with AhsayOBM for fast and secure backup of guest virtual machines in VMware vSphere (ESX / ESXi), Server, Workstation, Fusion, and Player. VMware vCenter is supported by the latest AhsayOBM. Therefore, backup can be done with or without vCenter, depending on your configuration. The ONLY solution that supports ESXi Free version. VDDK / non-VDDK backup mode supported. Fast backup with VMware Changed Block Tracking (CBT) technology. VMware vCenter supported. Virtual machine hot backup. Fast multi-thread backup. In-File Delta incremental backup.
simple, just run an rsync command for the mysql data folder once in a while. If you have a huge database, running mysqldump will slow the server. rsync or cp will just copy the database file and is faster.
If you want alternative then try Ahsay Backup Software. I use this software for backup. Ahsay Backup Software comes with dedicated backup modules for backing up VMware ESXi (both paid and free versions), Microsoft Hyper-V, Microsoft Exchange Server DAG, Microsoft Exchange Server database, Microsoft Exchange Server individual mailboxes, Microsoft SQL Server, MySQL Database, Oracle Database, Lotus Domino / Notes, Windows System and Windows System State. Other applications and databases such as Microsoft Sharepoint can also be backed up using our flexible command line tool. You can check this software too. Thanks and check this software http://www.ahsay.com...s_overview&r=1d
We are very found of Backup Bird (https://www.backupbird.com)
It can backup MySql, mariaDb and other databases and also backups your files.
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community