Special Content

Get rid of this Strict Standards warning WooCommerce: get_current_screen not working with multi language Can’t login on WordPress Force HTTPS using .htaccess – stuck in redirect loop WordPress: Ajax not working to insert, query and result data

Home Science, Programming and Technology WordPress How to stop google cloud sql from corrupting database tables

How to stop google cloud sql from corrupting database tables

March 22, 20231 Views

placeholder

Today I noticed my wordpress website one GAE-php has no more posts and the logs claim

WordPress database error Table ‘./dbname/wp_posts’ is marked as crashed and should be repaired
Read More
Get rid of this Strict Standards warning
WooCommerce: get_current_screen not working with multi language
Can’t login on WordPress

Some time before that I saw errors in log relating to “duplicate keys”, but I can’t seem to be able to find exact errors now through log viewer.

Why are this errors occurring on Google Cloud SQL,
how can I stop them from happening and,
is there another option to store this data in a way that will not corrupt tables?

Post Views: 1

Leave a Reply Cancel reply

You must be logged in to post a comment.

1 comment

Anonymous says:

March 22, 2023 at 6:40 am

.MYI files indicate to me that you’re using MyISAM. Cloud SQL strongly recommends you use InnoDB. Try changing your tables to use InnoDB instead, which the previous link also describes how to do.

Log in to Reply