How to import mysql backup?
 

I backup mysql from the old server and trying to import all the data in the new database on the new server. I'm all over phpMyAdmin and can't find anything there :helpme

Just copy/paste the SQL code into a huge SQL query :) What export method did u use?

Going to sleep. Try what I said :)

Exported it as SQL and save as File

Just copy and paste it all into a SQL query in phpMyAdmin

Or with the command line, something like mysql -u xxx db < file.txt

Don't remember exactly... Haven't used mysql in a long time :)

in SSH type:

mysql -u {username} -p -h {hostname} {dbname} < mysqldumpfile.sql

or, much more wisely, just paypal me $50 to do it for you. :smilie_we