import text file

to all of the mysql experts here ...

I need a simple command that I can use to load my .txt file in to my data base through phpMyAdmin. I know this is elementary stuff, but I want to be sure I'm doing the right thing.

Please?

Thanks in advance!

Hello!

If this .txt. file contains only SQL commands then you can just use import service in phpMyAdmin (import->choose file->OK button).

Regard

the .txt file contains data, like UserName, City, State, Zip, etc.

Please help!

phpMyAdmin (import->choose file->OK button).

you can choose file with ANY format (just check that here correct SQL instructions in text format)

Andrey, would you kindly elaborate?

I did use the import function and imported successfully. However, the password was exactly as I had created it, not encoded like all the other passwords.

Then, when I tried to log in with this new profile info, it gave error: Profile error.

Thanks in advance!

Why not say what you are wanting to do, and you would get more specific answers.

Like it seems to me that you are wanting to import profiles, or user accounts of some sort.

The reason I say this, is because your next post are going to be, how do I get pictures to show for my profiles etc, and this will be another task as the correct media dir were not created, etc.

CyberXing

If you imported your profiles with non-md5 passwords, so yes, you should execute MD5 at your field values.

For this you can execute SQL:

UPDATE `Profiles` SET `Password`=MD5(`Password`)

this must change all your non-md5 passwords to md5 ;)