Manejando datos

Restore MariaDB or MySQL backup files

Posted by in Databases, MariaDB, MySQL

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 you how to work with a custom script to make the copies, and that you can include in your Windows Startup to run automatically every time you access your computer, or launch it from a scheduled task, or when you need it. The case is to have the script ready. Today another fundamental part of backups is to prove that…read more

MySQL-MariaDB backups. How to automatize it

Posted by in Databases, MariaDB, MySQL

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 tell you my experience, and some of the Windows scripts to automate the tasks, which always comes in handy. In my case, I usually have several scripts depending on the needs, but they all have the same objective: to back up MySQL or MariaDB databases. A script to backup MySQL-MariaDB databases The script I present you in this entry is…read more

Migrating from MySQL 5.5 to MariaDB 10.4.

Posted by in Databases, MySQL

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 MySQL 8 without installation), idem for MariaDB 10.4 both using Xampp and from files, comes the peak moment: migrating from a MySQL 5.5 database to the latest available version of MariaDB, which is version 10.4. Moving from MySQL 5.5.x to MariaDB, without moving first to MySQL 8 neither trying other versions such as MySQL 5.6 or 5.7 or 10.0, 10.1,…read more

Recover a MySQL database with no ibdata1 file

Posted by in Databases, MariaDB, MySQL

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 to me with the database of my thesis, becuase suddenly, my database has been corrupted, and I cannot use it. Or even worse, I have access but I have no data although the file size are large enough (some files, of course). Important: This tutorial is been writen at the same time as I am executing instructions, without knowing what…read more

How to: having MySQL 8 portable

Posted by in Databases, MySQL

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 a MySQL 8 as the server to work. Downloading MySQL The first thing for having a MySQL portable version is that we can’t use the MySQL installer (in this blog I already told you how to install MySQL 5.6 with the installer). This time, we downloaded the zip version. Once downloaded the file, unzip the file in the directory you…read more