I have a small home-based website where clients email form information to me that I manually input into the database and upload. I've rebuilt my site and plan on having the database reside on my web host's server so clients will have some control, and I can input from an admin section. This will be my first time having a database reside on the server and I have concerns regarding compact/repair and corruption. I've been researching these issues which only escalates my concerns.
So that I understand, if my database is set to compact and repair on close (locally), will it compact and repair remotely? I was told by one of my host's tech support guys "yes". If this isn't so, will I need to run a script to check, close, compact/repair? Can the script be automated? Do I risk losing data?
What causes corruption and how will I know if this happens? The only activities that will be allowed by clients are adding and updating records which are structured very simplistically (dropdowns, small fields, etc).
Any advice is much appreciated. The whole idea is to make my work easier, but the process has been laborious and exhausting!