HLABOI MYSQL INSTALLATION

1. Log in to cPanel and open phpMyAdmin.
2. Select the database already used by this website. Do not create a different database unless you also update config/database.php.
3. Export a backup before changing anything.
4. Open the Import tab and import database_upgrade.sql.
5. If phpMyAdmin reports a missing image_file column, run:
   ALTER TABLE songs ADD COLUMN image_file VARCHAR(255) NULL;
   only if `songs.image_file` does not already exist.
6. If the users table has no mobile column, run:
   ALTER TABLE users ADD COLUMN mobile VARCHAR(20) NULL;
   only if `users.mobile` does not already exist.
7. In config/database.php, set the correct MySQL host, database name, username and password from cPanel > MySQL Databases. Do not share these credentials publicly.
8. The root .htaccess uses Apache mod_rewrite and HTTPS redirect. If your host reports an HTTP 500 error after uploading it, temporarily rename .htaccess to .htaccess.disabled and ask hosting support whether mod_rewrite/AllowOverride is enabled.

IMPORTANT: Do not import the original database.sql into a populated database; it may fail on duplicate tables/columns. Use database_upgrade.sql for an existing installation.

9. The upgrade SQL adds `settings.logo_path` when it is missing. The admin can then upload a logo at Admin Panel > Website Settings.
10. Ensure PHP can write to `uploads/site/`; uploaded files are limited to PNG, JPG and WebP, maximum 3 MB.
