Dismiss Notice
Welcome to Our Community
Wanting to join the rest of our members? Feel free to sign up today.

Tip : mysql table maintenance commands

Discussion in 'Programming' started by dman_2007, Apr 12, 2008.

  1. dman_2007

    dman_2007 Guest

    Following commands can be used for table maintenance using the mysql command line:

    1) check table table_name

    This command is used to run a check on the specified table to see if it has errors. It works on MyISAM, InnoDB and ARCHIVE tables.

    2) repair table table_name

    Repair table command can be used for repairing a corrupted table. It can be used for MyISAM and ARCHIVE tables. To execute this command the user must have SELECT and INSERT privileges for the table specified in the command.

    3) optimize table table_name

    This table is used for optimizing table after you have deleted lots of rows in a table or have made a lot of changes in a table with plenty of variable length field (such as varchar, blob, etc). It defragments the data file and reclaims unused space.
  2. alena123

    alena123 New Member Webmaster

    Thanks for ur nice tips........
  3. charlie123

    charlie123 Guest

    thanks helpful for all.

Featured Resources (View All)

Share This Page