Go to phpMyAdmin in your web broswer and select the database you wish to back up by clicking on the name. If you have multiple databases, you will need to select the name from the drop menu.
In the right-hand frame, you will see a row of links. Click [SQL]
You will see a large input box for queries and below that you will see a smaller box labeled Browse.
Click the button, navigate to and select the backup file on your home computer and click the .
Warning:
There are sometimes file size limitations on importing a database backup this way. If your database is too large, you might encounter PHP timeout errors. In that case, you will need to attempt to restore your database via SSH/Telnet.
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
In php.ini upload_max_filesize is one of the variables that was giving me trouble. This should be at least as large as your .sql or .gz file.
Also in php.ini post_max_size may give problems. Mine was already set to a size larger than my db, so I don't think this affected my issue, but it could be affecting yours.
Next is the my.ini file. max_allowed_packet caused me problems here. I increased this to 16m from 1m and was able to successfully import my db.