Using SSH is a much more efficient way of importing a large MYSQL database than trying to use phpMyadmin. But if you’re not used to using SSH / Telnet, it can be a bit awkward.
Here are full and easy instructions on how to import a mysql database using SSH / TELNET.
- Use FTP to transfer your MySQL database to your server
- Create a remote connection using your SSH program to your server
- Navigate to the directory where you uploaded your MySQL database
- Enter this command: mysql -u username -p -h servername data-base-name < data.sql
- The system will prompt you for the database password
- Enter the password
- You’re done.