Exporting then importing database

[tristanlee85]

I'm trying to export my entire 'xcart' database from my remote server and import it to MySQL in the server I'm hosting locally on my computer. I've tried exporting the entire database and when I save it, it saves as 'localhost.sql'. Then, I login into phpMyAdmin on my local server to import the SQL file, but it's telling me there is no SQL query.

How can I copy this entire database over?

[krelvinaz]

What does the contents of your localhost.sql file look like ? (just part of it)