Subir una tabla al phpMyAdmin??

davidtorresruiz · 27 Mar 2014

Hola amigo quiero importar o subir esta tabla y me arroja error:

Insertar CODE, HTML o PHP:

-- MySQL dump 10.11
--
-- Host: localhost    Database: tublogger
-- ------------------------------------------------------
-- Server version	5.0.51a-3-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `categories`
--

DROP TABLE IF EXISTS `categories`;
SET  [MENTION=19494]Saved[/MENTION]_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `categories` (
  `category__auto_id` int(11) NOT NULL auto_increment,
  `category_lang` char(4) collate utf8_spanish_ci NOT NULL default 'es',
  `category_id` int(11) NOT NULL default '0',
  `category_parent` int(11) NOT NULL default '0',
  `category_name` char(32) collate utf8_spanish_ci NOT NULL,
  `category_uri` char(32) collate utf8_spanish_ci default NULL,
  `category_calculated_coef` float NOT NULL default '0',
  PRIMARY KEY  (`category__auto_id`),
  UNIQUE KEY `category_lang` (`category_lang`,`category_id`),
  UNIQUE KEY `id` (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=71 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
SET character_set_client =  [MENTION=19494]Saved[/MENTION]_cs_client;

--
-- Dumping data for table `categories`
--

LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT INTO `categories` VALUES (1,'es',1,100,'software libre',NULL,1.04252),(4,'es',4,100,'internet','internet',1.04252),(6,'es',6,103,'blogs',NULL,0.787306),(38,'es',38,102,'sociedad','sociedad',1.2186),(14,'es',8,100,'hardware',NULL,1.04252),(16,'es',22,101,'ciencia',NULL,1.06563),(19,'es',13,100,'diseÃ±o',NULL,1.04252),(22,'es',11,100,'software',NULL,1.04252),(70,'es',64,102,'sucesos','sucesos',1.2186),(29,'es',23,100,'juegos',NULL,1.04252),(33,'es',32,103,'friqui',NULL,0.787306),(57,'es',28,103,'podcast','podcast',0.787306),(35,'es',35,103,'curiosidades',NULL,0.787306),(36,'es',36,101,'derechos',NULL,1.06563),(37,'es',37,100,'seguridad',NULL,1.04252),(39,'es',5,103,'TV','tv',0.787306),(40,'es',100,0,'tecnologÃ*a','tecnologia',1.04252),(41,'es',101,0,'cultura','cultura',1.06563),(42,'es',102,0,'actualidad','actualidad',1.2186),(43,'es',7,102,'empresas',NULL,1.2186),(44,'es',9,101,'mÃºsica',NULL,1.06563),(45,'es',10,103,'vÃ*deos','videos',0.787306),(46,'es',12,103,'espectÃ¡culos','espectaculos',0.787306),(47,'es',15,101,'historia','historia',1.06563),(48,'es',16,101,'literatura','literatura',1.06563),(49,'es',17,102,'amÃ©ricas','americas',1.2186),(50,'es',18,102,'europa','europa',1.2186),(51,'es',20,102,'internacional','internacional',1.2186),(53,'es',24,102,'polÃ*tica','politica',1.2186),(54,'es',25,102,'economÃ*a','economÃ*a',1.2186),(56,'es',27,103,'deportes','deportes',0.787306),(58,'es',29,101,'educaciÃ³n','educaciÃ³n',1.06563),(59,'es',39,100,'medicina','medicina',1.04252),(60,'es',40,100,'energÃ*a','energia',1.04252),(61,'es',41,101,'arte','arte',1.06563),(62,'es',42,100,'novedades','novedades-tec',1.04252),(63,'es',43,100,'medioambiente','medioambiente',1.04252),(64,'es',44,102,'personalidades','personalidades',1.2186),(65,'es',45,101,'prensa','prensa',1.06563),(66,'es',103,0,'ocio','ocio',0.787306),(67,'es',60,101,'fotografÃ*a','fotografia',1.06563),(68,'es',61,101,'divulgaciÃ³n','divulgacion',1.06563),(69,'es',62,101,'cine','cine',1.06563);
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2008-07-27 18:21:13

Vittey · 27 Mar 2014

al parecer no haz elegido la base de datos, es lo que muestra el error
Creo que falto el USE nombre_base;
quedaria algo asi:

USE nombre_base;
DROP TABLE IF EXISTS `categories`;
blablablalba......

davidtorresruiz · 27 Mar 2014

Gracias amigo! Que tonteria o descuido de mi parte..

:encouragement:

---------- Post agregado el 27-mar-2014 hora: 13:12 ----------

Ahora es esta la que me da error??

Insertar CODE, HTML o PHP:

-- MySQL dump 10.13  Distrib 5.5.18, for Linux (x86_64)
--
-- Host: localhost    Database: brolleri_tublogger
-- ------------------------------------------------------
-- Server version	5.5.18-55-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `subs`
--
USE brolleri_tublogger;
DROP TABLE IF EXISTS `subs`;
/*!40101 SET  [MENTION=19494]Saved[/MENTION]_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subs` (
  `id` smallint(6) NOT NULL AUTO_INCREMENT,
  `name` char(12) NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `parent` smallint(5) unsigned NOT NULL DEFAULT '0',
  `server_name` varchar(32) DEFAULT NULL,
  `base_url` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Basic data for every sub site';
/*!40101 SET character_set_client =  [MENTION=19494]Saved[/MENTION]_cs_client */;

--
-- Table structure for table `sub_categories`
--
USE brolleri_tublogger;
DROP TABLE IF EXISTS `sub_categories`;
/*!40101 SET  [MENTION=19494]Saved[/MENTION]_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sub_categories` (
  `id` smallint(5) unsigned NOT NULL,
  `category` smallint(5) unsigned NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `import` tinyint(1) NOT NULL DEFAULT '1',
  `export` tinyint(1) NOT NULL DEFAULT '0',
  `calculated_coef` float NOT NULL DEFAULT '0',
  UNIQUE KEY `category_id` (`category`,`id`),
  KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Store categories available for each sub site';
/*!40101 SET character_set_client =  [MENTION=19494]Saved[/MENTION]_cs_client */;

--
-- Table structure for table `sub_statuses`
--
USE brolleri_tublogger;
DROP TABLE IF EXISTS `sub_statuses`;
/*!40101 SET  [MENTION=19494]Saved[/MENTION]_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sub_statuses` (
  `id` smallint(5) unsigned NOT NULL,
  `status` enum('discard','queued','published','abuse','duplicated','autodiscard','metapublished') NOT NULL DEFAULT 'discard',
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `category` smallint(5) unsigned NOT NULL,
  `link` int(10) NOT NULL,
  `origen` smallint(5) unsigned NOT NULL,
  `karma` decimal(10,2) NOT NULL DEFAULT '0.00',
  UNIQUE KEY `link_id` (`link`,`id`),
  KEY `id_status_category_date` (`id`,`status`,`category`,`date`),
  KEY `id_status_date_category` (`id`,`status`,`date`,`category`),
  CONSTRAINT `sub_statuses_ibfk_1` FOREIGN KEY (`link`) REFERENCES `links` (`link_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Store the status for each link in every sub site';
/*!40101 SET character_set_client =  [MENTION=19494]Saved[/MENTION]_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2011-12-29  1:19:14

me sale esto:

Vittey · 27 Mar 2014

Mysql no manejo mucho.
al parecer aseria algo de error en FK o PK. Estás relacionando Bien?
Sera bueno ver el detalle del error, ahi puede que te des cuenta

xomero · 27 Mar 2014

Creo que estas tratando de crear tablas InnoDB tienes que desactivar el chequeo de Foreign Keys y luego activarlo cuando te deje crear las tablas: FOREIGN_KEY_CHECKS=0

Vittey · 27 Mar 2014

Sino esta la otra, la clásica. ¨Divide y triunfarás¨.

Primero crea las tablas y probando creas las restricciones (todo esto en local).
ahi es cuando verás los errores de Claves o de campos.

---------- Post agregado el 27-mar-2014 hora: 23:24 ----------

xomero dijo:
Creo que estas tratando de crear tablas InnoDB tienes que desactivar el chequeo de Foreign Keys y luego activarlo cuando te deje crear las tablas: FOREIGN_KEY_CHECKS=0

por ahi va la cosa !:encouragement:

davidtorresruiz · 27 Mar 2014

Hola amigo es un servidor compartido...no se donde desactivar el chequeo de Foreign Keys

Subir una tabla al phpMyAdmin??

davidtorresruiz Seguir

Vittey

davidtorresruiz

Vittey

xomero

Vittey

davidtorresruiz