Category: MySQL

Seafile Photo Cloud Server Problems (must KNOW)

If you plan to setup a small private Photo Cloud Server and you try to setup “Seafile Community Edition” there are some MAJOR Points (disadvantages) to know: Seafile Community Edition has limited Functions (5 Users) The Photo Files saved on “Data Blocks Files” like on “IPFS” with hash Keys as Names You need a MYSQL […]

Nextcloud Owncloud Upgrade Traps

If you use Nextcloud (Owncloud) and you login into the Admin Panel the Updater display you that your Setup is outdated, you MUST handle as follows to PREVENT System Problems: Do FULL-BACKUP the Server Setup before you CHANGE something! Pre-Check Nextcloud Version dependency‘s of PHP-Version and MYSQL Version! Cause Nextcloud offers NO System PRECHECK or […]

MYSQL: Default Basic Table Structure WordPress

If you use WordPress and have tested some plugins and removed them later, it is possible that you have much waste tables still inside your database. First do Database Backup with MySQL DUMP Then check it enter the mysql console as your mysql admin user and do: $mysql -u mysqladminusername -p mysql > use databasename; […]

WordPress: Monitor the Size of the MYSQL Database

If you use WordPress or a other Blog Software with a MySQL Database over years it is useful to do some things regularly: Check the Database Size weekly, that no Skript Kid has found a Backdoor and fills up the Database silent Purge Database Caches with default maintenance tools of the Software Dont forget to […]

WordPress: Replace or Purge Text on all Posts by mysql

If you have to remove a link, text or else on all wordpress posts pages with same signs like the “read more” tag do: mysql -u dbadmin -p – enter password – change database by: use databasename – run change command(SET “more-tag-source-html-pre” WordPress reformat the output here! ): mysql > UPDATE wp_posts SET post_content = […]

Design copyright www.linuxonlinehelp.com - Linux PC & Server Support