Importing Database to Phpadmin error imp
Posted: Thu Dec 04, 2008 3:50 am
Hi, I am getting error when i am importing one of the exported databases i exported and imported in UTF 8, basically i am having triiger in my exported database if i remove that trigger i am able to import database in presence of trigger errors are as follows i will appreicate prompt response i had project pending after 2 days
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 1131
STR: //
SQL: -- phpMyAdmin SQL Dump
-- version 2.11.9.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 04, 2008 at 02:31 AM
-- Server version: 5.0.67
-- PHP Version: 5.2.6
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;# MySQL returned an empty result set (i.e. zero rows).
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;# MySQL returned an empty result set (i.e. zero rows).
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;# MySQL returned an empty result set (i.e. zero rows).
/*!40101 SET NAMES utf8 */;# MySQL returned an empty result set (i.e. zero rows).
--
-- Database: `testagain`
--
-- --------------------------------------------------------
--
-- Table structure for table `product`
--
CREATE TABLE IF NOT EXISTS `product` (
`ProductID` varchar(25) NOT NULL,
`SalesID` varchar(25) NOT NULL,
PRIMARY KEY (`ProductID`)
) TYPE=InnoDB;# MySQL returned an empty result set (i.e. zero rows).
--
-- Triggers `product`
--
DROP TRIGGER IF EXISTS `testagain`.`AuditTrigger`;# MySQL returned an empty result set (i.e. zero rows).
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
SQL query:
DELIMITER // CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product` FOR EACH ROW begin insert into sales(SalesID) values(new.SalesID);
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 'DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagai' at line 1
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 1131
STR: //
SQL: -- phpMyAdmin SQL Dump
-- version 2.11.9.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 04, 2008 at 02:31 AM
-- Server version: 5.0.67
-- PHP Version: 5.2.6
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;# MySQL returned an empty result set (i.e. zero rows).
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;# MySQL returned an empty result set (i.e. zero rows).
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;# MySQL returned an empty result set (i.e. zero rows).
/*!40101 SET NAMES utf8 */;# MySQL returned an empty result set (i.e. zero rows).
--
-- Database: `testagain`
--
-- --------------------------------------------------------
--
-- Table structure for table `product`
--
CREATE TABLE IF NOT EXISTS `product` (
`ProductID` varchar(25) NOT NULL,
`SalesID` varchar(25) NOT NULL,
PRIMARY KEY (`ProductID`)
) TYPE=InnoDB;# MySQL returned an empty result set (i.e. zero rows).
--
-- Triggers `product`
--
DROP TRIGGER IF EXISTS `testagain`.`AuditTrigger`;# MySQL returned an empty result set (i.e. zero rows).
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
SQL query:
DELIMITER // CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product` FOR EACH ROW begin insert into sales(SalesID) values(new.SalesID);
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 'DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagai' at line 1