{"id":19,"date":"2017-12-13T16:40:37","date_gmt":"2017-12-13T16:40:37","guid":{"rendered":"http:\/\/vacilos.com\/blog\/?p=19"},"modified":"2019-10-24T12:33:53","modified_gmt":"2019-10-24T09:33:53","slug":"import-sql-file-into-an-existing-database","status":"publish","type":"post","link":"http:\/\/vacilos.com\/blog\/import-sql-file-into-an-existing-database\/","title":{"rendered":"Import .sql file into an existing database"},"content":{"rendered":"<p>The simple command to import an .sql file into an existing database:<\/p>\n<pre class=\"lang-sql prettyprint prettyprinted\"><code><span class=\"pln\">mysql <\/span><span class=\"pun\">-<\/span><span class=\"pln\">u username <\/span><span class=\"pun\">-<\/span><span class=\"pln\">p database_name <\/span><span class=\"pun\">&lt;<\/span> <span class=\"kwd\">file<\/span><span class=\"pun\">.<\/span><span class=\"pln\">sql<\/span><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>The simple command to import an .sql file into an existing database: mysql -u username -p database_name &lt; file.sql<\/p>\n","protected":false},"author":1,"featured_media":20,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,2],"tags":[10,9,3],"class_list":["post-19","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-terminal","tag-command","tag-database","tag-terminal"],"_links":{"self":[{"href":"http:\/\/vacilos.com\/blog\/wp-json\/wp\/v2\/posts\/19","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/vacilos.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/vacilos.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/vacilos.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/vacilos.com\/blog\/wp-json\/wp\/v2\/comments?post=19"}],"version-history":[{"count":1,"href":"http:\/\/vacilos.com\/blog\/wp-json\/wp\/v2\/posts\/19\/revisions"}],"predecessor-version":[{"id":21,"href":"http:\/\/vacilos.com\/blog\/wp-json\/wp\/v2\/posts\/19\/revisions\/21"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/vacilos.com\/blog\/wp-json\/wp\/v2\/media\/20"}],"wp:attachment":[{"href":"http:\/\/vacilos.com\/blog\/wp-json\/wp\/v2\/media?parent=19"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/vacilos.com\/blog\/wp-json\/wp\/v2\/categories?post=19"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/vacilos.com\/blog\/wp-json\/wp\/v2\/tags?post=19"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}