Happens with me too. It doesn’t delete the table, just breaks it (phpmyadmin doesn’t show a row count, and WP says I have no posts)
Thread Starter
puda
(@puda)
True sorry! The table is still there but showing a size of 00. Glad I am not the only one with this issue. Contacted the authors of the plugin and they asked me to post here so still waiting to hear back…
Hi,
Are you able to give any more details? What is leading you to identify WP-O as the culprit? What is being done at the time that the problem occurs? Any other info that might help?
David
Thread Starter
puda
(@puda)
Sure, always happening when I check the very first optimization (optimizing the tables). I can see that the plugin is running smoothly at first and then at some point it seems to delete all my posts and I can see the size of my database losing a good chunk of data. It has happened twice so far in the last 2 weeks. I have unchecked the first option and now only running option 2, 3 and 4 (drafts, revisions and comments)
The ‘optimize’ option just runs a single SQL OPTIMIZE command, which tells the MySQL server to optimize its tables. If that is causing you to lose data, then you have serious corruption in your database, and need to speak to your MySQL server administrator to get it repaired.
David
Thread Starter
puda
(@puda)
I will contact them, thanks!
Thread Starter
puda
(@puda)
After double checking, all my table + database look fine so maybe the host is blocking or crashing at some point causing wp-posts to empty itself. I haven’t been able to figure out the reason.
Hi,
all my table + database look fine
What was it in particular that you looked at, to discern this?
David
Thread Starter
puda
(@puda)
Ran a script in phpmyadmin.
I have actually uninstalled wp optimize and now directly optimizing my tables in Phpmyadmin. No issues so far.
Hi @puda,
Can I mark this issue as closed?
