Tender documents for pre-qualified contractors bidding to be a Project Delivery Partner (PDP) for the new LRT Line 3 (LRT3) are ready for collection.
Prasarana Malaysia Bhd is the project owner
Part of software testing at times we need mock database which can be easily obtained from production database using a simple
However, the import of the mysql dump into our local mysql server could painstakingly slow especially when the import file is large.
If the tables are of InnoDB, we can speed up the import like Speedy gonzales by wrapping the dump with the following SQL statements :)
SET autocommit=0; ... SQL import statements ... COMMIT;
Time to make your harddisk work harder! Read more at MySQL reference manual.