Defrag mysql possible?

[TKO]

hey i wanna know if it's possibel to defrag your mysql to optimice it?

 

[Cykotitan]

optimizing tables should be enough ;s

 

[Gut]

mysqlcheck -o -u MYSQLUSERNAME -pMYSQLPASSWORD DATABASENAME;

 

[TKO]

is that a sql command? or where do i do that?

 

[Gut]

mysqlcheck is a binary. Are you using linux?

 

[TKO]

nope im using windows like all noobs

 

[TKO]

bump?

 

[Doggynub]

defrag?

 

[TKO]

optimizing it then..

 

[rockseller]

mysqlcheck -o -u MYSQLUSERNAME -pMYSQLPASSWORD DATABASENAME;

Clic on Start - RUN
Type CMD, then hit Return.

Once in console, type:
cd C:\xampp\mysql\bin\
(check if the paths are correct, in case you are not using MySQL from xampp or i typed it wrong)

now type mysqlcheck -o -uMYSQLUSERNAME -pMYSQLPASSWORD DATABASENAME

exactly as that
example:

-o -uROOT -pPASS1 OTSERV

 

[TKO]

when i did it said like this:

note : Table does not support optimize, doing recreate + analyze instead
status : OK