MYSQL importing dump completed with errors

Question

when I try to import my exported dump file (specifically my database/schema) to other computer, I got this error;

D:\CAPSTONE SYSTEM\MyDataBaseCAPSTONE\Dump20150922\schm_capstonesystem_routines.sql does not contain schema/table information 16:58:55 Restoring schm_capstonesystem (employee_entry) Running: mysql.exe --defaults-file="c:\users\kc\appdata\local\temp\tmpnowdu_.cnf" --protocol=tcp --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments --database=schm_capstonesystem < "D:\CAPSTONE SYSTEM\MyDataBaseCAPSTONE\Dump20150922\schm_capstonesystem_employee_entry.sql" ERROR 1049 (42000): Unknown database 'schm_capstonesystem'

Operation failed with exitcode 1

Please help~! :-(

Jens · Accepted Answer · 2015-09-22 09:06:01Z

3

The error is Unknown database. You have to create the database 'schm_capstonesystem' first. And then run the import of your dump.

answered Sep 22, 2015 at 9:06

Jens

69.6k15 gold badges107 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

DjayPediA Over a year ago

okay? should I have to create the 'schm_capstonesystem' database first before importing?

Shawn Paes · Accepted Answer · 2018-03-21 15:07:06Z

0

In case you don't know how to create the schema as in the answer above: right Click the left pane under Schema in SQL, click create schema,enter a name for the schema (preferably the same as the db your importing) click apply. Then do the import

answered Mar 21, 2018 at 15:07

Shawn Paes

1

Collectives™ on Stack Overflow

MYSQL importing dump completed with errors

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related