{"id":158,"date":"2012-10-11T21:39:54","date_gmt":"2012-10-11T21:39:54","guid":{"rendered":"http:\/\/blog.luisrodriguez.pe\/?p=158"},"modified":"2012-10-13T16:28:17","modified_gmt":"2012-10-13T16:28:17","slug":"subir-sql-pesado-solucion","status":"publish","type":"post","link":"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/","title":{"rendered":"Subir sql pesado\u200f SOLUCION"},"content":{"rendered":"

Hace unos meses atras he tenido que migrar de hosting y se me dio un gran problema con base de datos (MYSQL) ya que pesaba algo mas de 100 MB, Hacer esto por phpMyAdmin<\/a> ni pensarlo por que normalmente en los hosting los valores de php.ini son muy basico y en este caso hablamos de los valores de:<\/p>\n

    \n
  1. max_file_uploads<\/li>\n
  2. memory_limit<\/li>\n<\/ol>\n

    tipico que por esto mande error desde el phpMyAdmin<\/a> ahora ya descartanto podemos usar un software de escritorio que uno que uso y me parece comodo para trabajar es el SQL-Front<\/a>\u00a0\u00a0 que tiene opcion a conectarse a un servidor mysql remoto.<\/p>\n

    Instalas el programa y cuando abres te mando una venta donde clickeas en \u00abnew<\/strong>\u00bb<\/p>\n

    \"\"\"\"<\/a>
    \nen servidor<\/strong> colocas la ip o el url del dominio donde esta creado la base de datos lo demas por defecto y al ir a la pesta\u00f1a Login<\/strong> hay tienes para colocar el usuario de la base de datos y luego aceptar y ya puedes ver desde tu escritorio la base de datos y puedes clickear a la base de datos importar\u00a0 listo lo hace rapido.<\/p>\n

    Pero hay ocaciones que los hosting bloquean para evitar este tipo de coneccion para esto tenemos a BigDump<\/a>\u00a0 un script en php que configuramos con los datos de servidor,usuario de bd, contrase\u00f1a de bd, nombre de la bd y la ruta del script sql que recomiendo que sea en el mismo nivel de directorio
    \nNota: todo esto lo hacen desde la linea 42<\/strong> <\/p>\n

    \n\n
    \/\/ Database configuration<\/span>\n \n$db_server\u00a0\u00a0<\/span> =<\/span> 'localhost'<\/span>;<\/span>\n$db_name\u00a0\u00a0\u00a0\u00a0<\/span> =<\/span> ''<\/span>;<\/span>\n$db_username<\/span> =<\/span> ''<\/span>;<\/span>\n$db_password<\/span> =<\/span> ''<\/span>;<\/span>\n \n\/\/ Other settings (optional)<\/span>\n \n$filename\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span> =<\/span> ''<\/span>;<\/span>\u00a0\u00a0\u00a0\u00a0 \/\/ Specify the dump filename to suppress the file selection dialog<\/span>\n$ajax\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span> =<\/span> true<\/span>;<\/span>\u00a0\u00a0 \/\/ AJAX mode: import will be done without refreshing the website<\/span>\n$linespersession\u00a0\u00a0\u00a0<\/span> =<\/span> 3000<\/span>;<\/span>\u00a0\u00a0 \/\/ Lines to be executed per one import session<\/span>\n$delaypersession\u00a0\u00a0\u00a0<\/span> =<\/span> 0<\/span>;<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/ You can specify a sleep time in milliseconds after each session<\/span>\n\/\/ Works only if JavaScript is activated. Use to reduce server overrun<\/span><\/pre><\/td><\/tr><\/table><\/div>\n\n<\/blockquote>\n
     <\/p>\n
    despues de configurar esos datos lo ejecutamos colocando la url de ubicacion y ya con eso tenemos la base de datos. De todas maneras una de estas opciones si o si podras solucionar este problema.<\/p>\n","protected":false},"excerpt":{"rendered":"Hace unos meses atras he tenido que migrar de hosting y se me dio un gran problema con base de datos (MYSQL) ya que pesaba algo mas de 100 MB, Hacer esto por phpMyAdmin ni pensarlo por que normalmente en los hosting los valores de php.ini son muy basico y en este caso hablamos de[…]","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,11],"tags":[],"class_list":["post-158","post","type-post","status-publish","format-standard","hentry","category-mysql","category-utilidades"],"yoast_head":"\nSubir sql pesado\u200f SOLUCION - Blog Luis Rodriguez<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Subir sql pesado\u200f SOLUCION - Blog Luis Rodriguez\" \/>\n<meta property=\"og:description\" content=\"Hace unos meses atras he tenido que migrar de hosting y se me dio un gran problema con base de datos (MYSQL) ya que pesaba algo mas de 100 MB, Hacer esto por phpMyAdmin ni pensarlo por que normalmente en los hosting los valores de php.ini son muy basico y en este caso hablamos de[...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog Luis Rodriguez\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/luisrodriguez.pe\" \/>\n<meta property=\"article:published_time\" content=\"2012-10-11T21:39:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2012-10-13T16:28:17+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/blog.luisrodriguez.pe\/wp-content\/uploads\/2012\/10\/ventana-de-agregar-servidor-mysql.png\" \/>\n<meta name=\"author\" content=\"Luis Rodriguez\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@luizmirodriguez\" \/>\n<meta name=\"twitter:site\" content=\"@luizmirodriguez\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Luis Rodriguez\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/\"},\"author\":{\"name\":\"Luis Rodriguez\",\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/#\/schema\/person\/ec55de81e01fdaf3533eb78f6a49090c\"},\"headline\":\"Subir sql pesado\u200f SOLUCION\",\"datePublished\":\"2012-10-11T21:39:54+00:00\",\"dateModified\":\"2012-10-13T16:28:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/\"},\"wordCount\":289,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/blog.luisrodriguez.pe\/wp-content\/uploads\/2012\/10\/ventana-de-agregar-servidor-mysql.png\",\"articleSection\":[\"MYSQL\",\"Utilidades\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/\",\"url\":\"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/\",\"name\":\"Subir sql pesado\u200f SOLUCION - Blog Luis Rodriguez\",\"isPartOf\":{\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/blog.luisrodriguez.pe\/wp-content\/uploads\/2012\/10\/ventana-de-agregar-servidor-mysql.png\",\"datePublished\":\"2012-10-11T21:39:54+00:00\",\"dateModified\":\"2012-10-13T16:28:17+00:00\",\"author\":{\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/#\/schema\/person\/ec55de81e01fdaf3533eb78f6a49090c\"},\"breadcrumb\":{\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/#primaryimage\",\"url\":\"http:\/\/blog.luisrodriguez.pe\/wp-content\/uploads\/2012\/10\/ventana-de-agregar-servidor-mysql.png\",\"contentUrl\":\"http:\/\/blog.luisrodriguez.pe\/wp-content\/uploads\/2012\/10\/ventana-de-agregar-servidor-mysql.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/luisrodriguez.pe\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Subir sql pesado\u200f SOLUCION\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/#website\",\"url\":\"https:\/\/luisrodriguez.pe\/blog\/\",\"name\":\"Blog Luis Rodriguez\",\"description\":\"Analytics Developer\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/luisrodriguez.pe\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/luisrodriguez.pe\/blog\/#\/schema\/person\/ec55de81e01fdaf3533eb78f6a49090c\",\"name\":\"Luis Rodriguez\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/3b0f9734b267ecb38e1860734b4caebda4efa8be9a2bb536862b6a2ba23afa82?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3b0f9734b267ecb38e1860734b4caebda4efa8be9a2bb536862b6a2ba23afa82?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3b0f9734b267ecb38e1860734b4caebda4efa8be9a2bb536862b6a2ba23afa82?s=96&d=mm&r=g\",\"caption\":\"Luis Rodriguez\"},\"description\":\"Hola, Soy Luis Rodriguez, radico en Lima \u2013 Per\u00fa, formado en una carrera inform\u00e1tica, desempe\u00f1ando desde el 2007 como programador web y viendo proyectos desde Front End y Back End a lo que me perfile como Full Stack. Esta Experiencia junto a mi inter\u00e9s en la Anal\u00edtica Web me ayud\u00f3 mucho entender el funcionamiento interno de las herramientas de anal\u00edtica, con las que vengo trabajo activamente desde 2017. Linkedin\",\"sameAs\":[\"http:\/\/luisrodriguez.pe\"],\"url\":\"https:\/\/luisrodriguez.pe\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Subir sql pesado\u200f SOLUCION - Blog Luis Rodriguez","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/","og_locale":"es_ES","og_type":"article","og_title":"Subir sql pesado\u200f SOLUCION - Blog Luis Rodriguez","og_description":"Hace unos meses atras he tenido que migrar de hosting y se me dio un gran problema con base de datos (MYSQL) ya que pesaba algo mas de 100 MB, Hacer esto por phpMyAdmin ni pensarlo por que normalmente en los hosting los valores de php.ini son muy basico y en este caso hablamos de[...]","og_url":"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/","og_site_name":"Blog Luis Rodriguez","article_publisher":"https:\/\/www.facebook.com\/luisrodriguez.pe","article_published_time":"2012-10-11T21:39:54+00:00","article_modified_time":"2012-10-13T16:28:17+00:00","og_image":[{"url":"http:\/\/blog.luisrodriguez.pe\/wp-content\/uploads\/2012\/10\/ventana-de-agregar-servidor-mysql.png","type":"","width":"","height":""}],"author":"Luis Rodriguez","twitter_card":"summary_large_image","twitter_creator":"@luizmirodriguez","twitter_site":"@luizmirodriguez","twitter_misc":{"Escrito por":"Luis Rodriguez","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/#article","isPartOf":{"@id":"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/"},"author":{"name":"Luis Rodriguez","@id":"https:\/\/luisrodriguez.pe\/blog\/#\/schema\/person\/ec55de81e01fdaf3533eb78f6a49090c"},"headline":"Subir sql pesado\u200f SOLUCION","datePublished":"2012-10-11T21:39:54+00:00","dateModified":"2012-10-13T16:28:17+00:00","mainEntityOfPage":{"@id":"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/"},"wordCount":289,"commentCount":0,"image":{"@id":"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/#primaryimage"},"thumbnailUrl":"http:\/\/blog.luisrodriguez.pe\/wp-content\/uploads\/2012\/10\/ventana-de-agregar-servidor-mysql.png","articleSection":["MYSQL","Utilidades"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/","url":"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/","name":"Subir sql pesado\u200f SOLUCION - Blog Luis Rodriguez","isPartOf":{"@id":"https:\/\/luisrodriguez.pe\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/#primaryimage"},"image":{"@id":"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/#primaryimage"},"thumbnailUrl":"http:\/\/blog.luisrodriguez.pe\/wp-content\/uploads\/2012\/10\/ventana-de-agregar-servidor-mysql.png","datePublished":"2012-10-11T21:39:54+00:00","dateModified":"2012-10-13T16:28:17+00:00","author":{"@id":"https:\/\/luisrodriguez.pe\/blog\/#\/schema\/person\/ec55de81e01fdaf3533eb78f6a49090c"},"breadcrumb":{"@id":"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/#primaryimage","url":"http:\/\/blog.luisrodriguez.pe\/wp-content\/uploads\/2012\/10\/ventana-de-agregar-servidor-mysql.png","contentUrl":"http:\/\/blog.luisrodriguez.pe\/wp-content\/uploads\/2012\/10\/ventana-de-agregar-servidor-mysql.png"},{"@type":"BreadcrumbList","@id":"https:\/\/luisrodriguez.pe\/blog\/subir-sql-pesado-solucion\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/luisrodriguez.pe\/blog\/"},{"@type":"ListItem","position":2,"name":"Subir sql pesado\u200f SOLUCION"}]},{"@type":"WebSite","@id":"https:\/\/luisrodriguez.pe\/blog\/#website","url":"https:\/\/luisrodriguez.pe\/blog\/","name":"Blog Luis Rodriguez","description":"Analytics Developer","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/luisrodriguez.pe\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/luisrodriguez.pe\/blog\/#\/schema\/person\/ec55de81e01fdaf3533eb78f6a49090c","name":"Luis Rodriguez","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/3b0f9734b267ecb38e1860734b4caebda4efa8be9a2bb536862b6a2ba23afa82?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3b0f9734b267ecb38e1860734b4caebda4efa8be9a2bb536862b6a2ba23afa82?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3b0f9734b267ecb38e1860734b4caebda4efa8be9a2bb536862b6a2ba23afa82?s=96&d=mm&r=g","caption":"Luis Rodriguez"},"description":"Hola, Soy Luis Rodriguez, radico en Lima \u2013 Per\u00fa, formado en una carrera inform\u00e1tica, desempe\u00f1ando desde el 2007 como programador web y viendo proyectos desde Front End y Back End a lo que me perfile como Full Stack. Esta Experiencia junto a mi inter\u00e9s en la Anal\u00edtica Web me ayud\u00f3 mucho entender el funcionamiento interno de las herramientas de anal\u00edtica, con las que vengo trabajo activamente desde 2017. Linkedin","sameAs":["http:\/\/luisrodriguez.pe"],"url":"https:\/\/luisrodriguez.pe\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/luisrodriguez.pe\/blog\/wp-json\/wp\/v2\/posts\/158","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/luisrodriguez.pe\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/luisrodriguez.pe\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/luisrodriguez.pe\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/luisrodriguez.pe\/blog\/wp-json\/wp\/v2\/comments?post=158"}],"version-history":[{"count":5,"href":"https:\/\/luisrodriguez.pe\/blog\/wp-json\/wp\/v2\/posts\/158\/revisions"}],"predecessor-version":[{"id":163,"href":"https:\/\/luisrodriguez.pe\/blog\/wp-json\/wp\/v2\/posts\/158\/revisions\/163"}],"wp:attachment":[{"href":"https:\/\/luisrodriguez.pe\/blog\/wp-json\/wp\/v2\/media?parent=158"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/luisrodriguez.pe\/blog\/wp-json\/wp\/v2\/categories?post=158"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/luisrodriguez.pe\/blog\/wp-json\/wp\/v2\/tags?post=158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}