How to Fix: WordPress database error Duplicate entry ‘0’ for key ‘PRIMARY’ for query INSERT INTO `wp_usermeta`

August 21st, 2019 by

Recently, when I was playing with the multisite feature of WordPress I came across this error I understand that there is some problem in the database table wp_usermeta. Well, actually what I was trying to do is to convert my present wordpress single site to multisite. And during this process I suddenly started getting this […]

How to import big MYSQL dump in WAMP Server

May 7th, 2018 by

Hi all When importing big SQL dump in WAMP, phpmyadmin shows an error that it cannot upload such big dump. The easiest solution I found is, just type in the following in your command prompt.. and it’s done. C:\wamp64\bin\mysql\mysql5.7.19\bin\mysql.exe -u root -p {dbName} < {file location} {dbName}: should be replaced with your database name where […]