Fail to re-import .sql file generated by batch script

Question

I am using the following Batch script.

It generates a .sql file with same size as the one i get when i manually use the mysqldump command from the command line.

However, when i try to load this .sql to a database using :

mysql -u root -p db < file.sql

It does not load anything, no db tables/files are created. Is there an error in the script? or am i missing something?

That script creates a zip file compressed with 7-zip, how could you load it? — Steve
– Steve, Commented Jul 28, 2012 at 21:32
i use 7-zip to unzip archive, then this is how i get the .sql file. — ccot
– ccot, Commented Jul 28, 2012 at 21:36
i will change the feature of this script to create directly .sql file instead of zip, but for now i am unzipping manually. — ccot
– ccot, Commented Jul 28, 2012 at 21:37
You should try to load the SQL in some kind of management tool and try to execute from there. Usually these tools gives a nice hint of what is wrong. Sorry, but I am not a mysql expert (Still using the old MySql Query Browser). — Steve
– Steve, Commented Jul 28, 2012 at 21:42
@Steve i fixed it, if you want check my answer provided below. — ccot
– ccot, Commented Jul 28, 2012 at 22:51

ccot · Accepted Answer · 2012-07-28 22:50:05Z

1

For anyone in the same situation, here is what i did and it worked:

I replaced the line:

set mysql_path="......\bin"

By:

set mysql_path="......\bin\mysqldump"

And the line:

%mysql_path%\mysqldump.exe --user %mysql_username% --password=%mysql_password% 
--all-databases --opt > "%output_path%\%date%_%time%.sql"

By:

%mysql_path% -u %mysql_username% -p%mysql_password% %dbname% >
%output_path%\%date_time%.sql

And now it is working.
I do not really know why it didn't work using the previous method, if you know why feel free to comment so we can all understand.

answered Jul 28, 2012 at 22:50

ccot

1,8733 gold badges37 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

Fail to re-import .sql file generated by batch script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related