chesty wrote:
so first off
mysqlcheck -Ac --auto-repair
mysqlcheck -Aa --auto-repair
mysqlcheck -Ao --auto-repair
for the above three commands, you might need to add -u root -p
Okay I did this, it said it found errors in two of my databases and it says it repaired them. Now I believe WP-Autoblog was not the culprit. All my sites are serving except for 2 sites that I run a plugin called dsIDXPress (for real estate agents). Both of those sites are not serving and it was their 'options' table where all the errors were occurring.
Quote:
in my.cnf
max_connections = 20 # this should be higher than the max number of php processes
tmp_table_size = 32M
max_heap_table_size = 32M
table_cache = 512
log_slow_queries = /var/log/mysql/mysql-slow.log # this is for debian or ubuntu, centos might be different
long_query_time = 1
if the config option isn't specified, then add it under [mysqld]
I do not have a my.cnf file in my /etc folder, so do I just create a new one in nano and that has the values you gave me and then restart mysql? What do you mean "add it under mysqld?
Code:
service mysql retart
?
I wanted to try to deactivate this plugin from mysql query, but I think since I have 5 databases I have to tell it which one, I found this in another tutorial:
Code:
mysql> SELECT * FROM wp_options WHERE option_name = 'active_plugins';
I receive:
Code:
ERROR 1046 (3D000): No database selected
FAQ
Search
Members
Register
Login [ Anonymous ]
