MySQL from Access DB

[Denis7Kom]

VibeShop Access → MySQL migration report

Row counts
Artista: 26
Utente: 7
Prodotto: 29
Concerto: 7
Ordine: 11
Dettaglio_ordine: 21

Important notes
Attachment/OLE data from Access fields foto/immagine was not exported as binary files; columns are created as VARCHAR placeholders and values are NULL.
Access calculated/query objects such as Q_PrezzoTot and forms/macros were not migrated; only relational tables and data were migrated.
Utente.aministratore and Prodotto.stock are Boolean Access fields; binary extraction cannot guarantee all bit values. Values are normalized for web-project use.
Passwords are copied as plaintext because the Access database stores them that way. For the TSW checklist they must be hashed before final submission.
Column name @gmail was normalized to gmail because @ is inconvenient in Java/JDBC identifiers.
A missing/deleted product reference in Dettaglio_ordine was set to NULL while preserving prezzo_tot and quantities to keep MySQL foreign keys valid.

Import

mysql -u root -p < full\_migration.sql

[Denis7Kom]

vibeshop_mysql_migration.zip

[Denis7Kom]

STAGE 1

[Denis7Kom]

https://dev.mysql.com/downloads/installer/

[Denis7Kom]

Configure MySQL Server as a Windows Service
Start the MySQL Server at System Startup

[Denis7Kom]

MySQL80

[Denis7Kom]

VibeShopRoot2026!

[Denis7Kom]

CREATE USER IF NOT EXISTS 'vibeshop_app'@'localhost'
IDENTIFIED BY 'VibeShopApp2026!';

GRANT SELECT, INSERT, UPDATE, DELETE
ON vibeshop.*
TO 'vibeshop_app'@'localhost';

FLUSH PRIVILEGES;

[Denis7Kom]

VibeShopApp2026!

[Denis7Kom]

vibeshop_stage2_rebuild_from_backup.zip

STAGE 2. Alcuni parti in russo.

[Denis7Kom]

mysql-connector-j-9.7.0.zip

mysql-connector for DataSourceProvider

[Denis7Kom]

README_DAO.md