Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

help me to upload data into mysql from a text file

achilles526achilles526 Member Posts: 1
hi all,

I'm having problems in uploading data from a text file into mysql which is in the same computer. The main problem is that i'm not able to use the 'load infile' command as there is no delimiters in the text file to seperate two fields.One field is just followed by another field with out any space or delemiters. This text file is automatically created backup file from a software, so i cant introduce any delimiters into it while creation of the file.

is there any solution for this???

looking forward for your help

Comments

  • dededede Member Posts: 145
    Maybe you can try MySQL Administrator (A free GUI app for MySQL) or/and PHP MyAdministrator, they can create back ups and restore databases from *.sql , *.txt files.
    dede:-)

  • mike8mike8 Member Posts: 4
    Hi,

    This task is very easy with the mysql turbo manager, I suggest to check this product or other MySQL GUI's.


    Regards,
    Mike
  • alexzanalexzan Member Posts: 1
    MySQL Maestro is a powerful Windows GUI solution for MySQL server administration and database development (http://www.sqlmaestro.com). It would surely help you. Besides, it has 30 days trial period, that you would have time to do everything you need. Using MySQL Maestro work with database becomes easy as abc.
Sign In or Register to comment.