Jump to content


This topic is now archived and is closed to further replies.

phil speakman

importing data - via phpMyAdmin

Recommended Posts

Is there any easy way of importing quite alot of data into a mySql database using myPhpAdmin - as it appears i have to type it all in, and i really hope i don\'t have to..


Share this post

Link to post
Share on other sites

If you are using windows you can get yourself SQLYOG a GUI based toolw hich can help you a lot.


See this




But this tool isnt a freeware.




To import data


Go to the structure TAB


click on Insert data from a textfile into table


choose whihcever is appopriate.


If you are using CSV (comma separted values)


Fields terminated will be : ,

Fields enclosed by: \" (if applicable(

Lines terminated by: n

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.