This post is specific for MariaDB databases only, and it is related to a really cool feature I like a lot: system-versioned tables, available since MariaDB version 10.3.4. The concept,… Read More »System-versioned tables in MariaDB
We continue to learn things about databases, and this time, it’s time to restore the backups we’ve made of our MariaDb or MySQL databases. In the previous entry I showed… Read More »Restore MariaDB or MySQL backup files
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
In previous entries we have discussed how to have MySQL 8 portable, in addition to the option of using XAMP to also have MariaDB also portable (in previous versions it… Read More »MariaDB 10.4 portable in your USB
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
In the last posts of the blog I have talked about databases again, and we are working again with MySQL (what’s new in MySQL 8) and MariaDB. Some weeks ago… Read More »How to: MariaDB portable using XAMPP
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?
