SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Nov 2004
    Chico, CA
    0 Post(s)
    0 Thread(s)

    Solution For Large MySQL Databases

    What I am doing!
    I am recreating my website based around PHP/MySQL because I lsot my entire MySQL database because it was "too large" according to my host and there was no way I could back it up. Basically I have 3 levels of origanization with large content at the end so what I was planing on having 3 tables to represent each level and then have the main content (large anounts of text) stored in .txt files. Here's an example with table feilds in ():

    Location (location_id, location_name)
    > Name (name_id, location_id, name_name)
    >> Hobby (hobby_id, name_id, location_id, hobby_name, text_file)

    What is contained in the text file is a description of the hobby, stories, ect in plain text, but for the name and location it is just normally one to three words. There is not always a name for the hobby so I am including the location_id in the hobby table (if you were wondering). The database will be searched and I will have pages origanizing the data by Location>Name>Hobby, Name>Hobby, Name>Location>Hobby.

    This is a school project (which is why it sounds kind of off the wall) but any and all help is appreciated.

    Is there any problems in my logic or any other better way of going about my problem?

    Is there any documentation on creating/editing/saving/deleting/etc .txt files through PHP?

  2. #2
    SitePoint Enthusiast Redprince's Avatar
    Join Date
    May 2004
    Salzgitter, Lower Saxony, Germany
    0 Post(s)
    0 Thread(s)
    Couldnīt find any problems in your logic. Help on working with files in the manual.
    I am not part of the allesburner. I am the allesburner.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts