I'm going to preface this with saying I'm a complete newbie at this database stuff before the rolling of the eyes happens, so please be patient with me.
I have an sql dump that I am trying to import and access (running Linux mysql). I created the database...
mysql> CREATE DATABASE db_name
And then tried to import the sql file into the database...
mysql -uroot -p db_name < db_import.sql
At this point, I don't see any errors and everything seems fine, so I assume the import worked. However, I have no idea how to access the imported data because
SELECT * FROM db_name; returns
ERROR 1146 (42S02): Table 'db_name.db_name' doesn't exist. Similarly for
I understand that it's looking for a table
db_name, but where would the imported data go? How can I access it? Did I do the import wrong?