I am tearing my hair out on this one. I have a domain hosted by Telus (in Canada), and I've created a database with 4 tables in it on the server. I need to upload some data onto one of the table. The data is currently in an Excel spreadsheet. But I can generate a tab-delimited file or something similar.
Telus said that I should use something like PHPMyAdmin. I tried, and configured it to connect to the host, user etc. Telus provides a user name for me which is something like "dbm.abcassociation.org". I can use this succussfully on their database manager but when I tried PHPMyAdmin, it returns an error saying that it cannot connect to user and gives a user name that looks like email@example.com.
In case you are thinking - I have asked Telus, and they said that it's a PHPMyAdmin problem and don't want to help. Another question you may ask is why I didn't use Telus' database manager. Well, their "manager" only provides a certain number of queries. LOAD is not one of them. So I have to use something else.
Do you know what I may have done wrong??
Thanks, again - Petre.