Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MSQL importing database is slow

Discussion in 'Database Discussion' started by Akinyemi Alamu, Aug 28, 2018.

  1. Akinyemi Alamu

    Akinyemi Alamu Registered

    Joined:
    Aug 28, 2018
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Nigeria
    cPanel Access Level:
    Root Administrator
    I got a Dedicated server 4 months ago from Godaddy. And presently am trying to install a script and its taking forever to import the database.

    I tried to install the same script on a separate VPS and it installed perfectly.

    How can I configure the MYSQL through WHM or Cpanel in order to make the MySQL import faster?

    Because it later timeout when it takes longer than required.
     
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,890
    Likes Received:
    91
    Trophy Points:
    78
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hi,

    How exactly are you importing the database, is it through WHM or through phpmyadmin?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,503
    Likes Received:
    2,179
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @Akinyemi Alamu,

    How large is the database you are importing? Are you attempting to import it through phpMyAdmin, or via the command line? Or, is the PHP script attempting to populate an existing MySQL database?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice