Edit
 by Omololu Adekeye - 5 years ago (2019-07-17)
I want PHP scripts to backup and restore MySQL database on a Mac
 | The PHP scripts will reside on the Webserver root folder on a MacOS server and shall be launched through any client PC browser on a LAN.  | 
Ask clarification
1 Recommendation
This class can backup and restore MySQL database dumping SQL file.
It takes the name of a given MySQL database and connects to a database server using MySQLi. Then it generates a file with SQL statements that can be used later to recreate the database SQL statements in case the it is necessary.
The class can also read a file previously generated by this class, so it can restore the tables and records of a MySQL database that was run the backup process described above.
 |   by Zacchaeus Bolaji   package author   90 - 5 years ago (2019-10-11) Comment
 Once this script is placed in the root folder. You can create a php file to call the class and backup DB, or restore DB by specifying backup path.  |