{"id":816,"date":"2018-06-21T15:06:15","date_gmt":"2018-06-21T18:06:15","guid":{"rendered":"http:\/\/www.tech-nico.com\/blog\/?p=816"},"modified":"2018-06-21T15:06:15","modified_gmt":"2018-06-21T18:06:15","slug":"tip-mysql-dump-volcando-por-tablas","status":"publish","type":"post","link":"http:\/\/www.tech-nico.com\/blog\/tip-mysql-dump-volcando-por-tablas\/","title":{"rendered":"Tip MySQL: DUMP – Volcando por tablas"},"content":{"rendered":"

TIP MYSQL<\/h1>\n

Como exportar tablas de mysql por consola:<\/h3>\n

Hay veces en que si la base de datos se hace muy grande podemos tener la necesidad de exportarla por partes. Este ejemplo lo use para exportar una base de datos mysql de WordPress, con lo cual la tabla \u00abPosts\u00bb\u00a0era la mas pesada de todas,<\/p>\n

# exportar solo la tabla posts<\/strong><\/em>
\nmysqldump -uUSUARIO<\/em> -pCLAVE<\/em> BaseDeDatos prefix_posts > dump0.sql<\/p>\n

# exportar el resto de las tablas ignorando la tabla posts<\/strong> <\/em>
\nmysqldump -uUSUARIO<\/em> -pCLAVE<\/em> BaseDeDatos –ignore-table=BaseDeDatos.prefix_posts > dump1.sql<\/p>\n","protected":false},"excerpt":{"rendered":"

TIP MYSQL Como exportar tablas de mysql por consola: Hay veces en que si la base de datos se hace muy grande podemos tener la necesidad de exportarla por partes. Este ejemplo lo use para exportar una base de datos … Sigue leyendo →<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":600,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_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},"jetpack_post_was_ever_published":false},"categories":[29],"tags":[79],"class_list":["post-816","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-general","tag-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1650%2C1400","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/phA9Q-da","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":523,"url":"http:\/\/www.tech-nico.com\/blog\/api-mikrotik-manipular-wireless-registration-y-access-list-con-php-y-mysql\/","url_meta":{"origin":816,"position":0},"title":"API MIKROTIK – Manipular Wireless-Registration y Access-List con PHP y MYSQL","author":"soporte","date":"julio 2, 2014","format":false,"excerpt":"En esta ocasi\u00f3n, te traigo un peque\u00f1o sistema desarrollado en php y mysql para que puedas controlar cada cliente de un nodos AP de distintas o una misma localidad. Esto te permitir\u00e1 habilitar\/deshabilitar un MacAddress del access-list de much\u00edsimos AP desde un solo lugar, tambien ver el nivel de se\u00f1al\u2026","rel":"","context":"En \u00abPHP\u00bb","block_context":{"text":"PHP","link":"http:\/\/www.tech-nico.com\/blog\/category\/programacion\/php\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=1050%2C600 3x"},"classes":[]},{"id":172,"url":"http:\/\/www.tech-nico.com\/blog\/galeria-de-fotos-flash-con-comentarios-php\/","url_meta":{"origin":816,"position":1},"title":"Galeria de Fotos Flash II con Comentarios","author":"soporte","date":"diciembre 2, 2009","format":false,"excerpt":"Por suerte la\u00a0Galeria de Fotos en Flash y PHP (con thumbs GD) y lectura de folders tubo mucha\u00a0aceptaci\u00f3n;\u00a0as\u00ed\u00a0que\u00a0aqu\u00ed\u00a0va la \"Versi\u00f3n\u00a0del Galery en flash con comentarios\" tipo fotolog :D Como varios me lo han pedido, aqui esta la version del galery en flash con comentarios. El sistema de comentarios se basa\u2026","rel":"","context":"En \u00abFlash\u00bb","block_context":{"text":"Flash","link":"http:\/\/www.tech-nico.com\/blog\/category\/programacion\/flash\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=1050%2C600 3x"},"classes":[]},{"id":270,"url":"http:\/\/www.tech-nico.com\/blog\/crontab-y-php-enviar-logs-procesos-o-backups-via-mail\/","url_meta":{"origin":816,"position":2},"title":"Crontab y PHP: Enviar logs, procesos, o backups via mail","author":"soporte","date":"noviembre 29, 2011","format":false,"excerpt":"Algo que\u00a0surgi\u00f3\u00a0anoche en la clase de Linux (Crontab), fue casualmente \"poder hacer un backup\u00a0autom\u00e1tico\u00a0y que lo\u00a0envie\u00a0a nuestro mail\".\u00a0Todav\u00eda\u00a0no aprendimos Bash Scripting \/ Pyton \/ Perl o bien para el que esta mi\u00a0situaci\u00f3n, tenemos la alternativa de ejecutar un script PHP. Inicialmente este script hacia un dump de la base de\u2026","rel":"","context":"En \u00ablinux\u00bb","block_context":{"text":"linux","link":"http:\/\/www.tech-nico.com\/blog\/category\/linux\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=1050%2C600 3x"},"classes":[]},{"id":820,"url":"http:\/\/www.tech-nico.com\/blog\/probar-droplets-de-digital-ocean-por-2-meses-gratis\/","url_meta":{"origin":816,"position":3},"title":"Probar Droplets de Digital Ocean por 2 meses gratis","author":"soporte","date":"junio 22, 2018","format":false,"excerpt":"Testeando Maquinas virtuales en Digital Ocean Para todos los que se registren con este link, tendran U$S 10 de credito. https:\/\/m.do.co\/c\/565eb7f74a91 Cuando se registren, les va a pedir que ingresen los datos de su tarjeta de cr\u00e9dito. (Don't worry, hay que ingresarlos y no te cobran hasta que no gastes\u2026","rel":"","context":"En \u00abtecnolog\u00eda\u00bb","block_context":{"text":"tecnolog\u00eda","link":"http:\/\/www.tech-nico.com\/blog\/category\/tecnologia\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2018\/06\/digitalOcean.png?fit=598%2C518&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2018\/06\/digitalOcean.png?fit=598%2C518&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2018\/06\/digitalOcean.png?fit=598%2C518&resize=525%2C300 1.5x"},"classes":[]},{"id":132,"url":"http:\/\/www.tech-nico.com\/blog\/galeria-de-fotos-en-flash-y-php-con-thumbs-gd-y-lectura-de-folders\/","url_meta":{"origin":816,"position":4},"title":"Galeria de Fotos en Flash y PHP (con thumbs GD) y lectura de folders.","author":"soporte","date":"mayo 20, 2009","format":false,"excerpt":"Hace mucho tiempo tuve que crear una galer\u00eda de fotos en flash y PHP ( que me saco de muchos apuros ). Lo particularmente bueno de esta galer\u00eda es que levanta las fotos on the fly desde carpetas del servidor que creemos o ya est\u00e9n creadas. Entonces el cliente mismo\u2026","rel":"","context":"En \u00abFlash\u00bb","block_context":{"text":"Flash","link":"http:\/\/www.tech-nico.com\/blog\/category\/programacion\/flash\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=1050%2C600 3x"},"classes":[]},{"id":52,"url":"http:\/\/www.tech-nico.com\/blog\/ataque-a-paginas-asp-y-sql-server-con-trojan-asprox\/","url_meta":{"origin":816,"position":5},"title":"Ataque a paginas ASP y SQL SERVER con Trojan AspRox","author":"soporte","date":"septiembre 12, 2008","format":false,"excerpt":"Ataque de Cadena ASCII (Encoded\/Binary) Automatica de SQL Injection o en ingles ASCII Encoded\/Binary String Automated SQL Injection Attack. Descripcion del Ataque: Recientemente, nos venimos cruzando con un tipo de SQL Injection muy particular e interesante, que, hasta ahora puede ser muy dificil de limpiar, incluso hasta con el mas\u2026","rel":"","context":"En \u00abseguridad\u00bb","block_context":{"text":"seguridad","link":"http:\/\/www.tech-nico.com\/blog\/category\/seguridad\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.tech-nico.com\/blog\/wp-content\/uploads\/2015\/05\/logo_tech_nico.com_.jpg?fit=1200%2C1018&resize=1050%2C600 3x"},"classes":[]}],"_links":{"self":[{"href":"http:\/\/www.tech-nico.com\/blog\/wp-json\/wp\/v2\/posts\/816","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.tech-nico.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.tech-nico.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.tech-nico.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.tech-nico.com\/blog\/wp-json\/wp\/v2\/comments?post=816"}],"version-history":[{"count":1,"href":"http:\/\/www.tech-nico.com\/blog\/wp-json\/wp\/v2\/posts\/816\/revisions"}],"predecessor-version":[{"id":817,"href":"http:\/\/www.tech-nico.com\/blog\/wp-json\/wp\/v2\/posts\/816\/revisions\/817"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.tech-nico.com\/blog\/wp-json\/wp\/v2\/media\/600"}],"wp:attachment":[{"href":"http:\/\/www.tech-nico.com\/blog\/wp-json\/wp\/v2\/media?parent=816"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.tech-nico.com\/blog\/wp-json\/wp\/v2\/categories?post=816"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.tech-nico.com\/blog\/wp-json\/wp\/v2\/tags?post=816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}