tendouser Posted August 4, 2013 Share Posted August 4, 2013 when trying to import a mysql database from web server to my localhost laptop I get this ErrorThere is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:----BEGIN CUT----eNrVUz1v2zAQ1cxfcVMniyFF0UoYdBASwSkgia4kZ8giKAlRG9CHI5Nx/O9zjFG0U6aiQN5yxL337m54zKpKVwpuONxEkGelAn4FEYMkFqRukAkIKU71z1yBpJKKKGTu0Y3WMcojymLKyaauQNcLSFdZ2SzgPkNXvhvdGxT64Ueep+hkZF2kCgRFAzqfzSMn67u1Fy907WcLJEJ+ni1ocp5A8rRcKTAj+bjAmrEbprlrBzM680YPL33wr8EQy2XsK08k+7uyJZdJEsmARzxJZCywBowLGbMAWPAf4A62mwGwmvlz3ef8F0UYwn67L07p87AbASMBt27YE2y/mvmwm0YMmKSXvrG1dq8uLo7HI0XLcOq8hY7GIun5u+lgFfTTU9dv8elbKzOaubN+TLMbjILU/QIWL/A7cAGdBSZVJGBdeHFtZtz5e68PMKfLy/Cp78P+1XjFR7z/0JjvhJA6a/zdbaFvs+/fXtxkr0vdpptGt/dpvslaXbYPWaXP1PU7/vuLPA==----END CUT--------BEGIN RAW---- ERROR: C1 C2 LEN: 19 20 743STR: MySQL: 5.5.32-0ubuntu0.12.04.1USR OS, AGENT, VER: Linux MOZILLA 5.0PMA: 3.4.10.1deb1PHP VER,OS: 5.3.10-1ubuntu3.7 LinuxLANG: enSQL: tenamora_menuex.sql0000664000175000017500000615772512177543121013540 0ustar useruser-- phpMyAdmin SQL Dump-- version 3.5.8-- http://www.phpmyadmin.net---- Host: localhost-- Generation Time: Aug 04, 2013 at 05:23 PM-- Server version: 5.1.68-cll-lve-- PHP Version: 5.3.17SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; ----END RAW---- SQL query: tenamora_menuex.sql0000664000175000017500000615772512177543121013540 0ustar useruser-- phpMyAdmin SQL Dump -- version 3.5.8 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Aug 04, 2013 at 05:23 PM -- Server version: 5.1.68-cll-lve -- PHP Version: 5.3.17 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; MySQL said: #1064 - 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 'tenamora_menuex.sql' at line 1 Quote Link to comment https://forums.phpfreaks.com/topic/280827-importing-mysql-database-error/ Share on other sites More sharing options...
requinix Posted August 4, 2013 Share Posted August 4, 2013 Really sparse on the details, there. tenamora_menuex.sql0000664000175000017500000615772512177543121013540 0ustar useruser-- phpMyAdmin SQL Dump -- version 3.5.8 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Aug 04, 2013 at 05:23 PM -- Server version: 5.1.68-cll-lve -- PHP Version: 5.3.17 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";I don't know what that is, but I do know that's not a valid SQL query. Quote Link to comment https://forums.phpfreaks.com/topic/280827-importing-mysql-database-error/#findComment-1443448 Share on other sites More sharing options...
tendouser Posted August 4, 2013 Author Share Posted August 4, 2013 so is there any solution? Quote Link to comment https://forums.phpfreaks.com/topic/280827-importing-mysql-database-error/#findComment-1443449 Share on other sites More sharing options...
tendouser Posted August 4, 2013 Author Share Posted August 4, 2013 maybe the version? Server: Localhost via UNIX socket Software: MySQL Software version: 5.1.68-cll-lve - MySQL Community Server (GPL) Protocol version: 10 User: tenamora@localhost Server charset: UTF-8 Unicode (utf8) Quote Link to comment https://forums.phpfreaks.com/topic/280827-importing-mysql-database-error/#findComment-1443450 Share on other sites More sharing options...
requinix Posted August 4, 2013 Share Posted August 4, 2013 The "solution" is to not execute that. It's not SQL. If you want more help then you have to give a lot more information about what you're doing. Quote Link to comment https://forums.phpfreaks.com/topic/280827-importing-mysql-database-error/#findComment-1443451 Share on other sites More sharing options...
tendouser Posted August 4, 2013 Author Share Posted August 4, 2013 I am exporting a database and then importing it in my local computer ...it is a database releated to an opencart installation in a web hosting! thanks! Quote Link to comment https://forums.phpfreaks.com/topic/280827-importing-mysql-database-error/#findComment-1443452 Share on other sites More sharing options...
jazzman1 Posted August 4, 2013 Share Posted August 4, 2013 Can you post the part of your dumping sql file until database selection? For example: -- phpMyAdmin SQL Dump -- version 3.5.2.2 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: Aug 05, 2013 at 01:26 AM -- Server version: 5.5.27 -- PHP Version: 5.4.7 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `guestbook` Quote Link to comment https://forums.phpfreaks.com/topic/280827-importing-mysql-database-error/#findComment-1443454 Share on other sites More sharing options...
jazzman1 Posted August 5, 2013 Share Posted August 5, 2013 (edited) How do I it?? According to your first post the dump file is a .sql. Open up with your text editor and let's check the header of that file. Edited August 5, 2013 by jazzman1 Quote Link to comment https://forums.phpfreaks.com/topic/280827-importing-mysql-database-error/#findComment-1443457 Share on other sites More sharing options...
tendouser Posted August 5, 2013 Author Share Posted August 5, 2013 -- phpMyAdmin SQL Dump-- version 3.5.8-- http://www.phpmyadmin.net---- Host: localhost-- Generation Time: Aug 04, 2013 at 05:23 PM-- Server version: 5.1.68-cll-lve-- PHP Version: 5.3.17SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";SET time_zone = "+00:00";/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;---- Database: `tenamora_menuex`---- ------------------------------------------------------------ Table structure for table `ex_address`--DROP TABLE IF EXISTS `ex_address`;CREATE TABLE IF NOT EXISTS `ex_address` ( `address_id` int(11) NOT NULL AUTO_INCREMENT, `customer_id` int(11) NOT NULL, `firstname` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `lastname` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', `company` varchar(32) COLLATE utf8_bin NOT NULL, `company_id` varchar(32) COLLATE utf8_bin NOT NULL, `tax_id` varchar(32) COLLATE utf8_bin NOT NULL, `address_1` varchar(128) COLLATE utf8_bin NOT NULL, `address_2` varchar(128) COLLATE utf8_bin NOT NULL, `city` varchar(128) COLLATE utf8_bin NOT NULL, `postcode` varchar(10) COLLATE utf8_bin NOT NULL, `country_id` int(11) NOT NULL DEFAULT '0', `zone_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`address_id`), KEY `customer_id` (`customer_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=198 ;---- Dumping data for table `ex_address`--INSERT INTO `ex_address` (`address_id`, `customer_id`, `firstname`, `lastname`, `company`, `company_id`, `tax_id`, `address_1`, `address_2`, `city`, `postcode`, `country_id`, `zone_id`) VALUES(1, 1, 'Mario', 'Rios', '', '', '', 'Panama', '', 'Panama', '00507', 164, 2486),(2, 2, 'Elie', 'Levy', '', '', '', 'VIA ITALIA', 'EDIF KONKORD 01-A', 'Panama', '0323', 164, 2486),(20, 19, 'Cristina ', 'Bremner', 'Metrobank', '', '', 'Torre Metrobank, planta baja, el mismo banco, ', 'punta pacifica, calle issac hanono entrando por Torre de las Americas detras de Multiplaza', 'Panama', '', 164, 2486),(5, 5, 'Moises', 'Diaz', '', '', '', 'Calle 59 Obarrio, Edif. Miyaki', '', 'Panama', '', 164, 2486),(6, 6, 'adolfo', 'de obarrio', '', '', '', 'coco del mar', 'edif.icom tawer,apart.8b', 'panama', '', 164, 2486),(7, 7, 'Jose', 'Romero', 'Ernst & Young', '', '', 'Edificio Office One, piso 15, oficina 1503, calle 58 con calle 50 Obarrio', '', 'Ciudad de Panamá', '', 164, 2486),(22, 21, 'Lourdes', 'Sandoval', 'Isthmus Bureau of Shipping', '', '', 'Williamson Place, La Boca, Balboa, Edif. IBS', '', 'Panama', '', 164, 2486),(21, 20, 'Jacqueline', 'Gonzalez', 'Ernest & Young', '', '', 'Edif. Ofice One calle 58 obarrio', '', 'Panama', '', 164, 2486),(19, 18, 'Bernardo', 'Brea', '', '', '', 'Ph. Pacific Village Apto 19 B. Torre 2 Quote Link to comment https://forums.phpfreaks.com/topic/280827-importing-mysql-database-error/#findComment-1443460 Share on other sites More sharing options...
jazzman1 Posted August 5, 2013 Share Posted August 5, 2013 (edited) Wrong header containing a syntax error(s). Replace your header with mine and everything should be fine I think. Make sure that the database "ex_address" is already exist inside mysql server. PS: Use code tags in the future! Edited August 5, 2013 by jazzman1 Quote Link to comment https://forums.phpfreaks.com/topic/280827-importing-mysql-database-error/#findComment-1443462 Share on other sites More sharing options...
tendouser Posted August 5, 2013 Author Share Posted August 5, 2013 what is wrong with my header? Quote Link to comment https://forums.phpfreaks.com/topic/280827-importing-mysql-database-error/#findComment-1443469 Share on other sites More sharing options...
jazzman1 Posted August 5, 2013 Share Posted August 5, 2013 what is wrong with my header? Nothing wrong. I've got an error last night by reason of my typo, I saw it this morning. Can you attach the file to this forum or send to me by PM. Quote Link to comment https://forums.phpfreaks.com/topic/280827-importing-mysql-database-error/#findComment-1443527 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.