The MySQL database structure is thoughtfully designed. Each database is a directory (accessible only to the MySQL daemon), and the tables and their related indexes,
etc are stored in separate disk files. This creates a disk structure quite different from the MS-Access ".MDB file," and much more conducive to repair.
A client-server database is inherently more robust than filesever-based systems like Paradox or MS-Access, as long as you carefully observe four things:
- Make sure that it has a good, strong UPS (Uninterruptible Power Supply) box. (Network hardware and such should also have similar equipment.)
- Make sure to use RAID arrays, to guard against failure.
- Make sure to back up the database diligently, and test for actual recovery ability.
- Set up logins and permissions on the database server box correctly.