MySQL Import shows successful but no tables generated

Question

Tried importing a small .sql file (~5MB) via cmd. Within a few seconds the import returns as if it was successful (no errors or warnings), however, when I refresh the schema in workbench or check contents of the folder representation of the schema, the schema appears to be empty.

This is the command I used:

mysql -hlocalhost -uroot -ppassword db_name < C:\sql_input_path\db.sql > C:\error_log_output_path\error.txt

In addition, I tried importing the .sql file using the Workbench import tool, which also shows successful, but nothing seems to be reflected in the actual schema after a refresh.

Any ideas why this is and how to correct this? I have been trying to figure this out for quite some time.

thanks in advance!

Answer 1

Just quoteing Ravinder Reddys:

"Check in the db.sql file, if use db_name is included with a different db_name than what you are expecting. Ravinder Reddy May 26 '14 at 16:38

Worked for me.