Skip to main content

Posts

Showing posts with the label Set batch file which schedules dump from database in MYSQL

Set batch file which schedules dump from database in MYSQL

Set batch file which schedules dump from database in MYSQL To Set batch file which schedules dump from database in MYSQL you can try following way. echo Running dump... c:\MYSQL\bin\mysqldump -u root -padmin --result-file="c:\back\backup_ %date%.sql" db_dm echo Done! Placing MySQL database from local computer to host You Can place MySQL database from local computer to host by following steps. Import/export file first export the database click on export tab you'll get the query for whole database copy it and paste in notepad save it with .sql extension then open your server control panel go to phpmyadmin and import the saved sql file