Many php applications prefer to backup the mysql database from within the application and save it as an archive.
The mysqldump commandline utility can be used to perform this function of backing up a mysql database as sql file.
The command would be like this :
The above command shall dump the database named $db_name into a sql file in directory $dir. This sql file shall be next zipped using php's Ziparchive class.
In the above example backups/backup.sql is the path to the sql fil...
Thank you for taking the time to visit my blog! Take a second to peek around and check out some of my previous posts. Of course, I would love to find out what you think as well, so make sure to comment. See you around!