Best way to backup live lampp server
by linuxpc4me from LinuxQuestions.org on (#5HHR8)
Hello!
I have a apache2 / php7.4 / mysql sever on ubuntu 20.04. To prevent me from rebuilding the whole thing again, what is the best way to do a complete nightly backup that can be restored easily? Will I need to do a mysqldump and shut down mysql, then backup, or is there something I can use that will not require this? I heard of TimeShift, Bacula, Rsync, Amanda, etc. I do not want to do a file backup (like dropbox or onedrive) I need a complete backup to restore a production server as simply and quickly as possible.
I even thought of replicating the mysql databases on another machine, and doing multiple sql dumps that would be rsync'd to another machine as well in addition to creating a complete backup of the drive
Thanks for any input


I have a apache2 / php7.4 / mysql sever on ubuntu 20.04. To prevent me from rebuilding the whole thing again, what is the best way to do a complete nightly backup that can be restored easily? Will I need to do a mysqldump and shut down mysql, then backup, or is there something I can use that will not require this? I heard of TimeShift, Bacula, Rsync, Amanda, etc. I do not want to do a file backup (like dropbox or onedrive) I need a complete backup to restore a production server as simply and quickly as possible.
I even thought of replicating the mysql databases on another machine, and doing multiple sql dumps that would be rsync'd to another machine as well in addition to creating a complete backup of the drive
Thanks for any input