How can I create a database from a SQL backup file?
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 […]
Read More »