This entry is not exclusive to a particular version of MySQL, but can be used by anyone, including MariaDB databases. It’s about executing database backups using mysqldump, and where I’ll… Read More »MySQL-MariaDB backups. How to automatize it
Normally, when you start working with databases, you can suffer a dissaster, and you will be lucky if you do not got only one. And that’s what it has happended… Read More »Recover a MySQL database with no ibdata1 file
Working with the characters in the databases seems to have no consequences, until you come across things that do not match. In today’s post I tell you how to make… Read More »Modify COLLATE of all tables and columns in MySQL-MariaDB
Although we have spoken several times of this framework MariaDB MySQL-today a new feature, I bring very useful when you need to perform repetitive tasks based on consultations. It is… Read More »Common_schema: repetitive tasks with foreach
In previous entrance related to MySQL and MariaDB I wrote one entrance related to why indexing is important, when working with databases (the article is only in spanish, but I… Read More »The mecanism of indexing on MySQL-MariaDB
I am working a a project in the University and I need to re-create a table. For that task, I’m thinking in two ways: using TRUNCATE, or dropping the table… Read More »Faster method: TRUNCATE or DROP a table?