mairving — Fri, 15 Mar 2002 17:06:46 +0000

Make sure of a couple of things when you import the data.
One is to make sure that the < is going the right way.
If it is going > this way, it will take your empty database and overwrite it with nothing, so backup.sql will have no data at all.

Also you will probably need to do this at the command line:
/pathto/mysql DATABASE_NAME -u USERNAME -pPASSWORD < /pathto/backup.sql, specifying pathnames, etc.

Peter J. Boettcher — Fri, 15 Mar 2002 13:50:50 +0000

I'm not sure how to restore the db through PHPAdmin, but through the shell the syntax is:

mysql database < backup-file.sql

For more info check out this link: http://www.mysql.com/doc/m/y/mysqldump.html