search

yoichiro / chrome_mysql_admin

ChromeMyAdmin provides you the administration GUI of MySQL server. It is like phpMyAdmin, Sequel Pro.
https://www.eisbahn.jp/chrome_mysql_admin
Apache License 2.0
140 stars 33 forks source link

When pasting in many statements, only the first dozen seem to execute #17

Closed JohnnyBlocks closed 9 years ago

JohnnyBlocks commented 9 years ago

I was migrating a (mostly empty) mySQL database from my old web host to my new.

My process was to 'export' the existing database and data, which generated a big sql file with many statements. I copy/pasted the contents of the file into the query view of 'Chrome MySQL Admin' and when I execute things, only the first dozen (or so) statements seem to execute.

The expected functionality would be to execute all statements. I ended up using the MySQL Admin client from Oracle to perform the task. I pasted the contents of the file in and it executed all statements created the database and restoring all the existing date.

I did not really see anything that mentioned a max number of statements or see anything in the config to control the number of statements.

Other than that, love the product.

yoichiro commented 9 years ago

@YoYo-Pete Could you give me the sql file you ran.?

JohnnyBlocks commented 9 years ago

Here you go sir.

https://raw.githubusercontent.com/YoYo-Pete/chrome_mysql_admin/master/myBB.sql

yoichiro commented 9 years ago

@YoYo-Pete I have already download its file, thus you can delete it. I'll test and try to fix this issue. Thank you for your cooperation.

JohnnyBlocks commented 9 years ago

If there is any other help I can be of, please do not hesitate to ask.

yoichiro commented 9 years ago

I have just released the new version including the diff to fix this issue: https://github.com/yoichiro/chrome_mysql_admin/commit/c8b39545a09b82baa6096aa878fc078466b7a758 @YoYo-Pete When I tried to execute your script, then all SQLs have been succeeded. Thank you for the reporting!