Category: Database

DuplicateCloneCopy Database using PHPMyAdmin

How to make Duplicate/Clone/Copy Database using PHPMyAdmin

Hello Friends, How are you? I hope all are feeling well, safe, and at home in this pandemic. I also want to say sorry for not publishing an article in the last 75 days. So today we started again with a new topic, can’t say new but yes its who don’t know. Today we learn, How to make Duplicate/Clone/Copy Database using PHPMyAdmin. But first, we will discuss why we need to copy the database using PHPMyAdmin. Sometimes you face this situation that you unable to clone a WordPress site on the same server due to heavy size and you’re all

Read More »
utf8mb4_unicode_520_ci

How to fix #1273 – Unknow collation: ‘utf8mb4_unicode_520_ci’ MySQL query error

Hello Friends, Today we will learn how to resolve MySQL error in WordPress #1273 – Unknow collation: ‘utf8mb4_unicode_520_ci’. Actually, this is a very big problem we are facing when we are importing WordPress Database from one host to another host in PHPMyAdmin or even sometimes the same server.   So guys, below steps will help us how to fix this #1273 – Unknow collation: ‘utf8mb4_unicode_520_ci’ MySQL issue. STEP 1: Download your Database file in [.sql] format. STEP 2: Open your Database file either in Macromedia Dreamweaver or in Notepad++ software and give Search & Replace command ctrl+F STEP 3: After that put “utf8mb4” on search and

Read More »

How to add an Administrator from WordPress MySQL Database

Hello guys today we will learn how to add an Administrator from WordPress MySQL Database in this tutorial article. Actually yesterday my best friend told me that his WordPress website was hacked and her account has been deleted. He asked me what’s the solution how to add new Administrator without accessing WordPress dashboard. So, I gave her satisfying solution that you can add administrator from MySQL. NOTE: Before we start doing this, make sure that you have taken backup of your website Database. Add an Administrator from WordPress MySQL Database Below are the two ways to perform this task, not

Read More »