Board index   FAQ   Search  
Register  Login
Board index php forum :: Database phpMyAdmin

Importing tab delimited files into MySQL

How to use phpmyadmin.... phpmyadmin related arguments. Even phpMyAdmin issues

Moderators: macek, egami, gesf

Importing tab delimited files into MySQL

Postby xgab » Fri Sep 26, 2003 1:26 pm

Hi!
I do not understand the phpMyadmin interface to import data into MySQL.

Please, could anyone tell me step by step what to do ?

I have to import 5 tables. One of them has about 250,000 records, will phpMyAdmin do the job ?

Thank you in advance.
xgab
New php-forum User
New php-forum User
 
Posts: 13
Joined: Tue Jan 28, 2003 4:22 am

Postby Redcircle » Fri Sep 26, 2003 8:27 pm

Use a tab or ; deliminated text file to seperate the fields. As long as your max upload file is larger than the text file you are trying to import.

About the largest file that I've imported is 60,000 records but it should handle 250,000 just fine.. it will just take longer.
User avatar
Redcircle
Moderator
Moderator
 
Posts: 830
Joined: Tue Jan 21, 2003 10:42 pm
Location: Michigan USA

Postby Guest » Sat Sep 27, 2003 7:18 am

OK but how should I proceed within PHPmyAdmin to import de comma delimited file ?
Guest
 

Postby Redcircle » Sun Sep 28, 2003 10:41 pm

you have to create the database and the table. then you click on the sql from the table menu and select text file. It will then ask you some questions about the file that you are importing. Check out the phpmyadmin docs for more info on it.
User avatar
Redcircle
Moderator
Moderator
 
Posts: 830
Joined: Tue Jan 21, 2003 10:42 pm
Location: Michigan USA


Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 2 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.