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