MySQL import question
November 2, 2006 3:15 PM Subscribe
What is the easiest way to get this data into a MySQL database?
posted by rlef98 to technology (19 answers total) 1 user marked this as a favorite
I've got dated formatted in a text document as such follows...
Name: Joe Smith
Address: 1000 Smith Drive
Name: Jane Jones
Address: 1000 Jones Drive
etc, etc for about 60 items.
What is the easiest way to get this into a MySQL database without the use of PHPMyAdmin and without typing it in manually? I'm looking to avoid a crazy parsing script but I can write one if need be.
Is there a way to get it into MS Access and then exported as a .csv and then imported over in MySQL?
I've got shell access to the MySQL db.