While adding a routine from cPanel > PHPMyAdmin, I was getting this error message –#1227 – Access denied; you need (at least one of) the SUPER privilege(s) for this operation First check if event scheduler is enabled on the server:...
This simple script will search for all wp-config.php files in a directory, pull the database name and create a backup of it. for wpinstall in $(find "$(pwd)"/ -type f -name wp-config.php | sed 's/wp-config.php//g') do echo "$wpinstall" dbname=$(grep...
Error encountered while fetching data: Disk full (/tmp/#sql-temptable-196ae-c7e7a-5e2f5.MAI); waiting for someone to free some space… (errno: 28 “No space left on device”) DBDISKUSED pcx3_wp324 0 DISKUSED 0 DB pcx3_wp324 USER...
This one-liner will backup your WordPress files and database into a directory name with today’s date. mkdir -p ../backup/$(date +%Y-%m-%d) ; mysqldump $(grep DB_NAME wp-config.php | grep -v WP_CACHE_KEY_SALT | cut -d \' -f 4) | gzip > ...
Error: MySQL: ERROR 1153 (08S01): Got a packet bigger than ‘max_allowed_packet’ bytes indicates that the “max_allowed_packet” size is reached on the server. This usually occurs during importing of huge files. First, check the...
![image 2 - [ERROR] Unknown/unsupported storage engine: InnoDB](https://i0.wp.com/pcx3.com/wp-content/uploads/2023/01/image-2.png?resize=657%2C299&ssl=1 "[ERROR] Unknown/unsupported storage engine: InnoDB")
MariaDB service failed due to insufficient space on /var partition. After removing the log/backup files, MySQL failed to start with the error: service mysqld status Jan 24 08:34:07 srv.pcx3.com systemd[1]: Starting MariaDB database server…Jan...
Check the current timezone from MySQL: SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP); OR select now(); To check where the timezone is loaded from use: SELECT @@session.time_zone; SELECT @@global.time_zone; If it is set to SYSTEM then it is using either...
When importing a database from MySQL8 server to MariaDB the following error is displayed: Error: Unknown collation utf8mb4_0900_ai_ci What is the meaning of the MySQL collation utf8mb4_0900_ai_ci? utf8mb4each character is stored as a maximum of 4...
For high-traffic websites, I advise developing a stagging website if you make significant updates or even switch the WordPress theme entirely. But one significant problem I encountered while moving from the staging site to the live one is that all...
Here is a small script that will restart the MySQL service in case it crashes. * * * * * /sbin/service mysql status || service mysql start Add it to /etc/crontab to run every minute. More complex script that does the same thing 😀 #!/bin/sh...