Your server protector
The MySQL server has gone away error denotes that the connection was closed by the MySQL server (mysqld) after it timed out. If nothing happens for eight hours (28800 seconds), MySQL will automatically terminate...
The Magento 2 Admin user password cannot be changed via a command, but it can be changed through the database by following the steps. Step 1: Connect to MySQL database By using the mysql...
Issue :- Received below error while trying to import or insert a large volume of data into the MySQL database. The list of errors related to “MySQL server has gone away” are as follows:-...
Administrative tools / Commandline / Commands / Database / MySQL
by Mohammed Noufal · Published June 14, 2021
You can use any of the below commands to find the MySQL uptime mysqladmin version or mysqladmin version | grep -i uptime Example: mysqladmin ver or mysqladmin ver | grep -i uptime mysqladmin status...
Administrative tools / Backend files / Commandline / Database / MariaDB / MySQL
by Mohammed Noufal · Published May 13, 2021
The binary log is a set of log files that contain information about data modifications made by the MySQL server instance. You can see there are multiple binary files will be available on your...
Administrative tools / Commands / Database / MySQL / Wordpress
by Mohammed Noufal · Published April 17, 2021
Step 1 :- You will need to create a MD5 Hash version of the new password that will be assigned to the account, by issuing the below command. You can replace the “newpass” string...
Administrative tools / Backup / Commands / Database / MySQL / mysqldump
by Mohammed Noufal · Published March 6, 2021 · Last modified March 7, 2021
You can take backup of whole db to .sql file using mysqldump command and do the replace and import it back. To take the backup of the database to sql file To replace text...
To change the WordPress Username, Nickname and Display Name in MySQL Table, you can follow below steps. Login to the server as a root or login to ssh console with your cPanel username (If...
If you are taking the MySQL database using mysqldump command, you may receive below warning. You can use –events flag along with mysqldump and run below command to include the events table. FYI :-...
Database / Errors / MariaDB / MySQL / Plesk
by Mohammed Noufal · Published September 1, 2018 · Last modified June 19, 2021
Issues :- When performed an upgrade, rebooted and MySQL isn’t starting. The key error seems to be “[ERROR] Can’t init tc log” Plesk is inaccessible with the following error: mariadb service is not starting:...
More
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | ||||
| 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| 11 | 12 | 13 | 14 | 15 | 16 | 17 |
| 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| 25 | 26 | 27 | 28 | 29 | 30 | |
Email / IP blacklist / Security / Spamming
How to delist your IP from Major ISPs Spam blacklist
July 20, 2023
Administrative tools / Commandline / Wordpress / WP-CLI
How to Reset a WordPress Admin Password Using WP-CLI
January 3, 2023
