Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Data Removed in MEMORY Tables

By: FYIcenter.com

(Continued from previous topic...)

What Happens to MEMORY Tables When MySQL Server Is Stopped?

If you have data rows stored in a table with the MEMORY storage engine, and the MySQL server has been shutdown by the DBA, all data rows will be removed. But the table structure will remain in the server.

The tutorial exercise below shows you a good example of using MEMORY tables:

>cd \mysql\bin\mysql -u dev -piyf fyi

mysql> INSERT INTO fyi_memory (id) VALUES (-1);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO fyi_memory (id, count) VALUES (-2, 987);
Query OK, 1 row affected (0.01 sec)

mysql> SELECT * FROM fyi_memory;
+----+-------+-------+
| id | title | count |
+----+-------+-------+
| -1 | NULL  |  NULL |
| -2 | NULL  |   987 |
+----+-------+-------+
2 rows in set (0.00 sec)

mysql> quit;

>\mysql\bin\mysqladmin -u root -pretneciyf shutdown

>\mysql\bin\mysqld-max

>\mysql\bin\mysql -u dev -piyf fyi

mysql> SELECT * FROM fyi_memory;
Empty set (0.00 sec)

(Continued on next topic...)

  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?

MySQL Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...