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.

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

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

  1. edkhosting

    edkhosting Member

    Joined:
    Dec 18, 2003
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    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:
    6
    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:
    1
    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:
    1
    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:
    38
    You host them all in one db?
     
  6. pirania1

    pirania1 Well-Known Member

    Joined:
    May 10, 2003
    Messages:
    126
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Miami, FL
  7. myusername

    myusername Well-Known Member
    PartnerNOC

    Joined:
    Mar 6, 2003
    Messages:
    691
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    chown -R us.*yourbase*
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    scp (not WinSCP) the databases over or use rsync.
     
  8. Stefaans

    Stefaans Well-Known Member

    Joined:
    Mar 5, 2002
    Messages:
    451
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    Vancouver, Canada
    1 x corrupt db = 1500 broken boards :eek:
     

Share This Page