MySQL Forums
Forum List  »  Newbie

Scheduled Data Import
Posted by: Should go Fishing
Date: August 28, 2016 02:25AM

Hello,

my name in Uwe and I live in the north of germany. About 2 decades ago I had my first tests with Access. So got a very little idea of sql. A lot of time passed and in this days I'm again working with "DATA".
Some days ago I did my first installation of mysql.
I was able to load some data from a file. By watching some tutorials I was also able to connect Libre Base to mysql and add data. So I did some homework.

What I'm not able to figure out was:
How can I set up "something" that imports the same data file (content of the file will change regularly in the rows - not in the columns) in a predefined time period.

Like:

every 120 minutes do the following,
delete tabe test from database xyz,
import data.csv from folder (path) to database xyz into table test

I searched for two days now, but was not able to find something that fits my skills.

The second question: Knowing the script for this task, where to put it, start/run it. How to see, that it is running. Will it start with starting the server?

Every help is welcome, that brings me a step forward.

(My goal is not to become a specialist in mysql ;-)

Uwe

Options: ReplyQuote


Subject
Written By
Posted
Scheduled Data Import
August 28, 2016 02:25AM
August 29, 2016 11:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.