www.webdeveloper.com
Results 1 to 2 of 2

Thread: Is there an alternative

  1. #1
    Join Date
    Jul 2006
    Posts
    655

    Is there an alternative

    Hi, i have a script that runs once a month on my site which updates our database with GEO co-ordinates. This dump contains 100K rows of data.

    This all worked fine on my development server, however i have just found out that my hosting company not support LOAD DATA INFILE on their cloud databases for security reasons.

    Does anyone know if there is an alternative way to do this update as inserting the data normally, without LOAD DATA INFILE, takes about 5 minutes.

    Thanks in advance for your help...

  2. #2
    Join Date
    May 2004
    Location
    chennai, tamil nadu, India
    Posts
    448
    Maybe a cron job which does it on a regular basis ?
    Chris, Senior Developer,
    Php laravel developers,
    www.chrisranjana.com

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles