CodeIgniter Database Utility atomicity and restore verification
The CodeIgniter Database Utility provides backup() and restore() methods to handle SQL dumps. However, the restore() method executes SQL statements sequentially without wrapping the process in a database transaction. When performing large-scale restorations, a failure mid-execution can leave the database in a partially restored state because there is no auto