Category: MySQL

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 it’s who don’t know. Today, we learn how to make a duplicate/Clone/Copy Database using PHPMyAdmin. Why Do We Need to Copy a Database Using PHPMyAdmin? But first, we will discuss why we need to copy the database using PHPMyAdmin. Sometimes you face this situation where you are unable to clone a WordPress site on the same server due to its size, and all cloning tools fail to do this; they want to

Continue Reading
June 2, 2020 1 Comment
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 the MySQL error 1273 utf8mb4_unicode_520_ci in WordPress. This MySQL error #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’ often occurs when importing a WordPress database. This specific MySQL error often occurs when importing a WordPress database from one host to another using PHPMyAdmin. It can also happen even when importing on the same server. So, here are the steps that will help us fix the MySQL error #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’. STEP 1: Download your Database file in [.sql] format. STEP 2: Open the database file in either Macromedia Dreamweaver or Notepad++, then use the Search & Replace command (Ctrl+F). STEP 3: Next, search for “utf8mb4” and replace it with “utf8”. This will

Continue Reading
December 8, 2017 No Comments

Add Administrator User in WordPress Using MySQL

Friends, In today’s article, we’ll learn how to add an administrator user to WordPress using MySQL. Yesterday, my best friend reached out to me because his WordPress site was hacked, and his admin account was deleted. He asked me how he could add a new administrator without accessing the WordPress dashboard. I gave him a solution: you can add an administrator directly from MySQL. NOTE: Before proceeding, make sure to back up your website database. Add an Administrator from the WordPress MySQL Database Below are the two ways to perform this task. Not to worry, I’ll describe both: Run a MySQL query Manual Steps in MySQL Run a MySQL query This method is only for those who want to speed

Continue Reading
September 8, 2017 23 Comments