Hello Members

I have query regarding mysql database.

1. Can we create mysql database in IOT2040?

   I found that it is possible.

2. mySql database can only be created (use memory) in USB disk or SD card possible?

3. After creating database in Iot2040 will same database can copy data to webserver?

point no. 3 is important for me because the area where internet connectivity is problem i mean to say frequent reconnect are there. will it store data in database locally on later on send it to remote database or webserver's database.

Thanks in advance

bergmanu

Hi, 

1. in order to add a mysql database to the IOT2040 it is required to build a customized image with mysql included.
   How this can be done is described here.
   
   
2. As storage you can use the µSD card where the image is running on or an USB flash drive, correct.
   
   
3. Of course you can read out the data from your database and send them to somewhere else. But this doesn't happend automatically, you need to program an application which writes the data to the database in case of missing internet connection and writes it then to remote when internet connection is back. 

    CAN YOU GIVE SAMPLE PROJECT FOR POINT NO. 3

Best regards!