Inconvenientes al acceso a base de datos Mysql desde Hosting gratuito.
Desde Colombia, quiero pedirte el favor de preguntarle por que al subir mi pagina web a un hosting gratuito como lo es el 000webhost no me deja ver las paginas en las cuales inserto 0 muestro los registros que provienen de una consulta ... En las que inserto registros me muestra la pagina web de 000webhost siendo que me debe de mostrar la pagina que le dice al usuario de que sus registros ya están insertados o se insertaron como nuevos en la base de datos y en las paginas de consulta me muestra los siguientes errores:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in /home/a2000800/public_html/consultaafiliacion.php on line 18
Free Web Hosting PHP Error Message Warning: mysql_select_db():
supplied argument is not a valid MySQL-Link resource in /home/a2000800/public_html/consultaafiliacion.php on line 21
Free Web Hosting
PHP Error Message Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/a2000800/public_html/consultaafiliacion.php on line 24
Free Web Hosting Access denied for user 'root'@'localhost' (using password: YES)
Siendo que debería de mostrarme las paginas con los registros que provienen de las consultas, vale mencionar que el sitio web me funciona adecuadamente cuando lo trabajo localmente
2 respuestas
- Compartir respuesta
El problema se puede deber a el usuario y contraseña creado en el hosting, revisa tu configuración del cpanel de tu hosting y confirma tu usuario y contraseña, y si ademas tiene acceso a la base de datos.
En un hosting no creo que puedas conectarte con el usuario root, verifica tu usuario de base de datos.
Slds
correcto estoy siguiedndo los pasos que ponen en youtube (http://www.youtube.com/watch?v=BJsYNvmNfOM), incluso dentro de la propiedad para crear bases de datos de Mysql que tiene el 000webhost ya cree una base de datos y un usuario,,,ahora lo que deseo es migrar la base de datos que tengo creada (localmente) con tablas y registros a la base de datos que ya tengo creada en 000webhost
Gracias.
Ok, entonces lo que tienes que hacer es ejecutar un comando para exportar tu db, si usas consola de comandos puedes hacer uso de este comando
mysqldump --databases -R -u root --password=ClaveUsuarioRoot --opt Nombre_DB >path/archivoBackup.sql
una vez exportado, lo mas probable es que te toque editar este archivo para cambiar el nombre de la db, a la que creaste en el cpanel de tu hosting, por lo general se suele utilizar para las db´s el usuario del hosting seguido por el nombre de la db creada,
Una vez confirmada esta información puedes ingresar al phpmyadmin de tu hosting y en la db creada hacer un import de tu sql creado con la secuencia anterior.
Bien...,, pero te comento que no estoy utilizando consola de comandos estoy utilizxando solo el Cpanel de 000webhost, el filezilla y el phpmyadmin ,,, viendo otros videos me dicen que tengo que importar un archivo en el 000webhost para que me importe la base de datos que inclusive es como una especie de script , pero no veo cual y en donde esta dicho archivo que debo de tenerlo ya que localmente funciona bien la base de datos
Gracias..
El comando que te referencio es para generar el script sql desde tu servidor o pc local,
Este script lo importar luego a tu hosting
Es decir que lo siguiente, que fue lo que me enviaste
mysqldump --databases -R -u root --password=ClaveUsuarioRoot --opt Nombre_DB >path/archivoBackup.sql
debo de correrlo en el editor de consultas de el mysql en phpmyadmin??, dfisculpame la ignorancia.. :)
Abres una consola de comandos,
En windows oprimes las teclas windows+r y se abre una consola de comandos.
Este comando debes de ejecutarlo desde la ruta donde esta instalado el mysql en su carpeta bin.
Por ejemplo si esta instalado en c:\appserv\mysql\bin, debes ejecutar los siguientes comandos:
cd c:\appserv\mysql\bin
Y ahí ejecutar el comando, cambiando el usuario que utilices, contraseña, db y lugar donde se generara el script
Hola muchas gracias ,,,ya me genero el script pero al momento de hacer la importación en el phpmyadmin de el 000webhost me dice el siguiente error:
Error
SQL query:
--
-- Current Database: `Omnilife`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `omnilife` /*!40100 DEFAULT CHARACTER SET latin1 */;
MySQL said:
#1044 - Access denied for user 'a2000800_ruut'@'localhost' to database 'omnilife'
no se a que se deba eso..
Gracias :)
Aquí te envío el script que se me genero
-- MySQL dump 10.13 Distrib 5.5.8, for Win32 (x86)
--
-- Host: localhost Database: Omnilife
-- ------------------------------------------------------
-- Server version 5.5.8
/*!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 */;
--
-- Current Database: `Omnilife`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `omnilife` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `Omnilife`;
--
-- Table structure for table `boletin`
--
DROP TABLE IF EXISTS `boletin`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `boletin` (
`Nombre` text CHARACTER SET armscii8 NOT NULL,
`Email` varchar(100) NOT NULL,
`Pais_Ciudad` text CHARACTER SET armscii8 NOT NULL,
`Id_boletin` int(100) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`Id_boletin`)
) ENGINE=InnoDB AUTO_INCREMENT=573 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `boletin`
--
LOCK TABLES `boletin` WRITE;
/*!40000 ALTER TABLE `boletin` DISABLE KEYS */;
INSERT INTO `boletin` VALUES ('josue','0','Durban',507),('Diana Carolina','diancarol','chaparral',509),('Jose Arroyo','josearroyo@','bquilla',510),('diomedez','[email protected]','maicao',517),('ytry','[email protected]','gteger',518),('carlos castro','[email protected]','gtegtg',519),('pedro cediel','[email protected]','cartagenta',520),('gustyavbo navia','[email protected]','feeftg',521),('diomedez','[email protected]','maicao',522),('diomedez','[email protected]','maicao',523),('vlorwefds','[email protected]','gregege',524),('vlorwefds','[email protected]','gregege',525),('loprte','[email protected]','g??sds ',526),('Gustavo petroooo','[email protected]','mllimn',546),('carlos Angarita','[email protected]','cartagerna',547),('andrea','[email protected]','cali',549),('patrolin','[email protected]','budapest',550),('carlos Emiulio','[email protected]','Manaure',551),('Paoli??a','prietiñ[email protected]','Lima',552),('Gusta??olireu aparicio','[email protected]','cali',553),('carla','[email protected]','cali',554),('Lina Manuela','[email protected]','medellin',555),('Lina Manuela','[email protected]','medellin',556),('Gloria','[email protected]','cali',557),('Masiel','[email protected]','trinidad',558),('Ochentero','[email protected]','Mexico',559),('buenona','[email protected]','peru',560),('Diomedez','[email protected]','[email protected]',561),('Hernan camilo Martinez V.','[email protected]','Punta Gallinas',562),('fonsequero','[email protected]','uribia',563),('Lina Manuela','[email protected]','medellin',564),('Carla','[email protected]','Paraguachon',565),('Joselina Daza','[email protected]','Manaure',566),('fonsequero','[email protected]','uribia',567),('mariaelisa','[email protected]','caliventuta',568),('buenona','[email protected]','peru',569),('Carla','[email protected]','medellin',570),('bronquillo','[email protected]','manaure',571),('Lina Manuela','[email protected]','noanoa',572);
/*!40000 ALTER TABLE `boletin` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `buzon`
--
DROP TABLE IF EXISTS `buzon`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `buzon` (
`IdBuzon` int(100) NOT NULL AUTO_INCREMENT,
`NombreB` text CHARACTER SET armscii8 NOT NULL,
`ApellidoB` text CHARACTER SET armscii8 NOT NULL,
`EmailB` text CHARACTER SET latin7 NOT NULL,
`PaisCiudadB` text CHARACTER SET armscii8 NOT NULL,
`radio` int(2) NOT NULL,
`Mensaje` text CHARACTER SET armscii8 NOT NULL,
PRIMARY KEY (`IdBuzon`)
) ENGINE=InnoDB AUTO_INCREMENT=991 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `buzon`
--
LOCK TABLES `buzon` WRITE;
/*!40000 ALTER TABLE `buzon` DISABLE KEYS */;
INSERT INTO `buzon` VALUES (471,'alberto','bvbvdb','fvvfdvfdv','vfvfd',0,'vfdvdfvfd'),(472,'alberto','bvbvdb','[email protected]','vfvfd',0,''),(473,'alberto','bvbvdb','[email protected]','vfvfd',1,'fefdsfdsfdsfdsfds'),(474,'alberto','bvbvdb','[email protected]','vfvfd',1,'fefdsfdsfdsfdsfds'),(475,'Pepita','Mendieta','','',0,''),(476,'Pepita','Mendieta','pepita','bogota',0,''),(477,'Pepita','Mendieta','[email protected]','bogota',0,''),(478,'Pepita','Mendieta','[email protected]','bogota',1,'fdfdsfdsfdsfsd'),(479,'Pepita','Mendieta','[email protected]','bogota',1,'fdfdsfdsfdsfsd'),(480,'andrew','peranusc','[email protected]','fdsfdfdsf',0,''),(481,'andrew','peranusc','[email protected]','fdsfdfdsf',0,''),(482,'andrew','peranusc','[email protected]','fdsfdfdsf',0,'fefdsfdfdsfds'),(483,'alcides','parra','alcidparr@','',0,'fdfdsfdsfdsfds'),(484,'alcides','parra','alcidparr@','',0,'fdfdsfdsfdsfds '),(485,'alcides','parra','alcidparr@','',0,'fdfdsfdsfdsfds '),(486,'alcides','parra','alcidparr@','',0,'fdfdsfdsfdsfds '),(487,'alcides','parra','alcidparr@','',0,'fdfdsfdsfdsfds '),(488,'alcides','parra','alcidparr@','',0,'fdfdsfdsfdsfds '),(489,'alcides','parra','alcidparr@','',0,'fdfdsfdsfdsfds '),(490,'alcides','parra','alcidparr@','',0,'fdfdsfdsfdsfds '),(491,'alcides','parra','alcidparr@','',0,'fdfdsfdsfdsfds '),(492,'alcides','parra','alcidparr@','',0,'fdfdsfdsfdsfds '),(494,'ANDR4ES','FRFRWEFRWE','[email protected]','CDDSCS',0,' VFVVVFDVFDVFD'),(495,'ANDR4ES','FRFRWEFRWE','[email protected]','CDDSCS',0,' '),(496,'ANDR4ES','FRFRWEFRWE','[email protected]','CDDSCS',0,' '),(497,'ANDR4ES','FRFRWEFRWE','[email protected]','CDDSCS',0,' '),(499,'trkocw cdwc','vcef??veverv123','[email protected]','tulua',0,'cscsdcscscscscscscscscscscs sdcsdcsdcsdcsdcsdcs'),(500,'trkocw cdwc','vcef??veverv123','[email protected]','tulua',0,'cscsdcscscscscscscscscscscs sdcsdcsdcsdcsdcsdcs'),(501,'trkocw cdwc','vcef??veverv123','[email protected]','tulua',0,'cscsdcscscscscscscscscscscs sdcsdcsdcsdcsdcsdcs'),(502,'ngfbgfbgfbfg','vfvfdvdf','[email protected]','mani',0,'fgvjekvvfdvsvsfd'),(572,'salteriementir','buscrirle','[email protected]','panama',1,' dsadq 564 fdfds'),(573,'pepa','meintresilla','[email protected]','coasta rica',1,' gfsg 496416 fds s1 6 6 fdsfsd'),(574,'porltrert','fgvdspop','[email protected]','florencia',1,' vivqa caquetya'),(575,'gfs ','gk??dgvk??d','[email protected]','gfdgdf',1,' fdss f dsf ds'),(576,'gtrgreger','dfefsfws','[email protected]','fdsfsd',1,' bvcbcv 46 gfsdgvdf'),(577,'gtrgreger','dfefsfws','[email protected]','fdsfsd',1,' bvcbcv 46 gfsdgvdf'),(578,'trere','fgdsfgsd','[email protected]','tulia',1,' vcv 4646 fvdvdf'),(579,'pedro','perez','[email protected]','cartago',1,' vcvc 14616 gfgf'),(580,'pelud','perlpfe','[email protected]','mllin',1,'dasf gfvd65 465496'),(581,'tucu,ano','tuc','[email protected]','bta',1,' bvx 46 gfd'),(582,'cweloter','maexc','[email protected]','m??l??io',1,' cfds 46 gfd'),(583,'perer','jhyr 46','[email protected]','pereira',1,' fdsf 16 bfd'),(584,'thpot','??polegt','[email protected]','arg',1,' nonj fdw 4165 fvr'),(585,'thpot','??polegt','[email protected]','arg',1,' nonj fdw 4165 fvr'),(586,'polv','polvoreria','[email protected]','vfsdvdf',1,' bdfbvdf 546+6+ vfd'),(587,'Luisa','Galvis','[email protected]','bta',1,' fds 4 vbdf '),(588,'ashly','Mosquera','[email protected]','cali',1,' vfd 46 bfd'),(589,'nini','rojas','[email protected]','tiuj',1,' fsd 646 b d'),(590,'gallero','de pauna','[email protected]','geg ',1,' gf gfdg16 '),(591,'paunero','frwfer','[email protected]','bgrbhr',1,' vfd 556 fdvd'),(592,'??potrew','dfascsdc','[email protected]','calimid',1,' vfd 5 vfd'),(593,'pedro ','aparicio','[email protected]','tunja',1,' pedrp vfvgdf'),(594,'Antanas','Mockus','[email protected]','luivcd',0,'gfsgd gb 646df '),(595,'anrtew','dedw','[email protected]','pasto',1,' gbfd 4166 gfdgdf'),(596,'poerrtyhtr','tegtrg','[email protected]','tvev',1,'hyrtb 5 gger'),(597,'pepa','mendiene','[email protected]','bta',1,' cdscds 516 gfds gdf'),(598,'carlos ','castro','[email protected]','popayan',1,' gvfdgp 55415 gfdgfd '),(599,'e3ri','pok,tre','[email protected]','m/llin',0,' bgdgd g ffdgfd'),(600,'patricio','pe??a','[email protected]','tulua',1,' fdsg refgsd 416316gf g'),(601,'patricio','pe??a','ppe?±[email protected]','tulua',1,' fdsg refgsd 416316gf g'),(602,'carlos','palaccino','[email protected]','bta',1,' carlos eres lo maximo'),(603,'topacio','Arenas','[email protected]','valencia',1,' topacio venezolana'),(604,'alfredo','arzuate','[email protected]','mllin',1,' frw fgdb 46 gf'),(605,'carlos ','cata??o','[email protected]','calimad',0,' '),(606,'gfdgdf ',' ggfd g 464 gfdd','[email protected]','tretv',0,' '),(607,'fdefds','fcdsfcdsfd','[email protected]','fdsfds',0,''),(608,'Johasna ','paulovber','[email protected]','gfed',1,''),(609,'Johasna ','paulovber','[email protected]','gfed',1,''),(610,'carminia','gallo','[email protected]','caracas',1,''),(611,'carminia','gallo','[email protected]','caracas',1,''),(612,'carminia','gallo','[email protected]','caracas',1,''),(613,'crloter','ffsopop','[email protected]','efwe 156 fdsf',1,''),(614,'crloter','ffsopop','[email protected]','efwe 156 fdsf',1,''),(615,'truli','arias','[email protected]','cali',0,''),(616,'truli','arias','[email protected]','cali',0,''),(617,'jimmy','Lancheros','[email protected]','fsvdf ',0,''),(618,'pretr','operw','[email protected]','dqwdada',1,''),(619,'pretr','operw','[email protected]','dqwdada',1,''),(620,'fdfds ','rfefrwsfs','[email protected]','vfdvfd',1,''),(621,'fdfds ','rfefrwsfs','[email protected]','vfdvfd',1,''),(622,'cafam','floresta','[email protected]','peru',0,''),(623,'america','de cali','[email protected]','bta',0,''),(624,'america','de cali','[email protected]','bta',0,''),(625,'nacional','verde','[email protected]','peru',1,''),(628,'cali','aji','[email protected]','cali',1,''),(629,'boca','juniors','[email protected]','',0,''),(630,'justin','biever','jb@fdfds .com','bvfb ',1,''),(631,'trtre','frwtgretge','[email protected]','gf{bd',1,'gdgd v413 fd'),(632,'yhtegre','fdsfds163','[email protected]','gfsgvfd',1,''),(633,'camilo','caceres','[email protected]','MEDELLIN',0,''),(652,'carloed','fdgfd','[email protected]','gbbfg',1,'gfxg 1465 gfd'),(653,'Luis','triana','[email protected]','tulua',1,'hola soy luis triana'),(654,'carlos','monta??o','[email protected]','mllin',1,'trwtv 4646 gdf gfdgdf '),(669,'carlo','fdfsdf','dfsasa?±[email protected]','fdsvsda',1,'fds 456 fds ds'),(670,'Hernannnnn','MARTINEZzzzzzzzz','[email protected]','Bogota Colombia',1,'gfgd 13 1466 1g6dfgdfgdf 6 16 63dgb6df dg df'),(671,'Hernannnnn','MARTINEZzzzzzzzz','[email protected]','Bogota Colombia',1,'gfgd 13 1466 1g6dfgdfgdf 6 16 63dgb6df dg df'),(672,'ytdtgdtr','fsdgvsdgvfd','[email protected]','hghghgd',1,'gfd 4154165 trs egedg d '),(673,'gvfsgfdgdf','hgdhgfh gf','[email protected]','tunja',1,'gtd 46 gdfgdf 46 gfdgbd f987 ghbfg '),(674,'pedrole','alretu','[email protected]','santiago',0,'gbfx 456+6 gdfgfdgdf 41656 gfdgfd'),(675,'juan ','lozano','[email protected]','santiago',0,'dsfsd 16 fdsfsdfds'),(676,'cami??li??o','martincillo','[email protected]','chinauta',1,'ghtefh gd416 dfg df6546 gdfgdf'),(677,'drertui','agfdgf','[email protected]','medellin',0,'tr v13 gfd gdf465 gfsg'),(678,'henry','valenzuela','[email protected]','gvfdgbvfd',1,'gdr 16 fgdgds 16 fsdgsd'),(679,'los dandy','aquellos 80s','[email protected]','bta',1,'perdoname Dios santo...'),(680,'VCVCX','VCZVCXVCX','[email protected]','HGFHGF',1,'GHTDG 2 130 GFDGDF'),(711,'arley','betancourth','[email protected]','popayan',1,'fsd 41656 v dfvdf vfd'),(713,'CARLOS','Congote','[email protected]','neiva',1,'fdw 456 ytytr 456'),(714,'Harry ','Pother','[email protected]','tulua',1,'gtegtrg brgbrgbrg'),(715,'fcdsfcdsf','dsacxcasd','[email protected]','fdsfds',1,'dsfvds '),(716,'Johania','gutierez','[email protected]','tulua',1,'vfdv 46 vfevfev'),(717,'grgeergtes','gtrgrtgbrer','grtgbrber','bgret',0,'hgtrht4 7468596 gbrfbgr 4899 bgr grre'),(718,'grgeergtes','gtrgrtgbrer','grtgbrber','bgret',0,'hgtrht4 7468596 gbrfbgr 4899 bgr grre'),(719,'frvre','cwqe','[email protected]','frefwe',1,'ge 4789rewwc'),(720,'gtegvwe','vevew','[email protected]','rwf3',1,'gbdsb 486 gfdv dsf'),(721,'gtegvwe','vevew','[email protected]','rwf3',1,'gbdsb 486 gfdv dsf'),(722,'carlos','vfsdved','v dv sd',' vd sdf',1,'bdgb 54+6 vfve'),(723,'carlos','vfsdved','v dv sd',' vd sdf',1,'bdgb 54+6 vfve'),(725,'cali','buenav','[email protected]','few',0,' bgfb 46+586 b fgb df 4964596 f'),(736,'carlos','sea','','',0,''),(737,'carlos','sea','','',0,''),(782,'natalia','moreno','[email protected]','v/vicenci0o',1,'gvfdvbfd 1566 vbf vdf165 1566 vffdvd16 '),(783,'<Zlbano','romina','[email protected]','medellin',1,'V 16356 VFDVDV DF156 VFD'),(784,'nitilio','morenillo','[email protected] ','pasto',1,'vfsv 3+ v dfvfdv26+\r\n vfd'),(786,'bgg','vdfvdsf','[email protected]','vfdvds',1,'vdfvd '),(788,'Trino','tuta','[email protected]','btoa',1,'cdcsd 45 vf2df 156 vdfvdf v13 vdf'),(789,'Trino','tuta','[email protected]','btoa',1,'cdcsd 45 vf2df 156 vdfvdf v13 vdf'),(790,'Trino','tuta','[email protected]','btoa',1,'cdcsd 45 vf2df 156 vdfvdf v13 vdf'),(791,'poerte','fvsdvdas','[email protected]','vfsdvsd',1,'vfees 46 vdfvsd'),(792,'piero','piero','[email protected]','italia',1,'vf 45+6 v fd '),(793,'carlos otilio','Millan Pataquiva','ccMP@gmail.,com','urumita',1,' urumita es lo mejor...'),(794,'carlos otilio','Millan Pataquiva','ccMP@gmail.,com','urumita',1,' urumita es lo mejor...'),(795,'carlos ','cotreras','[email protected]','M/llin',1,'gfd g415 ghd 156 gb'),(796,'carlos','Mourinho','[email protected]','brasilia',1,'ge vb2+ 145 g 156 hgrtd15 16 hrtg dr'),(797,'Carlos','Colmenares','[email protected]','Maicao',1,'gserv 456 hg .??l?? 4165 gdfv s 1465 '),(801,'marcela','luengas','[email protected]','colombia',0,'bgff 126 bfdb 56+ '),(802,'Hernando','Sandoval','[email protected]','Bta',0,'trt 1564 gffd gf44 1 gf 23 g'),(803,'natalia','Moreno Cantor','[email protected]','dsgfsgfsd',1,'grgtre 32\r\n 45 gfgdfgdf'),(804,'Jorge','Mahecha','[email protected]','tocaima',1,'frwd 4165 vbfcv bd 456 gvbdfvb ds'),(805,'Jorge ','Baron','[email protected]','Ibague',1,'g 1465g ggdfg dfdfhbh n156 ng fgbnfg'),(806,'carlos ','castro','[email protected]','Bogota',0,'gfdgd v4165c carlos'),(807,'Camila','Grandas','[email protected]','Monteria',0,'drty 4165 h ggfh 45 uhyjht'),(808,'Gustavo',' Rogriguez','[email protected]','cali',1,'dgb 456 gvbfvd fsv ds'),(809,'patricia','Mu??oz Aldana','[email protected]','panama',1,'fgrwgfre 452 456h hbgbfg bf'),(810,'edgar','vivar','[email protected]','monterrey',1,'gfdsgr 45 bvfdd bd456 bf bd'),(811,'Yubile','Mendez','[email protected]','monterrey',1,'grfe g456416 gdfgsdff'),(812,'Chaparron','Bonaparte','[email protected]','oaxaca',1,'gfg 4165 g dfg 46 gbfdgdf'),(813,'marcos','gomez','[email protected]','fdsfvsdvfs',0,'gbfd 456 gfdg fd gfd489 hggfd'),(814,'jhon','pati??o','[email protected]','costa rica',0,'fvbcxbcx 456 ggfd'),(815,'Maria de los Angeles','Jimenez Mojica','[email protected]','cali',1,'f,gmsd??vdb'),(816,'Asdrubal','valente','[email protected]','puerto rico',1,'gfdsgvfd g 456gbfdbb '),(817,'carlos','Quinto','[email protected]','honduras',1,'gfge 456 gbfd 4165 bbddf'),(818,'Nadia','Comanechi','[email protected]','medeellin',0,'gfsdg 4896 58 gfgdfg4896 gbdbfgg'),(819,'Yasdeins','Patyi??o','','',0,''),(820,'jadeins','pati??ol','[email protected]','b/meja',1,''),(821,'jadeins','pati??ol','[email protected]','b/meja',1,'gf 5+56+ gfdgdf gdfgd 456 hghfg'),(822,'jadeins','pati??ol','[email protected]','b/meja',1,'gf 5+56+ gfdgdf gdfgd 456 hghfg'),(823,'carli','','','',0,''),(824,'carlitos','cata??ito','','',0,''),(826,'caqrlitos','castrico','[email protected]','cali',0,'ght v 456 hng ngf'),(827,'caqrlitos','castrico','[email protected]','cali',0,'ght v 456 hng ngf'),(830,'charly','Pinicha','[email protected]','pasto',0,''),(831,'charly','Pinicha','[email protected]','pasto',0,'hg 456 hgfhnfg f456 bnfgb fgb gf 4165 gf bfb'),(832,'charly','Pinicha','[email protected]','pasto',0,'hg 456 hgfhnfg f456 bnfgb fgb gf 4165 gf bfb'),(833,'Nelson','Agudello','','',0,''),(834,'Maria ','Eugenia','[email protected]','Bta',1,'gr 456 hbgfh fg hf '),(835,'Maria ','Eugenia','[email protected]','Bta',1,'gr 456 hbgfh fg hf '),(836,'Maria ','Eugenia','[email protected]','Bta',1,'gr 456 hbgfh fg hf '),(837,'Maria ','Eugenia','[email protected]','Bta',1,'gr 456 hbgfh fg hf '),(838,'Maria ','Eugenia','[email protected]','Bta',1,'gr 456 hbgfh fg hf '),(840,'Kathy Emilia','Mart??nez V','','',0,''),(841,'Kathy Emilia','Mart??nez V','[email protected]','Bta',0,''),(842,'Kathy Emilia','Mart??nez V','[email protected]','Bta',1,''),(843,'Kathy Emilia','Mart??nez V','[email protected]','Bta',1,'bgf 4165 bdbfvb 489 gbb ff'),(844,'Kathy Emilia','Mart??nez V','[email protected]','Bta',1,'bgf 4165 bdbfvb 489 gbb ff'),(845,'carlos','Sanchecitos','','',0,''),(847,'Carlo','sanchecitos','','',0,''),(848,'Carlo','sanchecitos','[email protected]','Bta',1,''),(849,'Carlo','sanchecitos','[email protected]','Bta',1,''),(850,'Carlo','sanchecitos','[email protected]','Bta',1,'gfmsdl g rfg dfgdf 456 hgfh'),(851,'Carlo','sanchecitos','[email protected]','Bta',1,'gfmsdl g rfg dfgdf 456 hgfh'),(866,'Andreilla','Pilla','[email protected]','popayan',1,'hyt 456 h trhr rh rt4 4h9fg6hf'),(867,'yubilecita','mendez','[email protected]','Muzo',1,'tgre 4566 gegewg '),(868,'Pedro','Guillen','[email protected]','cali',1,'fgsd 456 gfdg 45 gdfgd'),(869,'Maelllooer','ruizeeerr','[email protected]','tulua',1,'fds 5+66+ grg eer 4566 gef e 46545645 '),(870,'carminia','Gallup','[email protected]','mexico D.F',0,'ht 216+6 v hgteget te4566 gtr grtgrt'),(871,'Noelle','Schonwalld','[email protected]','calip',0,'gregre grege gerr e'),(872,'Noelle','Schonwalld','[email protected]','calip',0,'gregre grege gerr e'),(873,'Arturo','Bojaca','[email protected]','calie',1,'rw 456 grge r4165 ge'),(874,'cu??is','albeiuros','cu?±[email protected]','chile',1,'fgrwf 4545 geger 4566 gregre ge'),(875,'Adriana','Mora','[email protected]','cali',1,'rewrwe 56+ grggdg'),(876,'culoert','asquirtf','[email protected]','cali',0,'re 14 ghtrt 4866 getgre 456 g eger e'),(877,'Jhoniar','Avenda??o','[email protected]','fusa',1,'gr 4165 gfgf 16556 f bd bdbf'),(878,'naglety','Asagurren','[email protected]','santiago',0,'colombia es lo mejor...'),(879,'lorena','angarita','lorang@yahoo.?±com','hong Kong',1,'fdsa 526+ fvds s 6+ vdvdf 496 ikyukyt'),(880,'lorena','angarita','lorang@yahoo.?±com','hong Kong',1,'fdsa 526+ fvds s 6+ vdvdf 496 ikyukyt'),(881,'alvaro','cruz','[email protected]','bogota',1,'yrtyr 7465b ytre '),(882,'carlos','perea','[email protected]','Maicao',0,'hdf 45+6 gfd gsdf4165 gfdg dsf'),(883,'Nayelli','saloer','[email protected]','Bogota Colombia',1,'tfrew c456 gdfgdf 56+ gfg df6+'),(884,'Nircia','Perez','[email protected]','Lima',0,'gfg 46 bgfb bd46 bdfbdb d'),(885,'Trulli','Espinosa','[email protected]','caloer',1,'rfg 52 fbdf bd 456 ujty'),(886,'Mariana','Quintero','[email protected]','Fusagasuga',1,'fds 163 gf gd 56+ gfdgbdf +6+ b'),(887,'nnaaartrrllyyy','bbbelltttrrraaann','[email protected]','cali',1,'fs 4165 vdfvdf 456 bhgfr'),(888,'Carlos','Miranda','[email protected]','cucuta',1,'soy de fgvsvfd bvxc cv'),(889,'Fancy','Prieto','[email protected]','tokyo',1,'fsd 132 vvdvd '),(890,'carrliem','castro','[email protected]','ecuador',1,'er gvdf dfd'),(891,'Locademia','de policia','[email protected]','Giron',1,'gs gvdf bvdf 89 54'),(892,'carlort','fruert','[email protected]','costa rica',1,'frd 15 sfvfsdv dsfv dsf'),(893,'Marlijar','Hurtado','[email protected]','neiva',0,'fsd 45 vxfvxc d 56+ vf vdf'),(894,'Nery','Pumpido','[email protected]','caracas',0,'wdrv 52+6 bdfbd dgbgb'),(895,'Nayarit','Jimenez','[email protected]','yopal',1,'fewf w23\r\n+ gevvdf'),(896,'carlos','cuesta','[email protected]','ibague',1,'fd 526+v vfvdf v 4165 bbgbfg'),(897,'carlos','huertillas','[email protected]','san jose del guaviare',1,'hgh 14 hghgfh gfh g'),(898,'Nidia','Comanecho','[email protected]','Miami',1,'gregv 126 gb 46ngfn '),(899,'carla','santa','[email protected]','neiva',0,'getg 526+ hb t'),(900,'Arturo','Bojaca','[email protected]','somondoco',1,'cdac ds'),(901,'franco','Albertini','[email protected]','Toronto',1,'gte 26+ bgbg bgfbfg'),(902,'Gustava','Acosta','[email protected]','Madrid',0,'gvfd 4165bgbfgb b 526+bfg bbfg'),(903,'tulio','zuluaga','[email protected]','huila',0,'fes 21656 vfdvd'),(904,'cresdre','trevd','[email protected]','fdsfdsf',1,'fvsvfds'),(905,'Paroxetin','paroxetin','[email protected]','cali',0,'fsgv e526+bv bv bvfdvb f'),(906,'carlos','umba','[email protected]','mllin',0,'fedfrwe 26+vbfdv df'),(907,'antonietetetetet','delgasddodododod','[email protected]','santiago',1,'gre 156 gg rtrt grtt g'),(908,'Gustavo','Quintero88','[email protected]','panama',1,'gtre 14545b brbbf'),(909,'carlos ','piedrhaita','[email protected]','tulua',1,'gteg 165gbef rgrtgt'),(910,'carlos ','piedrhaita','[email protected]','tulua',1,'gteg 165gbef rgrtgt'),(911,'naci','Epieyu','[email protected]','Manaure',1,'grg 45 fegfdgdfgdf'),(912,'curillo','astrole','[email protected]','california',1,'g 156 gettgt gtr 156 ghr'),(913,'marleeennnii','zapatilllaaaa','[email protected]','qu9intilla',1,'vfsdvbf 456 rege gr'),(914,'carla','Marconi','[email protected]','managua',1,'ht 156g egrrt '),(915,'Rigoberta','Menchu','[email protected]','tru??ler',1,'htr 456gb56 brgbb tg b'),(916,'Rigoberta','Menchu','[email protected]','tru??ler',1,'htr 456gb56 brgbb tg b'),(917,'jane','Fonda','[email protected]','kingston',1,'frf r4165 bbgbfgb'),(918,'Andres','Ricardo','[email protected]','Medellin',1,'fgre 14545 ggeg etg456 gbg dg'),(919,'Matias','Molina','[email protected]','panama2',0,'tgre 45 gerge sr 48 gergeg'),(920,'lupe','quintamilla','[email protected]','Ibague',0,'y6 526+ hry hyrh tr h 456h rhrh'),(921,'lupe','quintamilla','[email protected]','Ibague',0,'y6 526+ hry hyrh tr h 456h rhrh'),(922,'lupe','quintamilla','[email protected]','Ibague',0,'y6 526+ hry hyrh tr h 456h rhrh'),(923,'Hugo','Chavez','[email protected]','caracas',0,'gd 15665 hgh dr grfg eg 1536 hghh'),(924,'Yesid','Umba','[email protected]','Mexico',0,'gbtd 156gdf g dfgf df gdfgdf h 4bgfvb fg'),(925,'carli??o','p??rtrillo','[email protected]','mexico',0,'g 145gre erg ger greg e4165ber '),(926,'freddy','Molina','[email protected]','V/dupar',1,'gre g56 trgrtrtgrtgt'),(927,'Maria','Mercedes','[email protected]','mexico D.F',1,'ghet 4165 ggetger 456 hbghgrbrgf'),(928,'Alberto','Trillos','[email protected]','Btra',1,'gerg 4165g regregre g 489fe df'),(929,'adriana','pertort','[email protected]','Yumbo',1,'gf 456 gf gfdgfd g g g gfg fgg hr 65n'),(930,'carlos','calero','[email protected]','yumbo',1,'vfdvfd 165 bvfdbdf'),(931,'Arley7896','Dinas78963','[email protected]','california',1,'sfg 156 gfdgdfg d g 456hbgdbh'),(932,'Payaso','urib','[email protected]','gregbte',1,'gfrw v4156 ht hgrthrt '),(933,'alba','','','',0,''),(934,'alba','','','',0,''),(935,'alba','','','',0,''),(936,'alba','','','',0,''),(937,'pedro','ya??es','pedrya?±@gmail.com','costa rica',1,'vgbve 456 gergreg 456befbe'),(938,'carlos','huertas112','[email protected]','costa rica',1,'fwrf r5+ gergre 4165g erger'),(939,'dfcwq','','','',0,''),(940,'rerqwrwq','qdwqwq','[email protected]','casli',1,'fsdfs 1 vsvdvdv sd'),(941,'rerqwrwq','qdwqwq','[email protected]','casli',1,'fsdfs 1 vsvdvdv sd'),(942,'erwtertre','','','',0,''),(943,'erwtertre','gdfghdsfs','[email protected]','fdfdsfsd',1,'c v dsf 489 vfvd vd fdvdf'),(945,'pablo','milnessii','[email protected]','panama',1,'vf1 1 gdfgvdf gfd 1456 bdgb '),(946,'mariana','maria','[email protected]','riohacha',1,'betgf 56+bgd nghn 46n dfnf'),(947,'paralet','pert','[email protected]','riohacha',1,'bgdb 156 bgdfgb 456bgfbfg'),(949,'truser','erth','[email protected]','panama',1,'bgedb 45 bndfb456b fbdf'),(950,'Libia','Aparicio','[email protected]','tunja',1,'vfsdvd 16 vfvdv dsv d'),(951,'culebra','cascabel','[email protected]','tulua',0,'bt 56+b tbrt 546brg bgrbreber'),(952,'nahomi','hp','[email protected]','VGBFDSBVDF',1,' D 1265VFD VFDVFFD BVD 156B D'),(953,'Gitana','pertore','[email protected]','gfdsged',0,'vf 2+6v fdv fdv df'),(954,'carlosd','menared','[email protected]','medelln',1,'vf 26+ gef er 26+ brbvrg 2 bfgfb rtg+6+'),(955,'a??lo','arleta','[email protected]','fcdwcws',1,'v 4165v fsvef458 dfv dfvdf'),(956,'arturo','aranguren','[email protected]','cali',0,'gdsfg 146 gvbfsvbfdvfdf'),(957,'dsvsfd','fdvbbds','[email protected]','vfevewv',0,'vfevew 56566 vfdved'),(958,'a','huevo','[email protected]','neiva',0,'fgresg 5+bf bfdbsdb'),(959,'bu??uelo','aber','[email protected]','Riohacha',1,'bvgdfg 6+ 566+5 bgbffg'),(960,'aguachica','Mondo??edo','[email protected]','cigarro',1,'n 2+h ghggf f5+6n ngf'),(961,'parton','[email protected]','[email protected]','tulsdf',1,'gfgdfgd'),(962,'algert','drfgh','[email protected]','rihchw',1,'fv5+ 5+6 gfg sdfs +998+ bgfgbf'),(963,'aquerosoids','erts','[email protected]','CHINAUTA',0,'BDG 59+85+ BDBFG FG'),(964,'alberto','castillo','[email protected]','tuinja',1,'grfg v52+6 b d bsdf'),(965,'charluy','lapaloma','[email protected]','monteria',1,'f ds m m gvbfd bvfd vbfd vfvfdv df 44656 bnfgbfgb fg 46 gdfbgf 84 b6gbgfb'),(966,'Hermanos ','Ariza','[email protected]','otanche',1,'vfsd v56+ vb45645 bg4b6fgb 465456 bdg'),(967,'Carlos','Ortega','[email protected]','Quipama',1,'greg 79 4545 bgbgbfg 46 bgbgfb gfgbgf 65656 bgbgbgfbgf6456 bgbfg'),(968,'anthrax','anthrax1','[email protected]','new york',1,'bd 5+6 bngbgf bfg b56+ nb fbnbf fg 54+6 nnbn'),(969,'ryth','bautista','[email protected]','cordioba',1,'rew rtfqw163 v sda vas15656 vfv'),(970,'saer','cerdf','[email protected]','fggfasd',0,'g 26+fvrw erwfvewrfv e'),(971,'kunmier','ertyu','[email protected]','paris',0,'b 1+65vb fdvfdvdfv'),(972,'sercrt','sdf','[email protected]','andes',1,'dsvf 456+ vds'),(973,'gretyu','sfgdf','[email protected]','medellin',1,'rewtfgrwe 46 gefvdf'),(974,'Dasrtk','tranquility','[email protected]','b/ventura',0,'ge 165 dfvfd1 fdd b145 bdbf'),(975,'Carlos','Alvarez','[email protected]','Mitu',1,'few 2\r\n vbfvd 456 b gf bfg bg416546 bgfv bf brf16563'),(976,'c arloi','prieto','[email protected]','riohacha',1,'few 13 vfev eer 413 bvfev'),(977,'marcela','larota','[email protected]','cucuta',0,'fr 4163 gf egee46 fevdf v 4515fdv fefdv'),(978,'Marlene','Marlert','[email protected]','riohacha',1,'fwr 142 g efvfrt 15645 gfgrfg rt 4165 g rf 165gt 416546gt grfgr'),(979,'raquelita','welch','[email protected]','Arauca',1,'vf 156 bgb bgfb gf 45646 n n gf fh hf'),(980,'Johana','Caita','[email protected]','yopal',0,'rg 14 g getgtr 416556 grf rtt rt5416 brgbr'),(981,'Angelina','Fernandez','[email protected]','panama',1,'fr 456 grgeg e456 gbfbrf gd65'),(982,'jhoanitla','caitica','[email protected]','Tamara',1,'4 gfe gege bf 4 456 ghfbff'),(983,'Linda Esperanza','Mu??oz Quintero','[email protected]','Bogot?? D.C',1,'VFSV 5 hfdb 456 gfrr v45696 gbfdgbfrbgf 125 gdfgbvdfh s'),(984,'Alberto','Lievano','[email protected]','Medell??n',1,'dfge gfgdf 56+ dfdfdf'),(985,'Anacleta','poliert','[email protected]','Tunja',1,'hgd 45 456 ghh 45656 hghbfg hgf'),(986,'pedro benirto','camelas3','[email protected]','Maicao',1,'gr 156 v bfd brfg 4566 bhgdbfbfg'),(987,'pato','abondianceri','[email protected]','burenos aires',0,'g 2+ hgfh gd 16 hgrhf'),(988,'adilgio','ca??ares','[email protected]','hghgffd',1,'gfsdgdsgsd'),(989,'Filipo de3 las estrellas','turro','[email protected]','san juan del cesar',1,'hola soy de san juan '),(990,'Filipo de3 las estrellas','turro','[email protected]','san juan del cesar',1,'hola soy de san juan ');
/*!40000 ALTER TABLE `buzon` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `suscripcion`
--
DROP TABLE IF EXISTS `suscripcion`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `suscripcion` (
`Id_Suscripcion` int(4) NOT NULL AUTO_INCREMENT,
`Nombre_Suscripcion` varchar(50) CHARACTER SET armscii8 NOT NULL,
`Email_Suscripcion` varchar(50) NOT NULL,
`Pais_ciudad_suscripcion` varchar(50) CHARACTER SET armscii8 NOT NULL,
PRIMARY KEY (`Id_Suscripcion`)
) ENGINE=InnoDB AUTO_INCREMENT=251 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `suscripcion`
--
LOCK TABLES `suscripcion` WRITE;
/*!40000 ALTER TABLE `suscripcion` DISABLE KEYS */;
INSERT INTO `suscripcion` VALUES (201,'andrea gomezs','[email protected]','tuinja'),(202,'DEW','[email protected]','4swq'),(203,'DEW','[email protected]','4swq'),(204,'e32e2','[email protected]','avr'),(205,'e32e2','[email protected]','avr'),(206,'wa','[email protected]','de'),(207,'wa','[email protected]','de'),(208,'fde','[email protected]','dcewwe'),(209,'andres rocha','[email protected]','tulua'),(210,'andres rocha','[email protected]','tulua'),(211,'andres rocha','[email protected]','tulua'),(214,'frfreer','[email protected]','fcvcerve'),(218,'Gustavo adolfo','[email protected]','Maicao'),(222,'pedro perez payan','[email protected]','Quito'),(223,'Millonarios','[email protected]','Bta'),(225,'coerrt potre','[email protected]','bogota'),(228,'camilin','[email protected]','gfge 65 de'),(229,'pertr','[email protected]','calieore'),(230,'Andrea Gomez','[email protected]','Quipama'),(231,'arlito','[email protected]','gfsgfsd'),(232,'partokled','[email protected]','frlfsdl'),(233,'adriana','[email protected]','grfgdpgs75'),(234,'quipamqw','[email protected]','vk??pfsvfe'),(235,'mulktreefge','[email protected]','tunja'),(236,'otoo','[email protected]','cali'),(237,'cesar','[email protected]','bta'),(238,'polocho','[email protected]','gkjregbe'),(239,'polocho','[email protected]','gkjregbe'),(240,'muzo','muzeñ[email protected]','gpewo'),(241,'Alba q','[email protected]','bogota'),(242,'Nasly','[email protected]','panama'),(243,'Gustavo','[email protected]','neiva'),(244,'parterin','[email protected]','valledupar'),(245,'pedro espitia','[email protected]','Maputo'),(246,'ponte bacano','[email protected]','Barranquilla'),(247,'trillaer','[email protected]','Dibulla'),(248,'trasillo','[email protected]','mexico'),(249,'gretuyliowe','[email protected]','33'),(250,'gretuyliowe','[email protected]','33');
/*!40000 ALTER TABLE `suscripcion` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping routines for database 'Omnilife'
--
/*!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 2012-07-07 17:02:47
Gracias!.
- Compartir respuesta