The only windows solutions seemed to use php which seemed overly complex, relied on unnecessary systems that could fail, and introduced security concerns when you could use a simple batch file with a few lines of code to accomplish the same task. Set the path to your mysqldump.exe to match your install path; Set the destination of the. Mysqldump is mysql utility for taking logical backup and restore of mysql tables and database. Logical backup means it consist of SQL statements like create table and insert statements. Output format could be sql, CSV, tab delimited or XML.
![]() ![]()
Specify the database you are loading the mysqldump into iwth the -D option (nospace between -D and database bame) mysql -u USERNAME -p -Dmydatabase cd 'C:My Document Names Have Spaces'2) Login to mysql client C:My Document Names Have Spaces mysql -u USERNAME -p3) set yourself to the mydatabase mysql use mydatabase3) load that file mysql source mydump.sqlWatch the fireworks from there!!!Give it a Try!!!
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |