Archive for the ‘Php’ Category

Schedule database backup wamp

Posted: August 2, 2016 in Php
0

Below are the simple step to create the database backup
step-1 Create bat file like test.bat
Step-2 Copy the below code to bat file

@echo off
set TIMESTAMP=%DATE:~10,4%%DATE:~4,2%%DATE:~7,2%
c:\wamp\bin\mysql\mysql5.6.12\bin\mysqldump –user=root –password= –result-file=”C:/wamp/backup/databases.%TIMESTAMP%.sql” databasename

Step-3 scheduling bat file
>> Go to all program >>Accessories>>system tool>>Task Schedular
>> Create basic task
>> Specify name description then go to next
>> In this step there is an option to schedule backup like daily,weekly etc
>> Go to next step and there is an option to set the time
>> Go to the next step and select start a program and go to next
>> and select the bat file where you have save and click on finish.

Now you have completed all the task to take the database backup

if you want to test it then follow the below step
Step-1 Click on task schedular library it will list all schedule task
Step-2 select the task that you have created and click on run it will create the file on backup location