{"id":3438,"date":"2009-12-14T17:07:13","date_gmt":"2009-12-14T21:07:13","guid":{"rendered":"https:\/\/apps4rent.com\/support\/?p=3438"},"modified":"2013-05-28T05:48:44","modified_gmt":"2013-05-28T09:48:44","slug":"how-can-i-create-database-from-sql-backup-file","status":"publish","type":"post","link":"https:\/\/www.apps4rent.com\/support\/kb\/article\/how-can-i-create-database-from-sql-backup-file","title":{"rendered":"How can I create a database from a SQL backup file?"},"content":{"rendered":"

To create a database from a SQL backup file, follow these instructions:<\/p>\n

First, create the database.<\/p>\n

\/path\/to\/bin\/mysqladmin -u $mysqlusername -p$mysqlpassword create $mysqldatabasename<\/p>\n

Then, add user permission to it.
\n\/path\/to\/bin\/mysqladmin -u usernamehere -ppasshere create databasename<\/p>\n

Finally, add the tables back:
\n\/path\/to\/bin\/mysql -u $mysqlusername -p$mysqlpassword $mysqldatabasename < backup.sql
\nOR:
\nmysql -u user -p -e ‘source backup_file’ database<\/p>\n

Related links:<\/p>\n

Related Links:<\/strong><\/p>\n

MOSS Hosting<\/a><\/p>\n

Windows Hyper-V Hosting<\/a><\/p>\n

Virtual Dedicated Servers (VDS)<\/a><\/p>\n

Hyper-V Price Plans<\/a><\/p>\n

Hyper-V Features<\/a><\/p>\n

Server Administration Plan<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

To create a database from a SQL backup file, follow these instructions: First, create the database. \/path\/to\/bin\/mysqladmin -u $mysqlusername -p$mysqlpassword create $mysqldatabasename Then, add user permission to it. \/path\/to\/bin\/mysqladmin -u usernamehere -ppasshere create databasename Finally, add the tables back: \/path\/to\/bin\/mysql -u $mysqlusername -p$mysqlpassword $mysqldatabasename < backup.sql OR: mysql -u user -p -e ‘source backup_file’ database […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1056,1054],"tags":[],"class_list":["post-3438","post","type-post","status-publish","format-standard","hentry","category-hyper-v","category-virtual-servers"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/posts\/3438","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/comments?post=3438"}],"version-history":[{"count":0,"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/posts\/3438\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/media?parent=3438"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/categories?post=3438"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/tags?post=3438"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}