Study PHP Skills, Share PHP Code
We often delete a product which is sold out, and we never sell it in the future, we usually delete this product right away to save our web hosting and let the web hosting run faster. But by default, when… Read moreHow to Remove all Unused Product Images from Magento 2?
Nowadays it is very important to back up the databases of our websites from time to time. So many spammers, hackers try to hack or destroy our websites for fun or money. I usually use PHPmyadmin to backup my websites’… Read morePHPmyadmin pop-up error notice when export database.
The account sign-in was incorrect or your account is disabled temporarily. Please wait and try again later. This means your admin account is disabled, so you can unlock it via command line: php bin/magento admin:user:unlock ADMINUSERNAME We may have forgotten… Read moreHow to Reset Admin password in Magento 2.3.7 and 2.4?
If we plan to back up /export only one MySQL databases in a file, we can use the following method: mysqldump -u root -p mydatabase > /home/myuser/database-dump.sql If we want to back up several databases only in a file, we… Read moreHow to Back Up/Export All MySQL Databases in Separate Files with Mysqldump?
Listen, if you have 10,000 companies’ URLs at your MySQL, now you need to add about-us.html just after each URL, for example, one of your company URLs is absorking-desiccat, how to let it become to absorking-desiccant/company_profile.html?
I have a MySQL database, about 8 GB, and I have tried several types to import it to MySQL databases, such as bigdump, PHPMyAdmin…, all fails. Finally, I found a way successfully. I am very glad to share this with… Read moreHow to import extra big data to MySQL databases?
Sometimes we need to convert upper case to lower case, for example, x-cart, by default, its category and product URL shows as a category or product name. if a category or product name has an upper case, then its related… Read moreSimple way to convert Upper Case to Lower Case via MySQL
If you get this error, you do not have privileges on user_* to use Create. HostGator needs to correct this issue for you. If you open your database which you plan to import to your HostGator web hosting, you can… Read moreERROR 1044 (42000): Access denied for user ‘username1’@’localhost’ to database ‘006’
First export the databases which you plan to convert. $> mysqldump -u root -p123 –default-character-set=latin1 shop > /root/shop.sql Second, convert the database to utf8 $> sed -e ‘s/SET NAMES latin1/SET NAMES utf8/g’ -i /root/shop.sql $> sed -i -e ‘s/CHARSET=latin1/CHARSET=utf8 COLLATE=utf8_unicode_ci/g’… Read moreConverting Data from Latin1 to UTF-8
Sometimes I need to clean a mysql server so I can re-import it clean from the backups. A DROP ALL DATABASES; would have been nice, but the following does the trick. It will drop all databases except for mysql, test… Read moreHow to Drop all Databases from Mysql?