Mysql : restore database using batch file

Question

Some one please correct the below syntax to restore the mysql backup file using command prompt.

"C:\MySQL\MySQL Server 5.7\bin\mysql.exe" -u root -pmypassword source C:/Program Files/Default Company Name/Setup2/Dump20160805.sql

@Drew i am new to mysql and cmd bro. can you help me to resolve the this error mysql> Dump20160805 < Dump20160805.sql ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Dump2 0160805 < Dump20160805.sql' at line 1 — user3796642
– user3796642, Commented Aug 9, 2016 at 4:32
if you want to run mysqldump do it from the os command line, not inside mysql cmd line. So from within mysql cmd line type quit. Then follow a tutorial about mysqldump — Drew
– Drew, Commented Aug 9, 2016 at 4:34

rakhmatov · Accepted Answer · 2016-08-09 05:32:37Z

1

"C:\MySQL\MySQL Server 5.7\bin\mysqldump.exe" -uroot -pmypassword > C:/Program Files/Default Company Name/Setup2/Dump20160805.sql

answered Aug 9, 2016 at 5:32

rakhmatov

3874 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

@lzzat raxmatov i want to restore the database

"C:\MySQL\MySQL Server 5.7\bin\mysql.exe" -uroot database_name -pmypassword < C:/Program Files/Default Company Name/Setup2/Dump20160805.sql

@Lzzat thansk it worked. is it possible to print the out from mysql.exe to cmd?

Yeap you need on windows configure environment path to mysql