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 Database, MAJOR if broken by Updates all Photos lost! Seafile is based on Python Framework Software if any SPECIAL needed Python-Module is broken by a Update your Photos lost! I have tested many Setups, the big OS-RELEASE Changes often a big Trap cause broken Dependencies […]
Category: 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 Auto-Stop! Login into the Server via SSH Console and go to the /var/www/nextcloud folder. Run: sudo -u www-data php /var/www/nextcloud/updater/updater.phar Read Upgrade Echos on Console Advantage the Console-Version is mostly faster and more stable than the browser! Relogin as Admin to the Nextcloud Panel! In 99% of Problems the […]
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; mysql > show tables; System echo: +—————————+ | Tables_in_wordpressdatab | +—————————+ | wp_commentmeta | | wp_comments | | wp_links | | wp_options | | wp_postmeta | | wp_posts | | wp_term_relationships | | wp_term_taxonomy | | wp_termmeta | | wp_terms | | wp_usermeta | | […]
WordPress: Change Word on all content sites with mysql
If you run a WordPress Blog or other CMS with MySQL Backend you can easy change one same word or expression on all content sites on the fly Do a mysqldump at first of the current database $ mysqldump -u username -p dbname > dbbackup.sql Login to the MySQL server Console Switch to the Database mysql> use dbname; run command for tests, lists touched posts mysql> SELECT * FROM wp_posts WHERE (post_content LIKE '%expression%'); Run Replace code to pre, cause i use preformat text plugin for the copy & paste boxes mysql> UPDATE wp_posts SET post_content = REPLACE ( post_content, […]
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 create a MySQL Dump Backup weekly with cron To Check the Size login on mysql command prompt do: $mysql -u dbuser -p #Enter Password mysql > use dbwordpress mysql > SELECT table_schema "Data Base Name", sum( data_length + index_length) / 1024 / 1024 "Data Base […]
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 = REPLACE (post_content,'<!!–more–>',''); – System Echo’s: Query OK, 88 rows affected (0.01 sec) Rows matched: 706 Changed: 88 Warnings: 0