SitePoint Sponsor

User Tag List

Results 1 to 11 of 11
  1. #1
    Fluffy Kitten Programmer~ Elledan's Avatar
    Join Date
    Jun 2000
    Location
    Netherlands
    Posts
    1,356
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The title says it all...

    Please note that I'm talking about huge text files: multiple A4 pages.
    www.nyanko.ws - My web-, software- and game development company.
    www.mayaposch.com - My personal site and blog.

  2. #2
    SitePoint Wizard creole's Avatar
    Join Date
    Oct 2000
    Location
    Nashvegas Baby!
    Posts
    7,845
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Elledan, while I am not a pro at all, I installed a PHP,Apache,mySQL bundle that gave me a tool called phpMyAdmin. It is basically a web interface to mySQL databases. It is very powerful and offers the ability to import text files. You might want to check it out.

    here is the homepage for phpMyAdmin
    Adobe Certified Coldfusion MX 7 Developer
    Adobe Certified Advanced Coldfusion MX Developer
    My Blog (new) | My Family | My Freelance | My Recipes

  3. #3
    SitePoint Enthusiast
    Join Date
    Oct 2000
    Location
    Location:
    Posts
    94
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    I have a similar situation to Elledan, my website will mainly consist of a databse and I need to input large amounts of data into it....with as much ease as possible!!

    Cerole, is the webserver an important factor when using PhPMyAdmin?

    In my case I'm going to use a sambar server (at http://www.sambar.com/). Also importantly I plan to set up this server from my home PC.

    Given the senario, is PhPMyAdmin still a good option?



    Thanx,



    K.

  4. #4
    SitePoint Wizard creole's Avatar
    Join Date
    Oct 2000
    Location
    Nashvegas Baby!
    Posts
    7,845
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I don't know enough about it to know if the server makes difference. I *think* that it simply interfaces with the mySQL database. Given that information, it would be logical to assume that it does not matter what server is used...

    please correct me if I am wrong....
    Adobe Certified Coldfusion MX 7 Developer
    Adobe Certified Advanced Coldfusion MX Developer
    My Blog (new) | My Family | My Freelance | My Recipes

  5. #5
    Fluffy Kitten Programmer~ Elledan's Avatar
    Join Date
    Jun 2000
    Location
    Netherlands
    Posts
    1,356
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for you reply, creole

    Sorry for being so late, but it doesn't happen everyday that the power suplly blows and you're cut off from the internet for a week

    I'll try the import function of PHPMyAdmin, let's hope it works
    www.nyanko.ws - My web-, software- and game development company.
    www.mayaposch.com - My personal site and blog.

  6. #6
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    phpMyAdmin will work just fine on Sambar Server; however, if you'll be regularly inserting large text files into your database, your best bet would probably be to code a simple administration page in PHP that lets you upload the text file directly. The script would then read the data from the text file and insert it into the database.
    Kevin Yank
    CTO, sitepoint.com
    I wrote: Simply JavaScript | BYO PHP/MySQL | Tech Times | Editize
    Baby’s got back—a hard back, that is: The Ultimate CSS Reference

  7. #7
    SitePoint Zealot trigger8's Avatar
    Join Date
    Nov 2000
    Location
    Dallas, TX
    Posts
    133
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm trying to inport about 4000 text files into MySQL database. Do I need to insert them one by one, or there's an easier and faster way to accomplish that?
    Trigger8

    **************************
    I killed a 6-pack just to watch it die!

  8. #8
    Fluffy Kitten Programmer~ Elledan's Avatar
    Join Date
    Jun 2000
    Location
    Netherlands
    Posts
    1,356
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm curious about that too, trigger8

    So... Anyone?
    www.nyanko.ws - My web-, software- and game development company.
    www.mayaposch.com - My personal site and blog.

  9. #9
    SitePoint Enthusiast
    Join Date
    Mar 2000
    Posts
    32
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    4000 text files. I assume the text files are in some directory structure and are named.

    Do you wish to linked the files in the database or actually inserting the text file CONTENT into the database?.

    Either way, a simple solution it to write some script/program that does this automatically (java, C++).

    first is to get a listing of all the files. can be done 2 ways. Use the language API to list all the files with in the program and then pull out the contents and push them into the mysql database (use the mysql API).

    Or the simpler but messy way. is to use the command/console to do a directory listing and save it to a file. then generate mysql QUERY from the filenames.

    confusing? I don't have the time at the moment. But someone might understand and help. I can take a look at it, but no time to program, sorry.



  10. #10
    SitePoint Zealot trigger8's Avatar
    Join Date
    Nov 2000
    Location
    Dallas, TX
    Posts
    133
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The content of the text files includes the title, and the article, in plain text. The file names, which are a series of numbers, will be used as the article's ID. For example, one of the file names is 63723.txt

    I would appreciate if anyone could help.

    Thanks.
    Trigger8

    **************************
    I killed a 6-pack just to watch it die!

  11. #11
    SitePoint Enthusiast
    Join Date
    Mar 2000
    Posts
    32
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Send me a few examples and I'll see what I can do. I have a bit of time in a few days time.


Bookmarks

Posting Permissions

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