Error 1064 42000
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of error 1064 mysql 42000 mysqldump this site About Us Learn more about Stack Overflow the company Business Learn error 1064 42000 mysql more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question error 1064 42000 create user x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up
Error 1064 42000 Import
MySQL problem: ERROR 1064 (42000) up vote 3 down vote favorite 3 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 error 1064 42000 create table 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. mysql sql-server azure mysqldump mysql-error-1064 share|improve this question edited Sep 10 '12 at 5:53 Marc Alff 4,3551343 asked Aug 9 '11 at 15:27 siva636 3,878185999 Can you show the first couple of lines of the dump file (censor any personal information). Becouse we need to know what it means with 'l' and why it would give an error there. –Manuel Aug 9 '11 at 15:33 The sql dump file starts as: IF NOT EXISTS (SELECT * FROM ......... –siva636 Aug 9 '11 at 15:40 add a comment| 9 Answers 9 active oldest votes up vote 4 down vote Do you have a specific database selected like so: USE database_name Except for that i cant think of any reason for this error. share|improve this answer answered Aug 9 '11 at 21:12 Manuel 6,17742853 I used the command similar to
DOMAINS WEB DESIGN WEB DESIGN SERVICES CREATE YOUR OWN WEBSITE SITE HOSTING TOOLS MEET US MEET US ABOUT US PARTNERS & AWARDS BLOG WE'RE HIRING CONTACT error 1064 42000 insert US AMP LOGIN SUPPORT CENTER Search Support Center Product Guides Dedicated
Error 1064 42000 Line 1
Hosting Reseller Hosting KnowledgeBase Website Email Domain Names Reseller Billing Community Support Browse Questions Ask a Question
Error 1064 Mysql 42000 Create Database
User Submitted Articles Education Channels Android BoldGrid cPanel DokuWiki Drupal 7 Drupal 8 Everything Email Joomla 2.5 Joomla 3.1 K2 Magento 1.6 Mambo MediaWiki Moodle Movable Type http://stackoverflow.com/questions/6998705/mysql-problem-error-1064-42000 OpenCart OpenCart 2.0 osCommerce PHP-Fusion PHP-Nuke phpBB phpList Premium Website Builder PrestaShop 1.5 PrestaShop 1.6 SMF Tiki Wiki VirtueMart 3 Web Hosting Manager Website Design WordPress Tools & Resources Email Configuration Blacklist Check Visual DNS Lookup Quick Tagger Icon Sets Favicon Generator Bounce Back Parser What is my IP address? >>Website .htaccess (17)Adobe Flash (2)APIs (2)Backup http://www.inmotionhosting.com/support/website/database-troubleshooting/error-1064 and Restore (15)Billing (8)Browser Issues (2)Connecting to a Database (5)cPanel (26)cPanel Account Management (16)Cron Jobs (4)Cube Cart (2)Database Setup (5)Database Troubleshooting (6)Domain Management (2)Dreamweaver (12)Drush (2)eCommerce (7)Elasticsearch (4)Fantastico (4)File Management (16)File Manager (6)FTP (10)FTP Client Setup (21)General Server Setup / Management (15)Getting Started Guides (18)Ghost (3)Google Tools (21)How To (23)HTML (2)Image Editing (2)IP Addresses (3)iWeb (1)JavaScript (2)Joomla (10)Joomla 2.5 (36)Koken (11)Linux (27)Logaholic (5)Magento (2)Maintaining Your Website (1)Managing Files (7)Microsoft FrontPage (11)Microsoft Publisher (1)ModSecurity (7) MODx (3)New Customers (7)Open Classifieds (1)PCI Compliance (7)PHP (15)PHP Configuration (7)PHP Troubleshooting (6)phpBB (25)phpMyAdmin (10)Premium Website Builder (22)Prestashop (1)Protecting Files (5)Publishing Your Site (2)Python (1)Redirects (4)Restricting Bots (5)Search Engine Optimization (1)Secure Socket Layer (SSL) Tutorials (13)Security (12)Sending Email From Websites (2)Server Security (2)Server Usage (21)Slow Websites (7)Social Media (4)Software FAQs (11)Soho Web Builder (18)SSH and Root access (21)Statistics/Logging (12)Troubleshooting Comment Spam (3)Troubleshooting Hacked Websites (9)Web Host Manager (7)Website Error Numbers (4)Website Is Unavailable (3)Website Transfers (6)Website Troubleshooting (26)Welcome to AMP (22)What Is... (9)WooCommerce (5)WordPress (102)WordPress Development (12)Wordpress Plugins (59)Wordpress Themes (6)Working wit
database using mysqldump. Then I do: mysql -u root -p < /media/sf_share/mysqldump/all-databases.sqlThen I get the error:^[ERROR 1064 (42000) at line 2495: https://www.quora.com/What-does-error-1064-mean-when-restoring-a-MySQL-dump 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 'STATS_PERSISTENT=0' at line 11What does this mean? I can't open the mysqldump sql file to check the line because it's too big.(The restore seems to work for some tables, but maybe missed some error 1064 databases)UpdateCancelPromoted by Periscopedata.comData Scientist Pro Tools. Analyze billions of rows in seconds.Get 150x faster queries, beautiful dashboards, and easy-to-share reports. Start a free trial today!Learn More at Periscopedata.comAnswer Wiki3 Answers Bill Karwin, Oracle Ace, MySQL Contributor, author of "SQL Antipatterns: Avoiding the PitfallWritten 70w agoThe STATS_PERSISTENT is a table option that was introduced in MySQL 5.6. The option won't error 1064 42000 be recognized in an earlier version of MySQL. So you're probably trying to restore the dump to an instance of MySQL 5.5 or older.Version-specific syntax is supposed to be enclosed in special comment delimiters so it doesn't cause this error, but this particular option was mistakenly not enclosed in a comment.See bug report: SHOW CREATE TABLE doesn't put STATS_PERSISTENT into version specific commentsThis bug is "verified" which means MySQL QA confirms that it is a bug, but it has not been fixed.One workaround is to use "mysqldump --skip-create-options" when you produce your dump file, which will omit all MySQL-specific table options.Another workaround is to filter your dumpfile using a streaming text tool such as sed, so you don't have to open the whole file in a text editor.4.4k Views · View UpvotesRelated QuestionsMore Answers BelowWhy mysql_fetch_array() have this error?How do I fix a MySQL Error 1064?What does 1064 error mean when creating tables?How do you back up and restore a MySQL database?What do these MySQL errors mean for the connection file when runnin