Skip to content
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

Error in Windows path separator '\' when import .sql file in phpMyAdmin #79

Open
lucas-viewup opened this issue Sep 22, 2017 · 0 comments

Comments

@lucas-viewup
Copy link

lucas-viewup commented Sep 22, 2017

Hi, I noticed that in when you migrate db to Windows, for example:

/srv/mywebsiteC:\xampp\htdocs\mywebsite

When you go to import in phpMyAdmin, it throws this error:

Static analysis:
12 errors were found during analysis.
Unexpected character. (near "\" at position 0)
Unexpected character. (near "\" at position 1)
Unexpected character. (near "\" at position 2)
Unexpected character. (near "\" at position 3)
Unexpected character. (near "\" at position 4)
Unexpected character. (near "\" at position 5)
Unexpected beginning of statement. (near "\" at position 0)
Unexpected beginning of statement. (near "\" at position 1)
Unexpected beginning of statement. (near "\" at position 2)
Unexpected beginning of statement. (near "\" at position 3)
Unexpected beginning of statement. (near "\" at position 4)
Unexpected beginning of statement. (near "\" at position 5)
Comando SQL:
\\\\\\ /*!40101 SET NAMES utf8mb4 */
Mensagens do MySQL : Documentação
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\\\\\\
/*!40101 SET NAMES utf8mb4 */' at line 1

But when you remove the line within .sql:

 Path: C:\\xampp\\htdocs\\mywebsite

The import becomes successful, but I didn't realise yet why PMA blocks commented '\' separator.
Regards,

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant