Trouble importing database in command line.

Transferring a site from Dreamhost to Linode. Having trouble importing via command line.

I created a new database called mattspaeth_com on the new host, which is the same as the original. My MySQL username on Dreamhost is different, it is root on Linode. As far as I can tell, that doesn’t matter, does it?

Uploaded the backup, named mattspaeth_com.sql to the root folder of my user directory on the Linode.

Entered this:
mysql -p -u root mattspaeth_com < mattspaeth_com.sql

It just advances to the next line without any messages.

I load the site and it takes me through the standard setup for wp-config.php and setting username, password, etc. It’s an empty WordPress.

What am I doing wrong?

Update: I learned how to view the tables in the command line and it did actually import. I think the reason it’s not working is because Dreamhost puts extra characters in the table names and WordPress is just reading the standard ones. For instance, wp_posts is named wp_47vchh_posts.

What should I do?

Update 2: Just learned about table prefixes. Doh!