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. Fatal error: Call to undefined function mysql_connect()
  13. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in
  14. Not unique table/alias
  15. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  16. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  17. MySQL – UPDATE query based on SELECT Query
  18. How do I change the data type for a column in MySQL?
  19. How to round down to nearest integer in MySQL?
  20. MySQL error: key specification without a key length
  21. How to properly create composite primary keys – MYSQL
  22. Will it break my site if I delete all transient records in wp_options table?
  23. Retrieve featured image
  24. Automatically delete inactive users after 2 months
  25. Can I use MariaDB instead of MySQL in wordpress?
  26. How to disable `SQL_CALC_FOUND_ROWS` [duplicate]
  27. Convert WordPress posts to products in WooCommerce
  28. Custom SQL query to get List of posts with featured image url
  29. Ordering Post 2 Post admin meta box by meta from CPT
  30. Delete post revisions on post publish
  31. Problems migrating WordPress to localhost
  32. Custom DB_COLLATE (collation) value not working on fresh install?
  33. Export only pages and posts with mysql dump
  34. What causes the “max_user_connections” warning on WordPress frontend?
  35. WordPress Deadlock Error
  36. How to do a MySQL dump from production site without using a search and replace script for local development?
  37. Is the usage of ON DELETE CASCADE wrong or not allowed on wordpress?
  38. Concurrent / simultaneous MySQL connections
  39. How to check for empty and not a failure
  40. How many ‘wp_insert_post’ calls can be performed in one shot, in a very long ‘for’ loop?
  41. Mass convert MySQL data entries into custom post type?
  42. Mysql query LIKE not working
  43. How to write one comment and publish on every post using database or plugin?
  44. Bulk activate a theme on multisite
  45. Bulk edit existing shortcode within custom field
  46. How to simultaneously access the same MySQL database in the main column and sidebar of WordPress?
  47. Bulk create clean user_nicename from user_email with SQL function
  48. pagination with ‘no_found_rows’ => true,
  49. WordPress php mysql errors – errcode: 13 permission denied
  50. Switching Databases in LocalHost
  51. get_posts() and WP_query limits ‘AND’ conditions to a maximum of 6 for meta value queries in WordPress
  52. $wpdb select all meta for each post
  53. Unable to set a default serialized array using dbdelta()
  54. Replacing link URL ending strings via MySQL
  55. WordPress Query wp-terms SLOW
  56. How to Mysql select a list of posts with meta_values AND all relevant categories?
  57. How to stop $wpdb from prepending database name
  58. How to do database for download stats?
  59. How can I add a new row in a separate database when someone registers via WordPress?
  60. Get posts from category with custom query
  61. How to use mysql LIKE with wpdb?
  62. Best approach for a custom database filling in WP custom post types
  63. speed up pagination for huge database
  64. What might be the reason of Couldn’t fetch mysqli_result on another domain?
  65. How Do I Delete WordPress Posts Older Than 400 Days, From A WordPress Category
  66. $wpdb->get_var – What value is returned when zero records are found?
  67. Only allow user to access a link once a year, based on their joining date
  68. query_posts meta_key with current date
  69. Query to fetch custom taxonomy along with post title
  70. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  71. Mysql update menu_order problem
  72. Store GA Client ID in User DB
  73. update multiple rows in mysqli table base on two values
  74. Error Connecting to Database WHEN Installing WordPress on XAMPP [Tried All the Usual Stuff] (Pics Included)
  75. use mysql variable in a $wpdb->query to reindex a column?
  76. Not getting ajax success response on insert/update row to database
  77. WordPress User Search Based on Latitude and Longitude
  78. SQL query to bulk change short code in all posts
  79. Need help with format of nested array in MySQL
  80. How can I verify WordPress nonce from the following code?
  81. How to write in MySQL more characters in user_nicename
  82. Inserting other fields to existing registration form in a WordPress theme
  83. How Fragile Is DB if I Upload Completely Updated Files
  84. Delete user meta based on key value that is an array
  85. Organising and completing posts (mark as read and hide)
  86. Site doesnt work once PHP changed to 7.1
  87. can’t delete a row from post_meta table
  88. What is the cron doing?
  89. SQL error on restoring database
  90. MySQL database gives blank page (white screen of death)
  91. retrieve wordpress post-meta using php not wordpress functions
  92. why is $wpdb->update() causing a DB error from within wp_set_password()
  93. How to permanently delete a taxonomy
  94. Convert many posts from having a specific meta_key to use a post_format
  95. How to back-up a database on IIS
  96. Global MySQL replacing of text patterns/matches
  97. remove wordpress post links
  98. Menu problem : when add wordpress element in menu it convert into empty custom link
  99. SQL get last entry of a specific gravity form
  100. wp_mail function not working in user query loop

Leave a Comment

techhipbettruvabetnorabahisbahis forumutaraftarium24eduedueduedueduedusedusedueduedu