{"id":38506,"date":"2017-09-01T15:05:08","date_gmt":"2017-09-01T20:05:08","guid":{"rendered":"http:\/\/webirix.com\/?p=38506"},"modified":"2017-09-01T15:05:08","modified_gmt":"2017-09-01T20:05:08","slug":"importar-base-datos-mysql-consola","status":"publish","type":"post","link":"https:\/\/webirix.com\/en\/importar-base-datos-mysql-consola\/","title":{"rendered":"import mysql database console"},"content":{"rendered":"<h1>Export \/ Import a MYSQL database from console.<\/h1>\n<p><strong>To export<\/strong><br \/>\n#Visplay the databases<br \/>\nmysql&gt; show database;<\/p>\n<p># Export a particular database<br \/>\nmysql -u user -p database_name&gt;\u00a0<span class=\"skimlinks-unlinked\">file.sql<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong>To import<\/strong><br \/>\n#create the database<br \/>\nmysql&gt; create database database_name;<\/p>\n<p>&nbsp;<\/p>\n<p>#Preverse process to mysql<br \/>\nmysql -u root -p database_name &lt;\u00a0<span class=\"skimlinks-unlinked\">database_path.sql<\/span><\/p>","protected":false},"excerpt":{"rendered":"<p>Export \/ Import a MYSQL database from console. To Export #V display the databases mysql&gt; show database; #Export a particular database mysql -u user -p database_name&gt; file.sql To Import #create the mysql database&gt; create database database_name; #Preverse process to mysql mysql -u root -p ...<\/p>","protected":false},"author":25,"featured_media":38507,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2043],"tags":[],"class_list":["post-38506","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-estrategias"],"jetpack_featured_media_url":"https:\/\/webirix.com\/wp-content\/uploads\/2017\/09\/mysql_logo.jpg","_links":{"self":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/38506","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/comments?post=38506"}],"version-history":[{"count":2,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/38506\/revisions"}],"predecessor-version":[{"id":38509,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/38506\/revisions\/38509"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/media\/38507"}],"wp:attachment":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/media?parent=38506"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/categories?post=38506"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/tags?post=38506"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}