Sometimes you need to copy a database to a dev database or something. You can usually do this through phpmyadmin, but it’s so much faster, especially with large databases, to do it through command line.<\/p>\n
Once ssh’d into a server with mysql on it, create a new database for the one you’re going to import data into, this can be done in phpmyadmin, or through command line. This is how I would do it in command line:
\n[code]
\nmysql -u user -ppassword
\nmysql> create database new_database;
\nexit
\n[\/code]<\/p>\n
Then type these two commands to the ssh terminal
\n[code]
\nmysqldump -u USER -pPASSWORD old_database > filename.sql
\nmysql -u USER -pPASSWORD new_database < filename.sql
\n[\/code]<\/p>\n","protected":false},"excerpt":{"rendered":"
Sometimes you need to copy a database to a dev database or something. You can usually do this through phpmyadmin, but it’s so much faster, especially with large databases, to… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7,10],"tags":[],"_links":{"self":[{"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/posts\/136"}],"collection":[{"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/comments?post=136"}],"version-history":[{"count":0,"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/posts\/136\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/media?parent=136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/categories?post=136"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.evermoretechnologies.com\/blog\/wp-json\/wp\/v2\/tags?post=136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}