Row size too large error is caused because of the MySQL configuration issues. Database power up a website with its content like text, images path etc. A mysql database contain all operations to be made by the website to load … Continue reading How to fix Row size too large (> 8126).
Error #1 : 1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘(0), This error can be occured due to mysql configuration … Continue reading #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘(0),
Replacing the text with utf8_unicode_ci will fix the issue I took a dump of a database with stored procedures using Export data wizard in WorkBench. So I was ready to import all data from the SQL file. I use XAMPP to set … Continue reading #1253 – COLLATION ‘utf8_unicode_ci’ is not valid for CHARACTER SET ‘utf8mb4’
I was very confident about my website security until my website got hacked by an awesome hacker asking for profit via bitcoin. Many of you may be noticed that past few days our website contents were not available. Because Techbiriyani.com … Continue reading Oopsie !! We’ve Been Hacked: See How We Overwhelmed With It
WordPress Database is like a brain for your entire WordPress site because every single information is stored in there thus making it hacker’s favourite target. Spammers and hackers run automated codes for SQL injections. Well, unfortunately, many people forget to … Continue reading How to Change the WordPress Database Prefix [BRIEF GUIDE]
There are chances of losing databases of websites. I too faced the same situation with this website. One day my website is not accessible, after some research i found that my server MySQL service is not loaded. I tried to … Continue reading How to Recover InnoDB database from .frm and .ibd files in WordPress