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!

Copy database

Discussion in 'Database Discussion' started by Nirjonadda, Nov 29, 2017.

  1. Nirjonadda

    Nirjonadda Well-Known Member

    Joined:
    May 8, 2013
    Messages:
    625
    Likes Received:
    15
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    I am getting error from Copy database. Please let me know this fix.

    Screenshot.png
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 Nirjonadda, Nov 29, 2017
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    46,756
    Likes Received:
    2,095
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Can you let us know the full steps you are taking to reproduce the issue? Are you using phpMyAdmin via WHM or from within cPanel?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelMichael, Nov 29, 2017
  3. Nirjonadda

    Nirjonadda Well-Known Member

    Joined:
    May 8, 2013
    Messages:
    625
    Likes Received:
    15
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    I am using phpMyAdmin by accessing phpMyAdmin via cPanel.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 Nirjonadda, Nov 29, 2017
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    46,756
    Likes Received:
    2,095
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    I've been unable to reproduce the issue on a test system. Could you open a support ticket so we can take a closer look?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelMichael, Nov 29, 2017
  5. Nirjonadda

    Nirjonadda Well-Known Member

    Joined:
    May 8, 2013
    Messages:
    625
    Likes Received:
    15
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    Does this happen from 10223.88 MB Size? Its show me Copying database but show error after long time.

    Screenshot(1).png
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 Nirjonadda, Nov 29, 2017
  6. Nirjonadda

    Nirjonadda Well-Known Member

    Joined:
    May 8, 2013
    Messages:
    625
    Likes Received:
    15
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    I see Database found in the cPanel after this error but its 0MB. Does Database copy worked?

    Screenshot(2).png
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 Nirjonadda, Nov 29, 2017
  7. 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,

    I think the database size is something causing the issue. Did you try to restore the database manually from the command line to check if that goes smoothly.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #7 24x7server, Nov 30, 2017
  8. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    46,756
    Likes Received:
    2,095
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Could you let us know the output to /usr/local/cpanel/logs/error_log when this happens?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #8 cPanelMichael, Nov 30, 2017
(You must log in or sign up to post here.)
Loading...
Similar Threads - Copy database
  1. Saitow

    Error on Copy database to in phpmyadmin

    Saitow, Sep 6, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    883
    cPanelLauren
    Sep 6, 2018
  2. Oluwatosin

    Copy home directory and database to another server?

    Oluwatosin, Apr 19, 2018, in forum: Data Protection
    Replies:
    1
    Views:
    375
    cPanelMichael
    Apr 19, 2018
  3. pbixdesign

    Copy a database from one account to another account by ssh

    pbixdesign, Jan 14, 2018, in forum: Database Discussion
    Replies:
    4
    Views:
    1,099
    cPWilliamL
    Jan 15, 2018
  4. daemoncesar

    Database copy creating prefixes error

    daemoncesar, Dec 13, 2017, in forum: Database Discussion
    Replies:
    4
    Views:
    429
    daemoncesar
    Dec 13, 2017
  5. darjohn

    How to encrypt backup copy to Google Drive

    darjohn, Mar 3, 2019, in forum: Data Protection
    Replies:
    3
    Views:
    244
    cPanelLauren
    Mar 5, 2019

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.
    Accept Learn More...
    Dismiss Notice