Importing into phpMyAdmin

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
amir
Forum Contributor
Posts: 287
Joined: Sat Oct 07, 2006 4:28 pm

Importing into phpMyAdmin

Post 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.
User avatar
jayshields
DevNet Resident
Posts: 1912
Joined: Mon Aug 22, 2005 12:11 pm
Location: Leeds/Manchester, England

Post 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?
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

Post 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.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post 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).
amir
Forum Contributor
Posts: 287
Joined: Sat Oct 07, 2006 4:28 pm

Post by amir »

Thanks All!
Post Reply