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.
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 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
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?
