Manejando datos

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

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

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