Page 1 of 1

Importing into phpMyAdmin

Posted: Fri Nov 03, 2006 7:45 am
by amir
I'm using phpMyAdmin - 2.8.0.3

I need to import a mailing list to my database. I can format however; it doesn't matter. CSV or TXT file. I can import it to start a new table or append an existing table; it doesn't matter.

I just need the format. Can't find instructions or documentation anywhere.

If this is too difficult, how hard would it be to write a php page that uses a comma delimited text file to import records?

This is a one time operation. Somebody please help.

Posted: Fri Nov 03, 2006 9:00 am
by jayshields
I don't understand your question.

Stab in the dark:
You need to find what format the file is in? You mention it's a one time operation, why not just open it with notepad and see?

Posted: Fri Nov 03, 2006 9:49 am
by GeXus
If you create a comma delimited or CSV file, you can then create a table in your DB and in phpmyadmin, there is the option to import.

Posted: Fri Nov 03, 2006 10:37 am
by RobertGonzalez
phpMyAdmin has a wonderful array of import/export tools available. And they work well. Make sure your table is built before trying to import. Also, make sure your CSV file has the correct number of the fields and that it is formatted properly (like handling address data that has a comma in the value).

Posted: Fri Nov 03, 2006 2:05 pm
by amir
Thanks All!