{"id":1804,"date":"2012-01-25T08:36:15","date_gmt":"2012-01-25T06:36:15","guid":{"rendered":"http:\/\/www.4webs.es\/blog\/?p=1804"},"modified":"2018-02-06T10:16:40","modified_gmt":"2018-02-06T09:16:40","slug":"modulo-prestashop-reparador-base-de-datos","status":"publish","type":"post","link":"https:\/\/www.4webs.es\/blog\/modulo-prestashop-reparador-base-de-datos","title":{"rendered":"M\u00f3dulo Prestashop reparador base de datos"},"content":{"rendered":"

\"\"<\/p>\n

Bueno hac\u00eda tiempo que nos os tra\u00edamos m\u00f3dulos para Prestashop que no fueran \u00fanicamente la personalizaci\u00f3n del aspecto gr\u00e1fico, y ya que \u00faltimamente estamos hablando de la optimizaci\u00f3n de las tiendas online<\/a>, pues nada mejor que este m\u00f3dulo que optimiza la base de datos, liber\u00e1ndola de espacio y sobre todo no sobrecarg\u00e1ndola, ya que Prestashop guarda ciertos par\u00e1metros que pueden hacer ralentizar mucho el proceso de consulta de la base de datos, por ejemplo en la tabla conexiones hemos visto tablas que pueden ocupar m\u00e1s de 100 megas, esto es una autentica barbaridad, y si va creciendo a ese ritmo os podr\u00e9is encontrar con un gran problema , ya que no podr\u00e1 mover el servidor una base de datos de ese tama\u00f1o.
\nPues bien este m\u00f3dulo para tu tienda Prestashop<\/a><\/strong> borra el contenido de determinadas tablas principalmente de las conexiones, ya que Prestashop guarda toda la informaci\u00f3n de los visitantes con el fin de poder usarlas posteriormente en su sistema de anal\u00edticas, por lo tanto nosotros no recomendamos usar las estad\u00edsticas de Prestashop, os recomendamos que us\u00e9is alguna sistema externo como puede ser Google Analitycs o Piwik y en el caso de compras alg\u00fan Erp o aplicaci\u00f3n de escritorio. Mientras no teng\u00e1is visitas en la tienda no habr\u00e1 problema pero en cuanto el tr\u00e1fico aumente las estad\u00edsticas pueden ser problem\u00e1ticas y causar un buen cuello de botella\u2026<\/p>\n

Por lo tanto este m\u00f3dulo para Prestashop nos va a ahorrar tener que acceder a la base de datos manualmente para buscar o vaciar determinadas tablas, recordar que es muy importante hacer una copia de seguridad antes de usar este m\u00f3dulo, ya que vais a eliminar el contenido de algunas tablas con informaci\u00f3n que os puede ser de utilidad, o simplemente por seguridad.<\/p>\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"

Bueno hac\u00eda tiempo que nos os tra\u00edamos m\u00f3dulos para Prestashop que no fueran \u00fanicamente la personalizaci\u00f3n del aspecto gr\u00e1fico, y ya que \u00faltimamente estamos hablando de la optimizaci\u00f3n de las tiendas online, pues nada mejor que este m\u00f3dulo que optimiza la base de datos, liber\u00e1ndola de espacio y sobre todo no sobrecarg\u00e1ndola, ya que Prestashop … Continuar leyendo \u00abM\u00f3dulo Prestashop reparador base de datos\u00bb<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":1805,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[84],"tags":[],"class_list":{"0":"post-1804","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-modulos-prestashop"},"yoast_head":"\nM\u00f3dulo Prestashop reparador base de datos | 4webs.es<\/title>\n<meta name=\"description\" content=\"Bueno hac\u00eda tiempo que nos os tra\u00edamos m\u00f3dulos para Prestashop que no fueran \u00fanicamente la personalizaci\u00f3n del aspecto gr\u00e1fico, y ya que \u00faltimamente\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.4webs.es\/blog\/modulo-prestashop-reparador-base-de-datos\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"M\u00f3dulo Prestashop reparador base de datos | 4webs.es\" \/>\n<meta property=\"og:description\" content=\"Bueno hac\u00eda tiempo que nos os tra\u00edamos m\u00f3dulos para Prestashop que no fueran \u00fanicamente la personalizaci\u00f3n del aspecto gr\u00e1fico, y ya que \u00faltimamente\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.4webs.es\/blog\/modulo-prestashop-reparador-base-de-datos\" \/>\n<meta property=\"og:site_name\" content=\"4webs\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/4webs\" \/>\n<meta property=\"article:published_time\" content=\"2012-01-25T06:36:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-02-06T09:16:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.4webs.es\/blog\/wp-content\/uploads\/2012\/01\/modulo-prestasho-phpmyadmin.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"603\" \/>\n\t<meta property=\"og:image:height\" content=\"230\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Pablo Risue\u00f1o\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@4webs\" \/>\n<meta name=\"twitter:site\" content=\"@4webs\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pablo Risue\u00f1o\" \/>\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:\\\/\\\/www.4webs.es\\\/blog\\\/modulo-prestashop-reparador-base-de-datos#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.4webs.es\\\/blog\\\/modulo-prestashop-reparador-base-de-datos\"},\"author\":{\"name\":\"Pablo Risue\u00f1o\",\"@id\":\"https:\\\/\\\/www.4webs.es\\\/blog\\\/#\\\/schema\\\/person\\\/fc07e8cecb1e51ce56b131a1eb0b3048\"},\"headline\":\"M\u00f3dulo Prestashop reparador base de datos\",\"datePublished\":\"2012-01-25T06:36:15+00:00\",\"dateModified\":\"2018-02-06T09:16:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.4webs.es\\\/blog\\\/modulo-prestashop-reparador-base-de-datos\"},\"wordCount\":322,\"commentCount\":4,\"image\":{\"@id\":\"https:\\\/\\\/www.4webs.es\\\/blog\\\/modulo-prestashop-reparador-base-de-datos#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.4webs.es\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/01\\\/modulo-prestasho-phpmyadmin.jpg\",\"articleSection\":[\"M\u00f3dulos Prestashop\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.4webs.es\\\/blog\\\/modulo-prestashop-reparador-base-de-datos#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.4webs.es\\\/blog\\\/modulo-prestashop-reparador-base-de-datos\",\"url\":\"https:\\\/\\\/www.4webs.es\\\/blog\\\/modulo-prestashop-reparador-base-de-datos\",\"name\":\"M\u00f3dulo Prestashop reparador base de datos | 4webs.es\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.4webs.es\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.4webs.es\\\/blog\\\/modulo-prestashop-reparador-base-de-datos#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.4webs.es\\\/blog\\\/modulo-prestashop-reparador-base-de-datos#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.4webs.es\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/01\\\/modulo-prestasho-phpmyadmin.jpg\",\"datePublished\":\"2012-01-25T06:36:15+00:00\",\"dateModified\":\"2018-02-06T09:16:40+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.4webs.es\\\/blog\\\/#\\\/schema\\\/person\\\/fc07e8cecb1e51ce56b131a1eb0b3048\"},\"description\":\"Bueno hac\u00eda tiempo que nos os tra\u00edamos m\u00f3dulos para Prestashop que no fueran \u00fanicamente la personalizaci\u00f3n del aspecto gr\u00e1fico, y ya que \u00faltimamente\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.4webs.es\\\/blog\\\/modulo-prestashop-reparador-base-de-datos#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.4webs.es\\\/blog\\\/modulo-prestashop-reparador-base-de-datos\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/www.4webs.es\\\/blog\\\/modulo-prestashop-reparador-base-de-datos#primaryimage\",\"url\":\"https:\\\/\\\/www.4webs.es\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/01\\\/modulo-prestasho-phpmyadmin.jpg\",\"contentUrl\":\"https:\\\/\\\/www.4webs.es\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/01\\\/modulo-prestasho-phpmyadmin.jpg\",\"width\":603,\"height\":230},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.4webs.es\\\/blog\\\/modulo-prestashop-reparador-base-de-datos#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.4webs.es\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"M\u00f3dulo Prestashop reparador base de datos\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.4webs.es\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.4webs.es\\\/blog\\\/\",\"name\":\"4webs\",\"description\":\"Desarrollo con Prestashop, gesti\u00f3n de proyectos ecommerce\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.4webs.es\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.4webs.es\\\/blog\\\/#\\\/schema\\\/person\\\/fc07e8cecb1e51ce56b131a1eb0b3048\",\"name\":\"Pablo Risue\u00f1o\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6938f7637a533914c144759f6249310d5f8fdef83738a4641b2d151a17c19f97?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6938f7637a533914c144759f6249310d5f8fdef83738a4641b2d151a17c19f97?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6938f7637a533914c144759f6249310d5f8fdef83738a4641b2d151a17c19f97?s=96&d=mm&r=g\",\"caption\":\"Pablo Risue\u00f1o\"},\"sameAs\":[\"http:\\\/\\\/www.4webs.es\"],\"url\":\"https:\\\/\\\/www.4webs.es\\\/blog\\\/author\\\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"M\u00f3dulo Prestashop reparador base de datos | 4webs.es","description":"Bueno hac\u00eda tiempo que nos os tra\u00edamos m\u00f3dulos para Prestashop que no fueran \u00fanicamente la personalizaci\u00f3n del aspecto gr\u00e1fico, y ya que \u00faltimamente","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:\/\/www.4webs.es\/blog\/modulo-prestashop-reparador-base-de-datos","og_locale":"es_ES","og_type":"article","og_title":"M\u00f3dulo Prestashop reparador base de datos | 4webs.es","og_description":"Bueno hac\u00eda tiempo que nos os tra\u00edamos m\u00f3dulos para Prestashop que no fueran \u00fanicamente la personalizaci\u00f3n del aspecto gr\u00e1fico, y ya que \u00faltimamente","og_url":"https:\/\/www.4webs.es\/blog\/modulo-prestashop-reparador-base-de-datos","og_site_name":"4webs","article_publisher":"https:\/\/www.facebook.com\/4webs","article_published_time":"2012-01-25T06:36:15+00:00","article_modified_time":"2018-02-06T09:16:40+00:00","og_image":[{"width":603,"height":230,"url":"https:\/\/www.4webs.es\/blog\/wp-content\/uploads\/2012\/01\/modulo-prestasho-phpmyadmin.jpg","type":"image\/jpeg"}],"author":"Pablo Risue\u00f1o","twitter_card":"summary_large_image","twitter_creator":"@4webs","twitter_site":"@4webs","twitter_misc":{"Escrito por":"Pablo Risue\u00f1o","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.4webs.es\/blog\/modulo-prestashop-reparador-base-de-datos#article","isPartOf":{"@id":"https:\/\/www.4webs.es\/blog\/modulo-prestashop-reparador-base-de-datos"},"author":{"name":"Pablo Risue\u00f1o","@id":"https:\/\/www.4webs.es\/blog\/#\/schema\/person\/fc07e8cecb1e51ce56b131a1eb0b3048"},"headline":"M\u00f3dulo Prestashop reparador base de datos","datePublished":"2012-01-25T06:36:15+00:00","dateModified":"2018-02-06T09:16:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.4webs.es\/blog\/modulo-prestashop-reparador-base-de-datos"},"wordCount":322,"commentCount":4,"image":{"@id":"https:\/\/www.4webs.es\/blog\/modulo-prestashop-reparador-base-de-datos#primaryimage"},"thumbnailUrl":"https:\/\/www.4webs.es\/blog\/wp-content\/uploads\/2012\/01\/modulo-prestasho-phpmyadmin.jpg","articleSection":["M\u00f3dulos Prestashop"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.4webs.es\/blog\/modulo-prestashop-reparador-base-de-datos#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.4webs.es\/blog\/modulo-prestashop-reparador-base-de-datos","url":"https:\/\/www.4webs.es\/blog\/modulo-prestashop-reparador-base-de-datos","name":"M\u00f3dulo Prestashop reparador base de datos | 4webs.es","isPartOf":{"@id":"https:\/\/www.4webs.es\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.4webs.es\/blog\/modulo-prestashop-reparador-base-de-datos#primaryimage"},"image":{"@id":"https:\/\/www.4webs.es\/blog\/modulo-prestashop-reparador-base-de-datos#primaryimage"},"thumbnailUrl":"https:\/\/www.4webs.es\/blog\/wp-content\/uploads\/2012\/01\/modulo-prestasho-phpmyadmin.jpg","datePublished":"2012-01-25T06:36:15+00:00","dateModified":"2018-02-06T09:16:40+00:00","author":{"@id":"https:\/\/www.4webs.es\/blog\/#\/schema\/person\/fc07e8cecb1e51ce56b131a1eb0b3048"},"description":"Bueno hac\u00eda tiempo que nos os tra\u00edamos m\u00f3dulos para Prestashop que no fueran \u00fanicamente la personalizaci\u00f3n del aspecto gr\u00e1fico, y ya que \u00faltimamente","breadcrumb":{"@id":"https:\/\/www.4webs.es\/blog\/modulo-prestashop-reparador-base-de-datos#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.4webs.es\/blog\/modulo-prestashop-reparador-base-de-datos"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.4webs.es\/blog\/modulo-prestashop-reparador-base-de-datos#primaryimage","url":"https:\/\/www.4webs.es\/blog\/wp-content\/uploads\/2012\/01\/modulo-prestasho-phpmyadmin.jpg","contentUrl":"https:\/\/www.4webs.es\/blog\/wp-content\/uploads\/2012\/01\/modulo-prestasho-phpmyadmin.jpg","width":603,"height":230},{"@type":"BreadcrumbList","@id":"https:\/\/www.4webs.es\/blog\/modulo-prestashop-reparador-base-de-datos#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.4webs.es\/blog"},{"@type":"ListItem","position":2,"name":"M\u00f3dulo Prestashop reparador base de datos"}]},{"@type":"WebSite","@id":"https:\/\/www.4webs.es\/blog\/#website","url":"https:\/\/www.4webs.es\/blog\/","name":"4webs","description":"Desarrollo con Prestashop, gesti\u00f3n de proyectos ecommerce","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.4webs.es\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/www.4webs.es\/blog\/#\/schema\/person\/fc07e8cecb1e51ce56b131a1eb0b3048","name":"Pablo Risue\u00f1o","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/6938f7637a533914c144759f6249310d5f8fdef83738a4641b2d151a17c19f97?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/6938f7637a533914c144759f6249310d5f8fdef83738a4641b2d151a17c19f97?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6938f7637a533914c144759f6249310d5f8fdef83738a4641b2d151a17c19f97?s=96&d=mm&r=g","caption":"Pablo Risue\u00f1o"},"sameAs":["http:\/\/www.4webs.es"],"url":"https:\/\/www.4webs.es\/blog\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.4webs.es\/blog\/wp-json\/wp\/v2\/posts\/1804","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.4webs.es\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.4webs.es\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.4webs.es\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.4webs.es\/blog\/wp-json\/wp\/v2\/comments?post=1804"}],"version-history":[{"count":2,"href":"https:\/\/www.4webs.es\/blog\/wp-json\/wp\/v2\/posts\/1804\/revisions"}],"predecessor-version":[{"id":9275,"href":"https:\/\/www.4webs.es\/blog\/wp-json\/wp\/v2\/posts\/1804\/revisions\/9275"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.4webs.es\/blog\/wp-json\/wp\/v2\/media\/1805"}],"wp:attachment":[{"href":"https:\/\/www.4webs.es\/blog\/wp-json\/wp\/v2\/media?parent=1804"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.4webs.es\/blog\/wp-json\/wp\/v2\/categories?post=1804"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.4webs.es\/blog\/wp-json\/wp\/v2\/tags?post=1804"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}