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