PDA

View Full Version : Upload & import a db?


bdunning
1-23-04, 12:13 PM
Can anyone please give me a vague general clue on how to go about uploading a csv and importing it into MySQL? I understand we no longer have remote access which REALLY STINKS!!!!

I can ftp my csv up there, and I have my schema ready in MySQL, but I don't have any idea how to go about the actual import. Any guidance much appreciated. :)

B&T
1-23-04, 08:59 PM
Use phpMyAdmin. Powweb has a "community version" here:

https://phpmyadmin.powweb.com/

mitchind
1-24-04, 06:47 PM
From phpmyadmin select your table and then choose the SQL tab. At the bottom you'll have to click the Insert data from a textfile into table option, and then you can choose from a variety of options.