Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorials - Storage Engines: MyISAM, InnoDB and BDB

By: FYIcenter.com

A collection of 15 tutorial tips on MySQL storage engines. Clear explanations and tutorial exercises are provided on creating tables with MyISAM, InnoDB, and BDB storage engines; checking data files of different storage engines; using MEMORY storage engine for temporary tables. Topics included in this collections:

  1. What Are Storage Engines?
  2. How To Create a New Table Using MyISAM Storage Engine?
  3. Where Table Data Is Stored by the MyISAM Storage Engine?
  4. How To Backup Tables by Copying MyISAM Table Files?
  5. How To Restore Tables by Copying MyISAM Table Files?
  6. How To Check and Repair MyISAM Tables?
  7. How To Create a New Table Using the InnoDB Storage Engine?
  8. Where Table Data Is Stored by the InnoDB Storage Engine?
  9. How To Create a New Table Using the BDB Storage Engine?
  10. How To Start mysqld to Support the BDB Storage Engine?
  11. Where Table Data Is Stored by the BDB Storage Engine?
  12. How To Create a New Table Using the CSV Storage Engine?
  13. How To Create a New Table Using the MEMORY Storage Engine?
  14. What Happens to MEMORY Tables When MySQL Server Is Stopped?
  15. How To See Which Storage Engines Are Supported in Your MySQL Server?

Please note that all answers and tutorials are based on MySQL 5.0. Sometimes you may need to run previous tutorials in order to continue a later tutorial.

(Continued on next topic...)

MySQL Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...