Ver Mensaje Individual
  #1 (permalink)  
Antiguo 08/08/2009, 13:59
edwalves
 
Fecha de Ingreso: agosto-2009
Mensajes: 1
Antigüedad: 15 años, 4 meses
Puntos: 0
Exclamación 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;