How to improve database import with MySQL and MariaDB

In this post, I want to emphasise the approach to speed up importing data to a MySQL or MariaDB database using the exported file. mysql -u dbuser -p dbpass mydatabase…

Rename a MySQL database

Once day you want to rename your database in MySQL for whatever reason. How can you do this idea? via phpMyAdmin From phpMyAdmin, we often rename a database by applying…

Deleting multiples table automatically in database

Today I want to delete several tables automatically. http://yagudaev.com/posts/deleting-multiple-database-tables-the-easy-way/