Populating MySQL table with text file using myPHPadmin

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I'm somewhat new to this whole MySQL/PHP thing and need a little help.

My web hosting service uses phpMyAdmin and at the bottom of the screen
iis an area where I can upload a text file to populate a table.

I have a table named groups with two fields:
    groups_id    auto-increment primary

So how do I create my text file to populate this table?

I'm going to use MS Notepad.

If it's set to auto-increment, do I need to include the number?  If
so, does it start at 0 (zero)?

Would the file look like:

2, staff

or just


(though I can't image that working).

Any help is appreciated.



Re: Populating MySQL table with text file using myPHPadmin

The format of that file must be in the same format as is written out by the  
EXPORT function. Put some data into a table, do an export, then see what it  
looks like.

The idea behind this is so that you can export data from one database and  
import into another using the same file. I do it all the time. so I know it  

Tony Marston


Quoted text here. Click to load it

Site Timeline