{"id":651,"date":"2019-08-01T10:18:11","date_gmt":"2019-08-01T13:18:11","guid":{"rendered":"https:\/\/maurobernal.com.ar\/blog\/?p=651"},"modified":"2019-08-01T10:18:11","modified_gmt":"2019-08-01T13:18:11","slug":"como-restaurar-una-sola-tabla-en-mysql","status":"publish","type":"post","link":"https:\/\/maurobernal.com.ar\/blog\/como-restaurar-una-sola-tabla-en-mysql\/","title":{"rendered":"Como restaurar una sola tabla en MYSQL"},"content":{"rendered":"<p>Desde MYSQL es posible exclu\u00edr una tabla en el momento del backup, pero no es posible solo restaurar una sola tabla. A continuaci\u00f3n te mostramos como:<\/p>\n<h2>Restaurar una sola tabla en MYSQL<\/h2>\n<p>En base a lo anterior en el momento de realizar nuestro backup con <strong>MYSQLDUMP\u00a0<\/strong>podemos excluir o ignorar aquellas tablas que no deseamos realizar un backup mediante el parametro <em>&#8211;ignore<\/em><\/p>\n<pre>--ignore-table=db_name.tbl_name Do not dump the given table, which must be specified using both the database and table names. To ignore multiple tables, use this option multiple times. This option also can be used to ignore views.<\/pre>\n<p>Sin embargo, en ambientes de producci\u00f3n es necesario restaurar una sola tabla (o varias) en una nueva ubicaci\u00f3n. Para ello podemos hacer lo siguiente:<\/p>\n<h3>1- Desde nuestra consola Linux creamos el siguiente script:<\/h3>\n<pre title=\"Creamos el script\" class=\"lang:vim decode:true\">touch restore.sh\r\nnano restore.sh<\/pre>\n<h3>2 &#8211; Colocamos en su interior lo siguiente:<\/h3>\n<pre title=\"Script para restaurar una sola tabla en MYSQL\" class=\"lang:vim decode:true\">#!\/bin\/bash\r\n\r\n####\r\n# Split MySQL dump SQL file into one file per table\r\n# based on http:\/\/blog.tty.nl\/2011\/12\/28\/splitting-a-database-dump\r\n####\r\n\r\nif [ $# -lt 1 ] ; then\r\n  echo \"USAGE $0 DUMP_FILE [TABLE]\"\r\n  exit\r\nfi\r\n\r\nif [ $# -ge 2 ] ; then\r\n  csplit -s -ftable $1 \"\/-- Table structure for table\/\" \"%-- Table structure for table \\`$2\\`%\" \"\/-- Table structure for table\/\" \"%40103 SET TIME_ZONE=@OLD_TIME_ZONE%1\"\r\nelse\r\n  csplit -s -ftable $1 \"\/-- Table structure for table\/\" {*}\r\nfi\r\n\r\n[ $? -eq 0 ] || exit\r\n\r\nmv table00 head\r\n\r\nFILE=`ls -1 table* | tail -n 1`\r\nif [ $# -ge 2 ] ; then\r\n  mv $FILE foot\r\nelse\r\n  csplit -b '%d' -s -f$FILE $FILE \"\/40103 SET TIME_ZONE=@OLD_TIME_ZONE\/\" {*}\r\n  mv ${FILE}1 foot\r\nfi\r\n\r\nfor FILE in `ls -1 table*`; do\r\n  NAME=`head -n1 $FILE | cut -d$'\\x60' -f2`\r\n  cat head $FILE foot &gt; \"$NAME.sql\"\r\ndone\r\n\r\nrm head foot table*<\/pre>\n<p>Fuente:\u00a0<a href=\"https:\/\/gist.github.com\/jasny\/1608062\">https:\/\/gist.github.com\/jasny\/1608062<\/a><\/p>\n<h3>3 &#8211; Le damos permiso para ejecutar el script<\/h3>\n<pre class=\"lang:vim decode:true \">chmod +x restore.sh<\/pre>\n<h3>4- Uso del script<\/h3>\n<p>El mismo permite limpiar un archivo de backup de MySQL y dejar la parte relevante a nuestra tabla. Su uso ser\u00eda as\u00ed:<\/p>\n<ul>\n<li>Extraer todas las tablas en archivos individuales<\/li>\n<\/ul>\n<pre title=\"restore.sh mybackup.sql\" class=\"lang:vim decode:true\">.\/restore.sh mybackup.sql<\/pre>\n<ul>\n<li>Extraer una sola tabla espec\u00edfica en un archivo individual<\/li>\n<\/ul>\n<pre title=\"restore.sh mybackup.sql table1\" class=\"lang:default decode:true\">restore.sh mybackup.sql table1<\/pre>\n<p>5-Restaurar la tabla en una base especif\u00edca<\/p>\n<pre title=\"mysql restore database\" class=\"lang:vim decode:true \">mysql -D mydatabase &lt; mytable1.sql<\/pre>\n<p>Espero que le sea \u00fatil<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Desde MYSQL es posible exclu\u00edr una tabla en el momento del backup, pero no es posible solo restaurar una sola tabla. A continuaci\u00f3n te mostramos como: Restaurar una sola tabla&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[5],"tags":[7,172,170,157,171],"class_list":["post-651","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql-2","tag-restaurar","tag-restore","tag-ssh","tag-table"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Como restaurar una sola tabla en MYSQL &#183; devops Mauro Bernal<\/title>\n<meta name=\"description\" content=\"Como restaurar una sola tabla en mysql, sobre linux generando archivos separadas para cada tabla de un mismo backup. How restore one single table in mysql\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/maurobernal.com.ar\/blog\/como-restaurar-una-sola-tabla-en-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como restaurar una sola tabla en MYSQL &#183; devops Mauro Bernal\" \/>\n<meta property=\"og:description\" content=\"Como restaurar una sola tabla en mysql, sobre linux generando archivos separadas para cada tabla de un mismo backup. How restore one single table in mysql\" \/>\n<meta property=\"og:url\" content=\"https:\/\/maurobernal.com.ar\/blog\/como-restaurar-una-sola-tabla-en-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"devops Mauro Bernal\" \/>\n<meta property=\"article:published_time\" content=\"2019-08-01T13:18:11+00:00\" \/>\n<meta name=\"author\" content=\"Mauro Bernal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@_maurobernal\" \/>\n<meta name=\"twitter:site\" content=\"@_maurobernal\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mauro Bernal\" \/>\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:\\\/\\\/maurobernal.com.ar\\\/blog\\\/como-restaurar-una-sola-tabla-en-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/como-restaurar-una-sola-tabla-en-mysql\\\/\"},\"author\":{\"name\":\"Mauro Bernal\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#\\\/schema\\\/person\\\/09c4dbdfb59b20e015c703fd19713283\"},\"headline\":\"Como restaurar una sola tabla en MYSQL\",\"datePublished\":\"2019-08-01T13:18:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/como-restaurar-una-sola-tabla-en-mysql\\\/\"},\"wordCount\":185,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#\\\/schema\\\/person\\\/09c4dbdfb59b20e015c703fd19713283\"},\"keywords\":[\"mysql\",\"restaurar\",\"restore\",\"ssh\",\"table\"],\"articleSection\":[\"MYSQL\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/como-restaurar-una-sola-tabla-en-mysql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/como-restaurar-una-sola-tabla-en-mysql\\\/\",\"url\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/como-restaurar-una-sola-tabla-en-mysql\\\/\",\"name\":\"Como restaurar una sola tabla en MYSQL &#183; devops Mauro Bernal\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#website\"},\"datePublished\":\"2019-08-01T13:18:11+00:00\",\"description\":\"Como restaurar una sola tabla en mysql, sobre linux generando archivos separadas para cada tabla de un mismo backup. How restore one single table in mysql\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/como-restaurar-una-sola-tabla-en-mysql\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/como-restaurar-una-sola-tabla-en-mysql\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/como-restaurar-una-sola-tabla-en-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como restaurar una sola tabla en MYSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/\",\"name\":\"devops Mauro Bernal\",\"description\":\"Cuando tu trabajo es hacer que las cosas funcionen bien...\",\"publisher\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#\\\/schema\\\/person\\\/09c4dbdfb59b20e015c703fd19713283\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#\\\/schema\\\/person\\\/09c4dbdfb59b20e015c703fd19713283\",\"name\":\"Mauro Bernal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/i0.wp.com\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/logo-maurobernal.png?fit=1740%2C1740&ssl=1\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/logo-maurobernal.png?fit=1740%2C1740&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/logo-maurobernal.png?fit=1740%2C1740&ssl=1\",\"width\":1740,\"height\":1740,\"caption\":\"Mauro Bernal\"},\"logo\":{\"@id\":\"https:\\\/\\\/i0.wp.com\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/logo-maurobernal.png?fit=1740%2C1740&ssl=1\"},\"description\":\"Desarrollo de Sistemas en .Net, IT Callcenters, DBA de SQL Server, Mikrotik, Pentest y T\u00e9cnico consultor de Sistemas Bejerman\",\"sameAs\":[\"https:\\\/\\\/maurobernal.com.ar\",\"https:\\\/\\\/x.com\\\/_maurobernal\",\"https:\\\/\\\/youtube.com\\\/maurobernal\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como restaurar una sola tabla en MYSQL &#183; devops Mauro Bernal","description":"Como restaurar una sola tabla en mysql, sobre linux generando archivos separadas para cada tabla de un mismo backup. How restore one single table in mysql","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:\/\/maurobernal.com.ar\/blog\/como-restaurar-una-sola-tabla-en-mysql\/","og_locale":"es_ES","og_type":"article","og_title":"Como restaurar una sola tabla en MYSQL &#183; devops Mauro Bernal","og_description":"Como restaurar una sola tabla en mysql, sobre linux generando archivos separadas para cada tabla de un mismo backup. How restore one single table in mysql","og_url":"https:\/\/maurobernal.com.ar\/blog\/como-restaurar-una-sola-tabla-en-mysql\/","og_site_name":"devops Mauro Bernal","article_published_time":"2019-08-01T13:18:11+00:00","author":"Mauro Bernal","twitter_card":"summary_large_image","twitter_creator":"@_maurobernal","twitter_site":"@_maurobernal","twitter_misc":{"Escrito por":"Mauro Bernal","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/maurobernal.com.ar\/blog\/como-restaurar-una-sola-tabla-en-mysql\/#article","isPartOf":{"@id":"https:\/\/maurobernal.com.ar\/blog\/como-restaurar-una-sola-tabla-en-mysql\/"},"author":{"name":"Mauro Bernal","@id":"https:\/\/maurobernal.com.ar\/blog\/#\/schema\/person\/09c4dbdfb59b20e015c703fd19713283"},"headline":"Como restaurar una sola tabla en MYSQL","datePublished":"2019-08-01T13:18:11+00:00","mainEntityOfPage":{"@id":"https:\/\/maurobernal.com.ar\/blog\/como-restaurar-una-sola-tabla-en-mysql\/"},"wordCount":185,"commentCount":0,"publisher":{"@id":"https:\/\/maurobernal.com.ar\/blog\/#\/schema\/person\/09c4dbdfb59b20e015c703fd19713283"},"keywords":["mysql","restaurar","restore","ssh","table"],"articleSection":["MYSQL"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/maurobernal.com.ar\/blog\/como-restaurar-una-sola-tabla-en-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/maurobernal.com.ar\/blog\/como-restaurar-una-sola-tabla-en-mysql\/","url":"https:\/\/maurobernal.com.ar\/blog\/como-restaurar-una-sola-tabla-en-mysql\/","name":"Como restaurar una sola tabla en MYSQL &#183; devops Mauro Bernal","isPartOf":{"@id":"https:\/\/maurobernal.com.ar\/blog\/#website"},"datePublished":"2019-08-01T13:18:11+00:00","description":"Como restaurar una sola tabla en mysql, sobre linux generando archivos separadas para cada tabla de un mismo backup. How restore one single table in mysql","breadcrumb":{"@id":"https:\/\/maurobernal.com.ar\/blog\/como-restaurar-una-sola-tabla-en-mysql\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/maurobernal.com.ar\/blog\/como-restaurar-una-sola-tabla-en-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/maurobernal.com.ar\/blog\/como-restaurar-una-sola-tabla-en-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/maurobernal.com.ar\/blog\/"},{"@type":"ListItem","position":2,"name":"Como restaurar una sola tabla en MYSQL"}]},{"@type":"WebSite","@id":"https:\/\/maurobernal.com.ar\/blog\/#website","url":"https:\/\/maurobernal.com.ar\/blog\/","name":"devops Mauro Bernal","description":"Cuando tu trabajo es hacer que las cosas funcionen bien...","publisher":{"@id":"https:\/\/maurobernal.com.ar\/blog\/#\/schema\/person\/09c4dbdfb59b20e015c703fd19713283"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/maurobernal.com.ar\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/maurobernal.com.ar\/blog\/#\/schema\/person\/09c4dbdfb59b20e015c703fd19713283","name":"Mauro Bernal","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2023\/07\/logo-maurobernal.png?fit=1740%2C1740&ssl=1","url":"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2023\/07\/logo-maurobernal.png?fit=1740%2C1740&ssl=1","contentUrl":"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2023\/07\/logo-maurobernal.png?fit=1740%2C1740&ssl=1","width":1740,"height":1740,"caption":"Mauro Bernal"},"logo":{"@id":"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2023\/07\/logo-maurobernal.png?fit=1740%2C1740&ssl=1"},"description":"Desarrollo de Sistemas en .Net, IT Callcenters, DBA de SQL Server, Mikrotik, Pentest y T\u00e9cnico consultor de Sistemas Bejerman","sameAs":["https:\/\/maurobernal.com.ar","https:\/\/x.com\/_maurobernal","https:\/\/youtube.com\/maurobernal"]}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/posts\/651","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/comments?post=651"}],"version-history":[{"count":1,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/posts\/651\/revisions"}],"predecessor-version":[{"id":652,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/posts\/651\/revisions\/652"}],"wp:attachment":[{"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/media?parent=651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/categories?post=651"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/tags?post=651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}