Articles

Close Trackbacks on All WordPress Posts at Once Issue: All posts in a WordPress driven website need to be closed. Solution: Log into phpMyAdmin... Configure Default MySQL Engine to Use MyISAM Issue: New database tables are being created as InnoDB (when using MariaDB / MySQL). They should... Convert WordPress InnoDB Tables to MyISAM Convert default WordPress tables from InnoDB to MyISAM, use MySQL query: ALTER TABLE... Fixing Corrupt InnoDB Tables Issue: CentOS 7.x server using cPanel. Admin receives alert email containing the following... Manual Import Export MariaDB / MySQL Database Issues: CentOS 7.x server running an instance of cPanel / WHM. There is an issue with the UI that... MariaDB Error Column last_update in table “mysql”.”innodb_table_stats”… Issue: After stepped updates from MariaDB 10.0 to 10.3, the following error is displayed (in the... Rename WordPress Database Table Prefixes Rename default WordPress tables to with a different table prefix ($table_prefix): RENAME TABLE... Repair All MyISAM Tables on All Databases on Server Issue: MyISAM tables sometimes need repair, but website owners often fail to advise that their... WordPress Change Ownership of Posts To transfer posts under author A to merge with those under author B, use the below SQL query.... WordPress Change Site / Home URL If you transfer your WordPress site from the localhost to the server, or from one domain to... cPanel Graceful MariaDB MySQL Restart Below is the command to restart MariaDB on cPanel based server:... phpMyAdmin Database Table Locked and in Use Issue: WordPress driven website on CentOS using MariaDB, MyISAM tables. Site has display problems...
« Back