Posted by yolau

Although you can do a database import and/or export from phpMyAdmin there is a size limitation (defined in my.cnf max_allowed_packet) when you do an import, so the only solution is to import it from shell.
This article will show you how simple it is to do it.
Importing a mysql database

Login to your server as root or [...]