Can I create a dynamic MySQL database from a .CSV?

Question

I created a MySQL database using phpmyadmin and imported my data from a csv file. The only problem is that I want to be able to update the csv, and automatically have the MySQL database update along with it. How can I do this?

Answer 1

It seems like the best thing to do would be to work directly from the database and not the CSV file.



But, if you must, simply put the CSV file in a location accessible to the MySQL server and just import it on a regular basis using a scheduled task (or Cron job). You would probably want to delete everything in the tables first before importing them so you don't get duplicates.

Answer 2

What a waste of a good database. Once you import data you are better to use strictly mysql.

Answer 3

You can not have changes done automatically to database by just updating a .csv file.



You need to import it every time whenever you make any changes.

Answer 4

I guess you could have a script run to re-import the CSV file either on demand or on a timer.

Answer 5

The only way to do that is to truncate the table and then re import the csv into the table.



there is no automatic way to do that.