Jump to content

importing mysql database error


tendouser
 Share

Recommended Posts

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: b_help.png

#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

Link to comment
Share on other sites

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.
Link to comment
Share on other sites

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`
Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 by jazzman1
Link to comment
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.