Phpyouth Blog

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

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:

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

Continue Reading
September 8, 2017 23 Comments