The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Large MySQL Database

Discussion in 'General Discussion' started by xcensus, Sep 17, 2003.

  1. xcensus

    xcensus Member

    Joined:
    May 10, 2003
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    151
    Hi

    Have a client who needs to transfer a large database over to our hosting, he has tried myphp etc but it fails because db is too big, any other ways to transfer it over ?

    cPanel.net Support Ticket Number:
     
    #1 xcensus, Sep 17, 2003
  2. gfmorris

    gfmorris Member

    Joined:
    Jun 6, 2003
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    151
    Location:
    Huntsville, AL, USA
    Try a sqldump, then FTP the file to the new server and pull it in [via command line if necessary].

    If it's still too big, dump individual tables and import them that way.

    GFM

    cPanel.net Support Ticket Number:
     
    #2 gfmorris, Sep 17, 2003
  3. albertldee

    albertldee Member

    Joined:
    May 10, 2003
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    151
    here try this it work on a 30mb dump i had

    cPanel.net Support Ticket Number:
     

    Attached Files:

    #3 albertldee, Sep 17, 2003
  4. mjm

    mjm BANNED

    Joined:
    Aug 1, 2003
    Messages:
    69
    Likes Received:
    0
    Trophy Points:
    156
    #4 mjm, Sep 17, 2003
(You must log in or sign up to post here.)
Loading...
Similar Threads - Large MySQL Database
  1. Shane76

    Mysql Slow Log is Large - Can it be reset?

    Shane76, Apr 3, 2016, in forum: Database Discussions
    Replies:
    1
    Views:
    640
    cPanelMichael
    Apr 4, 2016
  2. mathfrick

    Row Size too large error

    mathfrick, Jul 14, 2017, in forum: Database Discussions
    Replies:
    1
    Views:
    94
    cPanelMichael
    Jul 14, 2017
  3. sneader

    SOLVED Bash script to find large error_log files? Run as cron?

    sneader, Mar 29, 2017, in forum: Workarounds and Optimization
    Replies:
    6
    Views:
    375
    cPanelMichael
    Mar 29, 2017
  4. webmasteryoda

    SOLVED Best way to transfer very large accounts

    webmasteryoda, Mar 23, 2017, in forum: Data Protection
    Replies:
    7
    Views:
    546
    webmasteryoda
    May 1, 2017
  5. sagarR

    Locate large email attachments

    sagarR, Mar 17, 2017, in forum: E-mail Discussions
    Replies:
    1
    Views:
    258
    cPanelMichael
    Mar 17, 2017

Share This Page