{"id":2472,"date":"2015-03-20T22:49:00","date_gmt":"2015-03-20T21:49:00","guid":{"rendered":"http:\/\/www.anadebreuil.org\/blog\/?p=2472"},"modified":"2020-11-28T20:43:26","modified_gmt":"2020-11-28T19:43:26","slug":"chuleta-de-4-acciones-habituales-con-mysql","status":"publish","type":"post","link":"https:\/\/www.anadebreuil.org\/blog\/?p=2472","title":{"rendered":"Chuleta de 4 acciones habituales con MySQL"},"content":{"rendered":"<p>Esta es una chuleta de cuatro comandos que realizan tareas habituales en MySQL:<\/p>\n<dl>\n<dt>1. Crear una base de datos nueva<\/dt>\n<dd>Tener preparado un fichero <cite>crear.sql<\/cite> con un contenido como \u00e9ste:<\/p>\n<pre><code>DROP DATABASE IF EXISTS dbname;\nCREATE DATABASE IF NOT EXISTS dbname\n    DEFAULT CHARACTER SET = utf8;\nGRANT ALL PRIVILEGES ON dbname.*\n    TO \"username\"@\"%\"\n    IDENTIFIED BY \"password\";\nFLUSH PRIVILEGES;<\/code><\/pre>\n<p><!--more--><br \/>\nSi tiene MySQL8 o superior, no puedes crear el usuario al mismo tiempo. Usa esta otra versi\u00f3n:<\/p>\n<pre><code>CREATE USER IF NOT EXISTS 'username' IDENTIFIED BY 'password';\nDROP DATABASE IF EXISTS dbname;\nCREATE DATABASE IF NOT EXISTS dbname\n    DEFAULT CHARACTER SET = utf8;\nGRANT ALL PRIVILEGES ON dbname.*\n    TO \"username\"@\"%\";\nFLUSH PRIVILEGES;<\/code><\/pre>\n<p>y cargarlo en la base de datos:<\/p>\n<pre><code>mysql --host=makina.example.com --password[=password]\\\n --user=admin &lt; crear.sql<\/code><\/pre>\n<\/dd>\n<dt><strong>2.Hacer la copia de la base de datos<\/strong><\/dt>\n<dd>\n<pre><code>mysqldump --opt --host=makina.example.com\\\n --password[=password] --user=username dbname &gt; file.sql<\/code><\/pre>\n<p>y copiar s\u00f3lo la definici\u00f3n de las tablas:<\/p>\n<pre><code>mysqldump --opt --host=makina.example.com\\\n --password[=password] --user=username\\\n --no-data dbname &gt; file.sql<\/code><\/pre>\n<\/dd>\n<dt><strong>3.Restaurar la base de datos<\/strong><\/dt>\n<dd>\n<pre><code>mysql --host=makina.example.com --password[=password]\\\n --user=username --database=dbname &lt; file.sql<\/code><\/pre>\n<\/dd>\n<dt><strong>4. Usa <cite>&#8211;help<\/cite><\/strong><\/dt>\n<dd>Si necesitas m\u00e1s opciones y alternativas para usar los comandos <cite>mysql<\/cite> y <cite>mysqldump<\/cite>, usa la opci\u00f3n <cite>&#8211;help<\/cite>.<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"<p>Esta es una chuleta de cuatro comandos que realizan tareas habituales en MySQL: 1. Crear una base de datos nueva Tener preparado un fichero crear.sql con un contenido como \u00e9ste: DROP DATABASE IF&#8230;<\/p>\n","protected":false},"author":1,"featured_media":2491,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[68],"tags":[69],"class_list":["post-2472","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-chuletas","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.anadebreuil.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2472","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.anadebreuil.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.anadebreuil.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.anadebreuil.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.anadebreuil.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2472"}],"version-history":[{"count":24,"href":"https:\/\/www.anadebreuil.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2472\/revisions"}],"predecessor-version":[{"id":3056,"href":"https:\/\/www.anadebreuil.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2472\/revisions\/3056"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.anadebreuil.org\/blog\/index.php?rest_route=\/wp\/v2\/media\/2491"}],"wp:attachment":[{"href":"https:\/\/www.anadebreuil.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.anadebreuil.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.anadebreuil.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}