Title: DB error Last modified: September 13, 2020 --- # DB error * [alsadr](https://wordpress.org/support/users/alsadr/) * (@alsadr) * [5 years, 9 months ago](https://wordpress.org/support/topic/db-error-30/) * I am not professional to fix this * any one can help .. please ,, * wp_users: 1 client is using or hasn’t closed the table properly wp_usermeta: 60 clients are using or haven’t closed the table properly wp_posts: 105 clients are using or haven’t closed the table properly wp_options: Table is marked as crashed wp_postmeta: 180 clients are using or haven’t closed the table properly wp_terms: 54 clients are using or haven’t closed the table properly wp_term_taxonomy: 69 clients are using or haven’t closed the table properly wp_term_relationships: 79 clients are using or haven’t closed the table properly * hope any one to help. thank you Viewing 7 replies - 1 through 7 (of 7 total) * [Ian Sackofwits](https://wordpress.org/support/users/plantprogrammer/) * (@plantprogrammer) * [5 years, 9 months ago](https://wordpress.org/support/topic/db-error-30/#post-13399303) * Hi, alsadr, I would suggest taking a look at this post on StackOverflow (you have a problem with your `wp_options` table): [https://stackoverflow.com/a/25757835/4372244](https://stackoverflow.com/a/25757835/4372244) * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [5 years, 9 months ago](https://wordpress.org/support/topic/db-error-30/#post-13399315) * Repair your database via PHPMYADMIN: [https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimizing-and-repairing-mysql-databases-with-phpmyadmin](https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimizing-and-repairing-mysql-databases-with-phpmyadmin) * Thread Starter [alsadr](https://wordpress.org/support/users/alsadr/) * (@alsadr) * [5 years, 9 months ago](https://wordpress.org/support/topic/db-error-30/#post-13409672) * I did all what is there .. but it is missing table .. so .. * for the corrupted DB 1- will get copy of old DB 2- recreat new site with the same details .. blank one and reinstall the same blugins as frish copy now we have new site without any article. then I will install the old DB (I copied before) to new DB. 3- mintion the origenal site folder on the site to the new DB so all config or theme and any other things will be there .. and even plugins will get the new setting from new DB. * this way ,, will succeed or if I copy the old DB will delete the new one ? it will marge or or replacement? * thank you * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [5 years, 9 months ago](https://wordpress.org/support/topic/db-error-30/#post-13409690) * If you’re importing via PHPMYADMIN, the usual operation is to drop and recreate the table from the new data, so it’s a replacement, not a merge. * Thread Starter [alsadr](https://wordpress.org/support/users/alsadr/) * (@alsadr) * [5 years, 9 months ago](https://wordpress.org/support/topic/db-error-30/#post-13409749) * so .. let me clear it .. the old DB is A the new is B if some table is deleted or missing from A . and I will install A to B … will the new DB A+B complete or it will be effected ? will be will get the missing table from A as A is new and complete .. ( I mean complete in plugin and so on) * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [5 years, 9 months ago](https://wordpress.org/support/topic/db-error-30/#post-13409767) * When you import your new database, any tables OF EXACTLY THE SAME NAME will replace tables already in the database. * Thread Starter [alsadr](https://wordpress.org/support/users/alsadr/) * (@alsadr) * [5 years, 9 months ago](https://wordpress.org/support/topic/db-error-30/#post-13409876) * ok … sorry for long explanation ,,, I will create new data base as the old one.. then will install the old one over the new one the old one will replace the new one and keep the table witch missing in the old one . at the same time any more tables on the old one will be as it is * is that correct .. ? * I am sorry .. cause I am not professional. and I will do it with risk. Viewing 7 replies - 1 through 7 (of 7 total) The topic ‘DB error’ is closed to new replies. ## Tags * [db](https://wordpress.org/support/topic-tag/db/) * [table](https://wordpress.org/support/topic-tag/table/) * In: [Everything else WordPress](https://wordpress.org/support/forum/miscellaneous/) * 7 replies * 3 participants * Last reply from: [alsadr](https://wordpress.org/support/users/alsadr/) * Last activity: [5 years, 9 months ago](https://wordpress.org/support/topic/db-error-30/#post-13409876) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics