Posted on October 15, 2008 by just2bruce
You can do more than just read (SELECT) data using Excel in conjunction with MySQL. Here’s how.
First of course, you have to install the mysqlODBC 5.1 driver. Then you use Control Panel | Administrative tools | Data Sources to create the data source for your data. This step is where you put in how to [...]
Filed under: Database Internals | Leave a Comment »
Posted on October 7, 2008 by just2bruce
Here is a reference to MySQL support for transaction processing. In
multi-user working systems this is the way it should be done, to make
sure the DBMS can preserve the integrity of the data even if crashes
and transaction failures occur.
MySQL :: MySQL 5.0 Reference Manual :: 12.4 MySQL Transactional and Locking Statements
Note the START TRANSACTION and END [...]
Filed under: Database Internals, Information | Leave a Comment »
Posted on September 9, 2008 by just2bruce
Backup MySQL,MySQL Backup,Backing Up and Restoring A MySQL DatabaseA tutorial
Backing Up and Restoring Your MySQL DatabaseAnother short article with several added pages.
Filed under: Database Internals | Leave a Comment »
Posted on September 9, 2008 by just2bruce
Usability Report Table Logs – MySQL Forge Wiki
Filed under: Database Internals | Leave a Comment »
Posted on August 24, 2008 by just2bruce
Multiversion concurrency control – Wikipedia, the free encyclopedia
Filed under: Database Internals | Leave a Comment »
Posted on August 24, 2008 by just2bruce
MySQL :: MySQL Storage Engine Architecture, Part 2: An In-Depth Look
Filed under: Database Internals | Leave a Comment »