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
After the return of the summer, we continue working with MySQL and MariaDB. After the entry about how to have MySQL 8 in portable format (that is, how to have… Read More »Migrating from MySQL 5.5 to MariaDB 10.4.
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
After “all problems” I had with the database of my thesis (how to recover a database with no ibdata1 file), and get it back, I can teach you in more… Read More »Lessons I’ve learnt for not having backups
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 previous entry we commented on how to have a portable MariaDB server, using the XAMPP tool, while in this entry, I propose that instead of MariaDB, let’s prepare… Read More »How to: having MySQL 8 portable
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
In the new series about upgrading from MySQL 5.5 to MariaDB, I must write about what is new in MySQL 8. I must confess that I haven’t tried version 5.7… Read More »What is new in MySQL 8
