Problema al importar .sql con phpMyAdmin Disculpen la molestia, pero estoy cansado de buscar soluciones a este problema y no encuentro ninguna.
Utilizo vTiger y se me daño el disco del servidor, entonces ahora estoy intentando importar el archivo .sql que el programa generaba como Backup en un hosting web con MySQL y phpMyAdmin, pero cuando intento importar el archivo me da el siguiente Error: Cita: SQL query:
-- atlantis database dump
-- Date: Sun, Mar 15, 22:45:04 BRT 2009
---------------------------------------------- --
SET FOREIGN_KEY_CHECKS =0;
MySQL said: Documentation
#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 '------------------------------------------------
SET FOREIGN_KEY_CHECKS=0' at line 1
La cabecera de la Base de Datos es la siguiente:
Código:
-- atlantis database dump
-- Date: Sun, Mar 15, 22:45:04 BRT 2009
------------------------------------------------
SET FOREIGN_KEY_CHECKS=0;
SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO';
--
-- Table structure for table `vtiger_account`
--
DROP TABLE IF EXISTS `vtiger_account`;
CREATE TABLE `vtiger_account` (
`accountid` int(19) NOT NULL default '0',
`accountname` varchar(100) NOT NULL,
`parentid` int(19) default '0',
`account_type` varchar(200) default NULL,
`industry` varchar(200) default NULL,
`annualrevenue` int(19) default '0',
`rating` varchar(200) default NULL,
`ownership` varchar(50) default NULL,
`siccode` varchar(50) default NULL,
`tickersymbol` varchar(30) default NULL,
`phone` varchar(30) default NULL,
`otherphone` varchar(30) default NULL,
`email1` varchar(100) default NULL,
`email2` varchar(100) default NULL,
`website` varchar(100) default NULL,
`fax` varchar(30) default NULL,
`employees` int(10) default '0',
`emailoptout` varchar(3) default '0',
`notify_owner` varchar(3) default '0',
PRIMARY KEY (`accountid`),
KEY `account_account_type_idx` (`account_type`),
CONSTRAINT `fk_1_vtiger_account` FOREIGN KEY (`accountid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `vtiger_account`
--
INSERT INTO `vtiger_account` VALUES('2', 'vtiger', '0', '', 'Recreation', '0', '', '', '', '', '(277) 182-7871', '', '', '', '', '', '0', '0', '0');
INSERT INTO `vtiger_account` VALUES('4', 't3M Invest A/S', '0', '', 'Hospitality', '0', '', '', '', '', '(849) 273-8601', '', '', '', '', '', '0', '0', '0');
INSERT INTO `vtiger_account` VALUES('6', 'EDFG Group Limited', '0', '', 'Communications', '0', '', '', '', '', '(845) 065-8520', '', '', '', '', '', '0', '0', '0');
INSERT INTO `vtiger_account` VALUES('8', 'vtigerCRM Inc', '0', '', 'Entertainment', '0', '', '', '', '', '(438) 276-6887', '', '', '', '', '', '0', '0', '0');
INSERT INTO `vtiger_account` VALUES('10', 'X-CEED INC 99', '0', '', 'Shipping', '0', '', '', '', '', '(259) 148-5102', '', '', '', '', '', '0', '0', '0');
Y la parte final es la siguiente:
Código:
--
-- Dumping data for table `vtiger_visibility`
--
INSERT INTO `vtiger_visibility` VALUES('1', 'Private', '0', '1');
INSERT INTO `vtiger_visibility` VALUES('2', 'Public', '1', '1');
--
-- Table structure for table `vtiger_visibility_seq`
--
DROP TABLE IF EXISTS `vtiger_visibility_seq`;
CREATE TABLE `vtiger_visibility_seq` (
`id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `vtiger_visibility_seq`
--
INSERT INTO `vtiger_visibility_seq` VALUES('2');
--
-- Table structure for table `vtiger_wordtemplates`
--
DROP TABLE IF EXISTS `vtiger_wordtemplates`;
CREATE TABLE `vtiger_wordtemplates` (
`templateid` int(19) NOT NULL,
`filename` varchar(100) NOT NULL,
`module` varchar(30) NOT NULL,
`date_entered` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`parent_type` varchar(50) NOT NULL,
`data` longblob,
`description` text,
`filesize` varchar(50) NOT NULL,
`filetype` varchar(20) NOT NULL,
`deleted` int(1) NOT NULL default '0',
PRIMARY KEY (`templateid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `vtiger_wordtemplates`
--
SET FOREIGN_KEY_CHECKS=0;
|