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.
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_
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
c:\MYSQL\bin\mysqldump -u root -padmin --result-file="c:\back\backup_
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