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 […]
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 […]
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: 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 […]
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 = […]
WordPress: Move Blog to new URL Domain HTTP HTTPS on the MYSQL Console
Info: Today most Search Engines prefer Blogs who are offering “HTTPS” at the URL for secure direct connects to the Websites but this results a lot of headaches to the Website Developers. To be effective you should know: You have to offer HTTPS beside HTTP You should use a validated Domain Certificate, most Domain Resellers […]
PHPMYADMIN: Performance Monitor not working Java Script Error
If you install phpmyadmin on your Server Version 4.XX, the Browser shows a Javascript Error if the Performance Monitor is opened. Problem is the mostly the setting “localhost” on the config.inc.php file. If you want to view the monitor from external, set the ip to 192.XXX.XXX.XXX or domainname and control that the MYSQL Server is […]
MySQL : Backup and Restore Database without phpmyadmin (commandline)
Problem: phpmyadmin interfaces are slow and often attacked by script kids, if you can don’t use it! Solution: To backup and restore use command line To Backup a database: $mysqldump -u root -p wordpressdb > /backups/wordpressdb-dump.sql [Enter root password] To restore: $mysql -u root -p wordpressdb < /backups/wordpressdb-dump.sql[Enter root password] Remark: this is not recogized […]
WordPress MySQL: Cleanup old revisions old posts old entrys
Problem: If you use wordpress and edit often your posts a high count of old revisions are backuped inside the mysql database: Solution: Login mysql $mysql -u root -p [Enter root password] at mysql command line select wordpress your database mysql>use wordpressdb; [Enter] System echo=Database changed.. delete old backups of posts mysql>DELETE FROM wp_posts WHERE […]