later is the link to download the script and a class for the report about the results of the backup which was done. On completion the script will inform to the user about the backup results.Īll the lines pointed by an arrow need to be tailored carefully befor running the script. On execution the script will issue a backup with MySQLDump and will write the script to a special directory suffixed with the current date and will issue a report to the user. Mysql backup scheduler windows how to#if you don't know how to do it her is a good tutorial. Definition of a new network location which is linked to your site folder on your host site and name it mySite or any other name. need to be tailored in the PHP backup script later after downloading it.ĥ. Folder definition the for the target MySql Backups. Tablegen class, need to be dowloaded from shopcall and saved as a PHP file in your webspace.ĥ. The COBIAN backup system which is a highly recommended freeware backup solution which we recommend.Ĥ. Definition in Microsoft's Tasks Scheduler to execute Windows batch file.ģ. A Windows Batch File to execute the PHP script and to notify visa a report on the backup results.Ģ. A PHP script which will trigger MySQLDump to perform the backup and to notify the user about success or failure of the backup.ģ. Access to your site(including the MySQL DB) via the PC(need to open ports and etc). Microsoft's OneDrive, business or personal and space depending on your needs.Ĥ. What are the requirements to implement the solution ?ģ. Target backup to Microsoft's OneDrive(Remark: the target can be any other solution like google drive just with only few changes and you are done). SHOPCALL has developed an idea and a system for a MySQL based website that every one with some knowledge in PHP, MySQL and windows can implement it immediately. Mysql backup scheduler windows code#
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |