New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL error when importing phpMyAdmin dump file #11368

Closed
foundationphp opened this Issue Aug 8, 2015 · 4 comments

Comments

Projects
None yet
3 participants
@foundationphp
Copy link

foundationphp commented Aug 8, 2015

phpMyAdmin 4.4.13 generates an SQL error when importing from a phpMyAdmin dump file.
#1064 - 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 '_CLIENT=@OLD_CHARACTER_SET_CLIENT */' at line 1

The same dump file imports without problem in 4.4.12.

@lem9

This comment has been minimized.

Copy link
Contributor

lem9 commented Aug 8, 2015

@foundationphp
I confirm the error message but the import works fine for me. Does it for you?

@foundationphp

This comment has been minimized.

Copy link

foundationphp commented Aug 8, 2015

Yes, the import works, but the error message is confusing, particularly for beginners.

@lem9

This comment has been minimized.

Copy link
Contributor

lem9 commented Aug 8, 2015

Bug introduced with 55a2d06

lem9 referenced this issue Aug 8, 2015

Handle comments in the beginning of the query
Signed-off-by: Nisarg Jhaveri <nisargjhaveri@gmail.com>

@Tithugues Tithugues added the bug label Aug 8, 2015

@lem9 lem9 self-assigned this Aug 8, 2015

@lem9 lem9 added this to the 4.4.13.1 milestone Aug 8, 2015

@lem9

This comment has been minimized.

Copy link
Contributor

lem9 commented Aug 8, 2015

Fixed in 4.4.13.1.

@lem9 lem9 closed this Aug 8, 2015

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment