Page 1 of 1

data from txt files to mysql database

Posted: Sat May 20, 2006 5:37 pm
by alxkn
Hello,

I have data in excel and txt files. I want to put those data in mysql database. I know that I can create an appropriate table in a database and use insert command. However, there are a lot of rows, so this method is time consuming. Could you please let me know if there is a way to ask database to fill table rows from files?

Thank you in advance.

Posted: Sat May 20, 2006 6:15 pm
by RobertGonzalez
phpMyAdmin can do it. It can import from Excel format as well as text file (CSV, Tab-delimited, etc).

Posted: Sat May 20, 2006 9:54 pm
by alxkn
Thanks. actually I wanted to develop the project locally, before putting it in server. Is there a way using phpmyadmin locally?

Posted: Sat May 20, 2006 10:00 pm
by RobertGonzalez
Absolutely. Download it and unzip it to a folder within your local server. This assumes that you have a local web server installed on your system. If not, you will need one as phpMyAdmin is a PHP application (which requires a web server).

Posted: Sun May 21, 2006 1:09 pm
by alxkn
Thanks again. I have php5, apache 2 and mysql5 installed in my computer. I am dowloading now phpmyadmin 2.8.1. You wrote "unzip it to a folder within your local server". What does that exactly mean. Should I put it in a specific folder in apache directories?

Thanks in advance.

Posted: Sun May 21, 2006 4:11 pm
by RobertGonzalez
There is a path in your system that is the root of your server. On windows it is something like c:\Program Files\Apache Group\Apache\htdocs. Unzip PMA to that folder and follow their readme instructions on how to get it to run. Post back if you have any problems.