importing mysql database error

tendouser · August 4, 2013

when trying to import a mysql database from web server to my localhost laptop I get this

Error

There 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/O9zjFG0U6aiQN5yxL33
7m54zKpKVwpuONxEkGelAn4FEYMkFqRukAkIKU71z1yBpJKKKGTu0Y3WMcojymLKyaauQNcLSFdZ
2SzgPkNXvhvdGxT64Ueep+hkZF2kCgRFAzqfzSMn67u1Fy907WcLJEJ+ni1ocp5A8rRcKTAj+bjA
mrEbprlrBzM680YPL33wr8EQy2XsK08k+7uyJZdJEsmARzxJZCywBowLGbMAWPAf4A62mwGwmvlz
3ef8F0UYwn67L07p87AbASMBt27YE2y/mvmwm0YMmKSXvrG1dq8uLo7HI0XLcOq8hY7GIun5u+lg
FfTTU9dv8elbKzOaubN+TLMbjILU/QIWL/A7cAGdBSZVJGBdeHFtZtz5e68PMKfLy/Cp78P+1XjF
R7z/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

requinix · 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.

tendouser · August 4, 2013

so is there any solution?

tendouser · 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)

requinix · 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.

tendouser · 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!

jazzman1 · 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`

jazzman1 · August 5, 2013

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

tendouser · 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.17

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: `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

jazzman1 · August 5, 2013

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

tendouser · August 5, 2013

what is wrong with my header?

jazzman1 · 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.

Sign In

importing mysql database error

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information