Jump to content


Photo

importing data - via phpMyAdmin


  • Please log in to reply
1 reply to this topic

#1 phil speakman

phil speakman
  • New Members
  • Pip
  • Newbie
  • 1 posts
  • Locationliverpool

Posted 27 October 2003 - 10:49 AM

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
take it easy

#2 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 27 October 2003 - 10:58 AM

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
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users