I’m moving my wordpress website to local for testing purpose.
I encountered the error below when I’m trying to import the .sql that I export from CPanel PHPMyadmin into local MYSQL Workbench.
FYI, I’m using MYSQL Workbench 6.0 and MYSQL Administrator 1.2.17
15:08:07 Restoring C:UsersabcDesktopdb.sql
Running: mysql.exe --defaults-extra-file="c:usersabcappdatalocaltemp3tmpdemide.cnf" --host=localhost --user=root --port=3307 --default-character-set=utf8 --comments --database=db < "C:\Users\abc\Desktop\db.sql"
ERROR 1049 (42000): Unknown database 'db'
Operation failed with exitcode 1
15:08:08 Import of C:UsersabcDesktopdb.sql has finished with 1 errors
Apparently the export was done without specifying a database (schema), so you have to create it manually first before you can import the dump. MySQL Workbench allows to import a dump to a different (including a new) schema. You can specify this on the import page:
You looks like you have to create a database first
and then import your sql file.