Mysqldump Restore Error 1064
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you error 1064 mysql 42000 you have an error in your sql syntax might have Meta Discuss the workings and policies of this error 1064 mysql 42000 mysql import site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers error 1064 mysql 42000 restore or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community
Error 1064 Mysql 42000 Mysqldump
of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up While importing mysqldump file ERROR 1064 (42000) near '■/ ' at line 1 up vote 6 down vote favorite 5 Cannot import the below dump file created by mysqldump.exe in command line of windows /*!40101 error 1064 mysql 42000 create table SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `attachment_types` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `DESCRIPTION` varchar(50) DEFAULT NULL, `COMMENTS` varchar(256) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `UK_ATTACHMENT_TYPES___DESCRIPTION` (`DESCRIPTION`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; While importing the file in command line mysql --user=root --password=root < mysqldumpfile.sql It throws error ERROR 1064 (42000) near ' ■/ ' at line 1 Somebody please help me. mysql windows mysqldump share|improve this question edited Mar 16 at 4:47 asked Feb 13 '14 at 11:12 Pavan Kumar N 1171115 1 did you try to change your CHARSET? maybe use UTF8_general_ci –marcosh Feb 13 '14 at 11:13 @marcosh thank you for pointing me to that. I found the solution. Refer to my answer. –Pavan Kumar N Feb 13 '14 at 14:26 add a comment| 3 Answers 3 active oldest votes up vote 14 down vote accepted Finally I got a solution We need two options --default-character-se
database using mysqldump. Then I do: mysql -u root -p < /media/sf_share/mysqldump/all-databases.sqlThen I get the error 1064 (42000) at line error:^[ERROR 1064 (42000) at line 2495: You have an error
You Have An Error In Your Sql Syntax Check The Manual That Corresponds To Your Mysql Server Version
in your SQL syntax; check the manual that corresponds to your MySQL server version for the
#1064 - You Have An Error In Your Sql Syntax;
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 http://stackoverflow.com/questions/21752550/while-importing-mysqldump-file-error-1064-42000-near-at-line-1 big.(The restore seems to work for some tables, but maybe missed some 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: https://www.quora.com/What-does-error-1064-mean-when-restoring-a-MySQL-dump Avoiding the PitfallWritten 71w agoThe STATS_PERSISTENT is a table option that was introduced in MySQL 5.6. The option won't 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.6k Views · View UpvotesRelated QuestionsMore Answers BelowW
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 http://www.inmotionhosting.com/support/website/database-troubleshooting/error-1064 CONTACT US AMP LOGIN SUPPORT CENTER Search Support Center Product Guides Dedicated Hosting Reseller Hosting KnowledgeBase Website Email Domain Names Reseller Billing Community Support Browse Questions Ask http://serverfault.com/questions/468814/errror-error-1064-42000-on-mysql-import a Question 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 error 1064 Movable Type 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 error 1064 mysql Flash (2)APIs (2)Backup 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)WordP
Start 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 this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Errror ERROR 1064 (42000) on MySQL import up vote 0 down vote favorite Been trying to import a WordPress database using the command line on a FreeBSD server: uname -a FreeBSD host.com 8.3-i386-20120831 FreeBSD 8.3-i386-20120831 #0: Fri Aug 31 10:36:09 UTC 2012 root@domain.com:/usr/obj/i386/usr/src/sys/SERVER8-I386 i386 as I had to many time-outs using PHPMyAdmin as it is a large file I guess . Importing using the CLI command mysql -u user_wp -p -h subdomain.mysql.host.com database --default_character_set utf8 < betazone.sql I got ERROR 1064 (42000) at line 38316: 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 '