Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Unanswered: MySQL script and cvs file

    Hi,

    I want to create a script that will import a cvs file into a mysql database, I wanted to this autmatically.

    Does anyone has a sample script or good sites where I could find these scripts.

    Thanks in advance,

    Avanti

  2. #2
    Join Date
    Nov 2003
    Posts
    2

    Addon

    Hi,

    I forgot to mention my operating systeem.

    I'm using:

    FreeBSD 4.9
    Apache (webserver)
    PHP
    IMAP
    Sendmail
    HORDE/IMP

  3. #3
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    You can create a simple sql file that use load data to import your file
    And just run this script in a cron job

    If you need to know how to use load data
    see

    http://www.lasso-developpeur.net/us/...tab=db&lang=us
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  4. #4
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: Addon

    Originally posted by avanti
    Hi,

    I forgot to mention my operating systeem.

    I'm using:

    FreeBSD 4.9
    Apache (webserver)
    PHP
    IMAP
    Sendmail
    HORDE/IMP
    You also could use the plain text or csv files and import by LOAD DATA INFILE

Posting Permissions

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