Jump to content

Archived

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..

Phil

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

 

http://www.phpfreaks.com/sqlyog/

 

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.