#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Chennai,TamilNadu,India
    Posts
    33
    Rep Power
    14
    Hi everyone

    Is there any limit for tables in a database and number of fields in a table.

    TA
    Raghu.
  2. #2
  3. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,642
    Rep Power
    4492
    There's a limit on total database size, 2+ gigabytes, depending on your operating system.

    I don't remember reading anything about limitations on tables or fields, though.

    Read through the manual...it's your best bet.

    ---JH

    ------------------
    *************************************************************
    * The manual can probably answer 90% of your questions...
    *
    * PHP Manual. www.php.net/manual
    * MySQL Manual: www.mysql.com/documentation/mysql/bychapter
    *************************************************************
  4. #3
  5. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    62
    Actually, the default MySQL table size limit for version 3.22.x is 4 GB, but the OS/hardware in question can limit that to 2 GB. 64-bit hardware (Alpha, Sun) can take care of that problem right away.

    MySQL 3.23.x Beta has support for tables up to the maximum size of a 64-bit filesystem (about 8 terabytes).

    For what it's worth: PostgreSQL has an unlimited table size even on 32-bit hardware.
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    4
    Rep Power
    0
    I have a large 223Mb .dmp file that I'm trying to import but I'm having no luck. The symptoms are that the server is just hanging at about 20 tables and gives no error as to what is causing this "hang". I just wonder if the file is too large or if there's "specific" syntax that I'm not using. I'm using: mysql -u root -p DATABASENAME < FILENAME.dmp; Thx.
  8. #5
  9. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,642
    Rep Power
    4492
    SIZE DOESN'T MATTER!!!

    Now that I've got that out of the way, I wouldn't think there would be a restriction on the dump file size. Maybe you could divide it up into smaller parts and see if it works better. Seems like that would be a big hassle, though.

    Are you sure it's really hanging and not just taking a loooooong time to execute?? How long did you give it to complete??

    Try searching through the manual to see if there are any comments about dump file sizes....

    ---John Holmes

    ------------------
    *************************************************************
    * The manual can probably answer 90% of your questions...
    *
    * PHP Manual. www.php.net/manual
    * MySQL Manual: www.mysql.com/documentation/mysql/bychapter
    *************************************************************
  10. #6
  11. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    4
    Rep Power
    0
    Well, I did it again...and it takes about 2hours to get done. I watch the "top" stats until MySQL drops off or goes down to .05% CPU usage. My biggest problem is that the database that was given to me needs to be imported at which time I'm trying to write scripts to massage data. Now since it didn't "seem" like it was done I tried to open it in MSWord (since it is only in text format) I got 32,000 pages through and saw an extra table that I know is supposed to be in there and so that's why I know it's not really a complete import. I tried reading about sizes and I haven't seen anything. I was thinking of dumping portions at a time but I think my only option is to dump each table or the whole thing, right? Well I REALLY appreciate you responding.

    Hehe,I suck at MySQL and keep hoping every time I open it up that it acts like Oracle, but to my dismay there's actual leg work. It's free and great for what it's doing now so I'm happy with it, well I will be if I can get this thing imported correctly.

    C
  12. #7
  13. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    4
    Rep Power
    0
    BTW do happen to know what I could use as a reader for a .dmp file of that size? (223MB) I tried MSWord, WordPad, Notepad, and UltraEdit of which couldn't handle it. Thx again.

    Ç
  14. #8
  15. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    62
    UltraEdit should have no problem handling a file much bigger than that, if you just change some settings:

    On the toolbar, open Advanced -> Configuration, and go to the 'General' tab. At the top right, check 'Disable line number' and/or 'Open file without Temp file'.

    Before you open your text file, though, be sure you have a backup, because without a Temp file, edits will be applied instantly.

Similar Threads

  1. How do I find out what tables are on the database?
    By Swell in forum Oracle Development
    Replies: 7
    Last Post: February 18th, 2004, 08:18 AM
  2. Large tables or many small tables?
    By Tassadar356 in forum MySQL Help
    Replies: 4
    Last Post: February 8th, 2004, 01:07 PM
  3. How to know which tables are on a database?
    By c.caraccioli in forum PostgreSQL Help
    Replies: 5
    Last Post: January 22nd, 2004, 01:06 PM
  4. Count all tables in a database
    By Joput in forum PHP Development
    Replies: 1
    Last Post: January 14th, 2004, 08:31 AM
  5. creating database & tables using ASP
    By pdxlooie in forum ASP Programming
    Replies: 2
    Last Post: December 26th, 2003, 05:27 PM

IMN logo majestic logo threadwatch logo seochat tools logo