UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support How do I check optimization

Is here a command to see if the DB is well optimized?

Yes.
mysqlcheck threadsdatabase -o will optimize the tables.

I get this error messages with that

Script: /homepages/1/d118328893/htdocs/clubadventist/adventist/admin/dodbcommand.php
Line#: 107
SQL Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqlcheck threadsdatabase' at line 1
SQL Error #: 1064
Query: mysqlcheck threadsdatabase

Best to optimize or repair via shell.

Um no. Look at what was run:

SQL Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqlcheck threadsdatabase' at line 1

Best to replace the word threadsdatabase with the actual name of your threads database.

Additionally, i think the option (-o) goes before the database name.

> mysqlcheck -o your-database-name-here

<img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />

Doesn't matter where you put the -o.

OK I used db122662337 this and got this
[]

SQL Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqlcheck db122662337 -o' at line 1
SQL Error #: 1064
Query: mysqlcheck db122662337 -o [/]

I also used w3t_db122662337

It should be noted, since nobody has noted it yet, this command is meant to be run from the command line, not from within .threads <img src="https://www.ubbcentral.com/boards/images/graemlins/wink.gif" alt="" />