Notice:

We've recently performed some software upgrades to both cPanel and the Client Area that has resulted in some of the KB articles appearing outdated and obsolete. We are working to update and/or remove the affected articles but this may take some time. We appreciate your patience!

How can I import a large database? PhpMyAdmin times out.

For importing large databases we recommend using tools such as MySQL Query Browser.

Before being able to connect remotely you will have to:

  1. Create a database and grant a user with all rights to it;
  2. Add your local IP in the allowed IPs to access the MySQL service.

All of the above can be done from the MySQL manager in cPanel.