Database Tables

Back

Administration

---

From admin go to Tools → Database Tables to see this:

• This shows a list of the tables in your database.
• Do not make any changes here unless you know better!
• See phpMyAdmin

At the very bottom of the page, you will find a dropdown-menu with some maintenance actions you can preform on any tables selected with the checkboxes.

<img database_tables_1_find_maintenance />

-Hint! Don’t check more than a few, especially if your database is loaded with a lot of data, as the actions might take a while!

Check Tables works with InnoDB, MyISAM, ARCHIVE and CS. It checks the selected tables for errors, and will output information of errors and warnings. It does not change or fix anything. The desired result is “Status OK”, meaning that there are nothing else to do. If you are on InnoDB, you should read the following notes: https://dev.mysql.com/doc/refman/8.0/en/check-table.html#check-table-innodb check-table.html#check-table-innodb

<img database_tables_2_check_tables> Example of a preformed action </img>

Analyze Tables works with InnoDB, NDB and MyIsam. It analyzes the selected tables and stores the analysis in order to optimize the execution of queries with join-statements. Note, that while the analyze is on-going, the tables are locked for any other operation. The analyze is quick, so it will often not be a problem, but it is important to keep in mind with huge amounts of data. The desired result is “Status OK”, as any other messages means that something is wrong and the action was not preformed.

Optimize Tables works with InnoDB, My-ISAM and ARCHIVE, but is less needed for InnoDB than for the other two, due to the way InnoDB stores data. It re-organizes the physical storage of data, which reduces the storage space needed and the speed of gathering data – much like defragmentation on a Windows PC. It is advised to optimize tables after large changes to them; a large change is either a lot of affected rows, or a lot of affected text. The desired result is “Status OK”, as any other messages means that something is wrong and the action was not preformed.

<img database_tables_3_optimize_tables> Example of an action not preformed </img>

Repair Tables works with MyISAM, ARCHIVE and CSV. It is the big red emergency-button, and you must make sure to have a backup of your data before pressing it. You should also try out everything else you can think of, before going here, as it may result in a complete loss of data. However, it is very likely to get back all data, especially from a MyISAM table, should it have become corrupted. The desired result is “Status OK”, as any other messages means that something is wrong and the action was not preformed.

Convert To UTF-8 does what it says: It converts the encoding of the data into UTF-8, which is recommended, as it supports encoding of special characters. Note, that MySQL might change the size of the input-types, in order to prevent data being truncated. As always remember to back-up your data before making changes!

---

This page is in progress
Please visit again soon for additions and changes

Phoenix Cart User Guide, like CE Phoenix Cart, is free to use but is maintained by unpaid volunteers.

Code references are licensed under a Commons Attribution-NonCommercial-ShareAlike 2.0 UK: England & Wales License.
All other content is the reserved Intellectual Property and Copyright of phoenixcart.org