Re: Reorganize MySQL Database

To defrag a table of a certain type, you can issue:

alter table <tablename> engine="<engine>"

For example, if Users table is of type InnoDB, you can issue:

alter table Users engine="InnoDB"

You can issue such statements for all of your tables in your database.

HTH,
Gokhan Demir



Stasa Jerinic wrote:
> Hallo,
> 
> is there way to reorganize (defrug) a mysql database or is the only way
> to make a backup and to destroy the database and after that to restore
> again the database.
> 
> Greetings,
> Stasa Jerinic
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> - - - - - - - -
> dato Denkwerkzeuge :: Corneliusgasse 4 :: A-1060 Wien
> T +43 (0)1 581 29 70 :: F +43 (0)1 581 29 80
> [email protected]
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> - - - - - - - -
> www.dato.at
> www.nutritional-software.com
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> - - - - - - - -
> 
> 

-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]