Category: MySQL

Japanese character were displaying blank in pdf file converted using wkhtmltopdf

We can convert the html file to pdf format using tool called wkhtmltopdf. I have already provided necessary steps to implement in linux server in my previous post. But the pdf file was not displaying Japanese characters in it. Fix Please note that Chinese, Japanese, Korean font was not installed in the server. yum install … Continue reading Japanese character were displaying blank in pdf file converted using wkhtmltopdf →

change wordpress theme from the database using phpMyadmin

Follow the steps to change/activate WordPress theme from within the database. 1. Log into phpMyAdmin. 2. Click on the wordpress database. 3. Go to the wp_options table. 4. Under the option_name column, locate the template entry. 5. Click Edit next to the template entry. 6. In the option_value column, change the value to the name … Continue reading change wordpress theme from the database using phpMyadmin →

[ERROR] Plugin ‘Aria’ registration as a STORAGE ENGINE failed.

Mysql service was down in one of the vps with following error in the mysql log [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables [ERROR] Aborting mysqld: File '/var/lib/mysql/aria_log.00003041' not found (Errcode: 2 "No such file or directory") [ERROR] … Continue reading [ERROR] Plugin ‘Aria’ registration as a STORAGE ENGINE failed. →

[ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.

Mysql was crashed and was not starting. Though we ran innodb_force_recovery to up the mysql, there were many issues like core tables were crashed, phpmyadmin was not showing databases, 16 length user character issue and so on. Also while checking mysql_upgrade_info file in the /var/lib/mysql directory, it was showing mysql5.6 though the server was having … Continue reading [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. →

Database getting wiped out and loading sample default page in wordpress

Cause : ThemeGrill Demo Importer < 1.6.3 - Auth Bypass & Database Wipe A critical bug was reported with ThemeGrill Demo Importer plugin. This allows the affected plugin to execute some functions with administrative privileges on the WordPress website. The prerequisite is that there must be a theme installed and activated that was published by … Continue reading Database getting wiped out and loading sample default page in wordpress →

How to backup the database of a cPanel account using AWS S3 bucket

Install and Use AWS CLI for backup 1.Check python version #python --version 2.Download the AWS CLI Bundled Installer #curl "https://s3.amazonaws.com/aws-cli/awscli-bundle.zip" -o "awscli-bundle.zip" 3.Unzip and install #unzip awscli-bundle.zip #./awscli-bundle/install -i /usr/local/aws -b /usr/local/bin/aws 4.Installed Version Check #/usr/local/bin/aws --version 5.Configuring AWS Bucket #aws configure Or can configure at location #/root/.aws/credentials in file. aws_access_key_id = **************** aws_secret_access_key = … Continue reading How to backup the database of a cPanel account using AWS S3 bucket →

To change wordpress theme via backend using database commands

To change the current theme to twentyfourteen default theme >> mysql >> use database_name; To see current theme >> select * from wp_options where option_name = 'template' or option_name = 'stylesheet' or option_name = 'current_theme'; >> update wp_options set option_value = 'twentyfourteen' where option_name = 'template'; >> update wp_options set option_value = 'twentyfourteen' where option_name … Continue reading To change wordpress theme via backend using database commands →