Tabbed text files ==> mysql?

[PoorDoggie]

Is there any way of getting the details from a tabbed text database into a mysql database easilly?

Thanks
Tom

 

[dgaussin]

Sure you can. You'll have to use the LOAD DATA FILE command.
See http://dev.mysql.com/doc/mysql/en/load-data.html for reference.
It's the most easy way...

 

[PoorDoggie]

Sorry to bring this old thread up to the top, but I have a problem:

Access denied for user: '1112185271@%' (Using password: YES)

SQL: LOAD DATA INFILE 'feeds/****/CategoryMappings.txt' INTO TABLE pd_shopping_categories

why does this come up?

 

[MasterB]

Looks as if you have a permissions problem. Either your username/password is wrong, or you are not allowed to be doing whatever you are doing on that DB.

 

[PoorDoggie]

sorry for the late reply. Thanks for the help.

Is there no other way of getting the data from a tabbed text file to my mysql table? Maybe using fread() or something?