Importing a massive 156mb database

I have a database of 156mb but im having a few problems using phpmyadmin via cpanel - I onyl see one post asking about this and its very old so I thought I would ask !

Any help would be a great help

 

import it via bigdump.php

 

I use Navicat for all DB management. I have imported 10Gb+ databases using it.

In this case or any large db restore, you will want to get the backup on your server and import it via command line. Navicat would work for something like this, but large imports should be done locally to prevent problems.

Do you have ssh access to your server?

 

ssh will make it for you in just 1 sec

 

^^ +1 for SSH

 

I use EMS SQL manager. But your database host should allow you to have databases more than 100 MB... MAX limit of the most of the hosts are 200