Phpyouth Blog

Tag: phpmyadmin

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
Remove woocommerce sessions

How to Remove wc_sessions in WooCommerce

Hello friends! Today, in this tutorial, we will learn how to remove sessions in WooCommerce. First, we will discuss why we need to remove these sessions from WooCommerce. These sessions make the wp_options table heavy in size. WooCommerce stores the _wc_session_xxx and _wc_session_expires_xxx entries in the wp_options table. There are two reasons behind this, and below are: Cron tasks are not working on the site A bot is crawling your site and creating sessions on the fly That’s the reason,

Continue Reading
July 4, 2019 4 Comments
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