MySQL Schema
Generate a MySQL schema file that can be used to create the required database tables.
Migrate to MySQL Database
Migrate all your data to a MySQL database for larger installations.
Warning: Make sure the database exists and is empty before proceeding.
Using MySQL with the Application
After migration, you'll need to configure the application to use MySQL instead of JSON files.
1. Create a config.php file in the root directory with database credentials:
<?php
define('USE_DATABASE', true);
define('DB_HOST', 'localhost');
define('DB_NAME', 'your_database_name');
define('DB_USER', 'your_username');
define('DB_PASS', 'your_password');
?>
2. After creating this file, the system will automatically use MySQL instead of JSON files.
