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