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!

Anything else besides phpmyadmin? I have to load 40,000 tables

Discussion in 'Database Discussion' started by edkhosting, Oct 4, 2004.

  1. edkhosting

    edkhosting Member

    Joined:
    Dec 18, 2003
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    151
    I have a db that has 40,000+ tables and grows larger everyday, when i need to access one of the tables i have to load everyone. Is there a way that I can just load the specific table i need instead of all 40,000 of them and having to wait 10-30mins?
     
  2. EasyNetwork

    EasyNetwork Well-Known Member

    Joined:
    May 14, 2003
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    156
    Location:
    New York
    cPanel Access Level:
    Root Administrator
    Type mysql in shell.
     
  3. malk

    malk Member

    Joined:
    Sep 29, 2004
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    151
    Without trying to be criticial, I would suspect that there is something wrong with your database design if you have 40k+ tables.
     
  4. edkhosting

    edkhosting Member

    Joined:
    Dec 18, 2003
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    151
    Free forum hosting service with over 1500 boards, each board is like 12 tables, you do the math. I have anywhere from 50-100 new signups a day.
     
  5. SarcNBit

    SarcNBit Well-Known Member

    Joined:
    Oct 14, 2003
    Messages:
    1,010
    Likes Received:
    3
    Trophy Points:
    168
    You host them all in one db?
     
  6. pirania1

    pirania1 Well-Known Member

    Joined:
    May 10, 2003
    Messages:
    126
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Miami, FL
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. myusername

    myusername Well-Known Member
    PartnerNOC

    Joined:
    Mar 6, 2003
    Messages:
    693
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    chown -R us.*yourbase*
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    scp (not WinSCP) the databases over or use rsync.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  8. Stefaans

    Stefaans Well-Known Member

    Joined:
    Mar 5, 2002
    Messages:
    456
    Likes Received:
    3
    Trophy Points:
    318
    Location:
    Vancouver, Canada
    1 x corrupt db = 1500 broken boards :eek:
     
    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