Topic: Lost/empty Database

Hi,


This morning I have got the information that all data, entered in out application, are lost. After checking the Softwarefolder I have found a fresh and empty sqlite.db file.


After using our nightly backup everything was back.


Two questions about this:
1) Anybody else how has had a replaced database?
2) When I use one of the backup-scipts here at the forum for SQLite - are they working on a multi user application when users active working on it (only 2-3 users)?


Application is written with MyVisualDatabase 3.5. Changes on the software are not done in the past 3 months.


Thank you.

Re: Lost/empty Database

Hello.


Unfortunately I have no idea how could this happen. Database can be damaged, but in your case database was deleted, if database not exists, My Visual Database will create new empty database file.

Dmitry.

Re: Lost/empty Database

Hi Dmitry,


Thank you for your information.


Can I backup via script a SQLite Database when 1-2 other users are connected or does I need to switch to MySQL?


Thank you.

Re: Lost/empty Database

teco049 wrote:

Hi Dmitry,


Thank you for your information.


Can I backup via script a SQLite Database when 1-2 other users are connected or does I need to switch to MySQL?


Thank you.

Yes you can.

Dmitry.