Trying to upload a database - Works in remote but not local server

[John Diver]

Hey,
i am trying to restore a database dump on my local server.

I am getting the error No tables found in database

There are tables and I used the same database for a restore on my local server.

Anyone know what it could be?

[mbailey]

Does your database dump contain the appropriate create table queries? Insert queries will fail if the specified tables don't exist.

[John Diver]

Yes it does.

I am using the exact same file on my local server as I am on my remote but it is saying no tables found.

[eva2000]

how you restoring via mysql command

mysql -u mysqlusername -p databasename < /path/to/back.sql

same version of mysql on both servers remote and local ?

[John Diver]

I am restoring via phpmyadmin on the remote and local servers.

The mysql on my local server is older but it should still be able to read the tables in the .sql file.

Thanks

[eva2000]

phpmyadmin isn't recommended as it has problems with timeouts and larger files

best to use ssh telnet and the command i listed above in post #4