Results 1 to 5 of 5
  1. #1

    Filling up fast mysql with data


    I have an admin panel where I have to input all the towns, departments and more one by one, it is taking me so much time.

    I would like to know if any of you have a quick way or know an online software that would convert all my data which has 1 word per line into a mysql insert format.

    Thank you,


  2. #2
    Join Date
    May 2012

  3. #3
    Join Date
    Oct 2013
    Hi Ben

    If you can post an example of how the data is structured, I'd have a go at a script to help. You say one word per line but that doesn't really describe it to me, do you have a sample you can post?


  4. #4
    Join Date
    Oct 2013
    Also before I forget, I'd also need to know the mysql table structure. What's the table name and what columns does it have?

  5. #5

    Re: Filling up fast mysql with data

    Just creare a csv file with all data you want to import, and create a php script to read a row at a time. Php script script should loop through each lines. I guess there will be available script, you just have to customize to match with your table structure.
    The coder.

Similar Threads

  1. rootfs and /dev/root Space is Filling Up Fast
    By NerdsHosted in forum Hosting Security and Technology
    Replies: 12
    Last Post: 09-05-2013, 10:44 PM
  2. Replies: 11
    Last Post: 07-15-2010, 03:16 AM
  3. I need a PHP / MySQL coder FAST FAST FAST!!!
    By Hostex Australia in forum Employment / Job Offers
    Replies: 3
    Last Post: 02-14-2006, 10:02 AM
  4. filling a combobox with data from MySQL in visual c#
    By Pablasso in forum Programming Discussion
    Replies: 4
    Last Post: 02-08-2005, 04:26 PM
  5. Disk filling up fast
    By RandChar in forum Hosting Security and Technology
    Replies: 8
    Last Post: 03-10-2004, 04:01 PM

Posting Permissions

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