PJR Sales and Service - Knowledgebase - How can I import a large database to my account? PhpMyAdmin times out.

Computer Co-op, CornerNET Internet Gateway, and PJR Solutions is owned by PJR Sales & Service. Quality products and online services since 1991. We can be your
Complete Computer Connection

Hosting @ $5.95

Domains @ $16.98

Home Page

Knowledgebase
You are here: Portal Home > Knowledgebase > cPanel Related Issues > MySQL management issues > How can I import a large database to my account? PhpMyAdmin times out.

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

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

Before being able to connect remotely you will have to:
Create a database and assign a username with full privileges to it; (howto)
Add your IP address in the allowed IPs to access the MySQL service. (howto)

All of the above can be done via the MySQL section in cPanel.

Add to Favourites
Print this Article

Also Read

I get an error 'ACCESS DENIED CREATE DATABASE db_name' when I try to import a database (Views: 10054)

I get syntax error when trying to run a MySQL query. (Views: 1060)

I don't have enough privileges for creating/dropping databases in PhpMyAdmin (Views: 2706)

I have problems accessing my MySQL database remotely (Views: 5298)

My application cannot connect to my database. (Views: 5027)