ERROR 1064 (42000) in MySQL

I am trying to populate a new MySQL empty database with a db dump created from MS SQL Azure database, and I get the following error

ERROR 1064 (42000) at line 1: 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 ‘I ‘ at line 1

I used mysqldump to perform this operation and used command similar to the following in the command prompt:

mysql --user=rootusername --pasword=password databasename < dumpfilename.sql

Mysqldump took about 30 minutes to display this error message.

Related Posts:

  1. Azure az login with tenant
  2. What is Azure Service Principal?
  3. What is Azure Cloud Service?
  4. How can I fix MySQL error #1064?
  5. Example of Get-AzureADUser [-Filter ] command
  6. mysql is not recognised as an internal or external command,operable program or batch
  7. What is the difference between IAM and Azure AD on the azure cloud?
  8. MySQL Error #1133 – Can’t find any matching row in the user table
  9. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  10. How to delete from multiple tables in MySQL?
  11. Could not find a ready tiller pod (Error)
  12. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  13. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  14. How to use mysqli_query() in PHP?
  15. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  16. Unknown column in ‘field list’ error on MySQL Update query
  17. Unknown column in ‘field list’ error on MySQL Update query
  18. How to log in to phpMyAdmin with WAMP, what is the username and password?
  19. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  20. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  21. Column count doesn’t match value count at row 1
  22. Undefined function mysql_connect()
  23. A JNI error has occurred, please check your installation and try again in Eclipse x86 Windows 8.1
  24. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  25. MySQL column count doesn’t match value count at row 1 [closed]
  26. MySQL string replace
  27. Cannot add or update a child row: a foreign key constraint fails
  28. Undefined function mysql_connect()
  29. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  30. Fatal error: Call to undefined function mysql_connect()
  31. String concatenation in MySQL
  32. Should I use mysqli_real_escape string() or mysql_real_escape_string() for form data?
  33. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
  34. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  35. Connect-AzAccount – how to avoid azure device authentication?
  36. MySQL – Operand should contain 1 column(s)
  37. Can’t connect to MySQL server on ‘localhost’ (10061) after Installation
  38. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  39. Cannot add or update a child row: a foreign key constraint fails
  40. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  41. MySQL Error “Operand should contain 1 column”
  42. MySQL create table if not exists and insert record only if table was created
  43. Rename a table in MySQL
  44. Can’t connect to MySQL server on ‘localhost’ (10061) after Installation
  45. getting error HTTP Status 405 – HTTP method GET is not supported by this URL but not used `get` ever?
  46. How to use MySQL DECIMAL?
  47. Access denied for user ‘root@localhost’ (using password:NO)
  48. How should I tackle –secure-file-priv in MySQL?
  49. How do I use MySQL through XAMPP?
  50. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  51. How to make MySQL table primary key auto increment with some prefix
  52. Access denied for user ‘root@localhost’ (using password:NO)
  53. MySQL ERROR 1290 (HY000) –secure-file-priv option
  54. How do I use properly CASE..WHEN in MySQL
  55. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  56. Fatal error: Call to undefined function mysql_connect()
  57. error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’ — Missing /var/run/mysqld/mysqld.sock
  58. MySQL error 2006: mysql server has gone away
  59. Which MySQL data type to use for storing boolean values
  60. How can I do a FULL OUTER JOIN in MySQL?
  61. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  62. sql query with multiple where statements
  63. Fatal error: Call to undefined function mysql_connect()
  64. error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’ — Missing /var/run/mysqld/mysqld.sock
  65. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  66. MySQL query String contains
  67. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  68. What’s the difference between VARCHAR and CHAR?
  69. Cannot delete or update a parent row: a foreign key constraint fails
  70. Cannot delete or update a parent row: a foreign key constraint fails
  71. What is the error “Every derived table must have its own alias” in MySQL?
  72. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  73. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  74. PDOException SQLSTATE[HY000] [2002] No such file or directory
  75. Case statement in MySQL
  76. http://localhost:80 is not working on running Apache server through UniServer ZeroXIII
  77. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  78. PDOException SQLSTATE[HY000] [2002] No such file or directory
  79. MySQL server startup error ‘The server quit without updating PID file’
  80. Rename a column in MySQL
  81. Configuration System Failed to Initialize
  82. How to declare a variable in MySQL?
  83. Can’t find mysqladmin on Mac OSX 10.6.8
  84. Mysql query- How to use contains?
  85. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  86. Cannot delete or update a parent row: a foreign key constraint fails
  87. Export Pervasive to MySQL (C#)
  88. MySQL Every derived table must have its own alias
  89. MySQL Cannot Add Foreign Key Constraint
  90. A JNI error has occurred, please check your installation and try again in Eclipse x86 Windows 8.1
  91. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  92. MySQL server startup error ‘The server quit without updating PID file’
  93. How do I restore a dump file from mysqldump?
  94. Syntax error due to using a reserved word as a table or column name in MySQL
  95. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  96. MySQL root password change
  97. Deprecated: mysql_connect()
  98. Installation of MySQL for Visual Studio 1.2.8 failed
  99. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in
  100. Not unique table/alias

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)