Importing Database to Phpadmin error imp

Discussion of testing theory and practice, including methodologies (such as TDD, BDD, DDD, Agile, XP) and software - anything to do with testing goes here. (Formerly "The Testing Side of Development")

Moderator: General Moderators

Post Reply
piyushtiwari
Forum Newbie
Posts: 5
Joined: Mon Nov 24, 2008 8:41 am

Importing Database to Phpadmin error imp

Post by piyushtiwari »

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
User avatar
Jenk
DevNet Master
Posts: 3587
Joined: Mon Sep 19, 2005 6:24 am
Location: London

Re: Importing Database to Phpadmin error imp

Post by Jenk »

What has this got to do with testing?
Post Reply