Export large datasets with MySQL
Today’s entrance is dedicated to export large datasets, that is, when the outcome of a SQL query is too large with millons of rows. I will be using a database… Read More »Export large datasets with MySQL
SQL
Solution to Error 1067 Can’t start the server on MySQL
As I already wrote here, a week later after reporting this bug (because I change the datadir property on the config file my.ini) I didn’t have a solution for error… Read More »Solution to Error 1067 Can’t start the server on MySQL
MySQL-MariaDB Registry files
One feature from MySQL (also from MariaDB) very useful for DBA is registry files, that stores everything of what is happening on the server. You have several alternatives. By default,… Read More »MySQL-MariaDB Registry files
DBA tools: MySQL WorkBench
MySQL WorkBench is the open alternative from #MySQL for the DataBase Administrator, DBA, and also for the non-DBA that need to work directly with databases. A few months ago ORACLE… Read More »DBA tools: MySQL WorkBench
Moving from MySQL 5.5 to MySQL 5.6. Step 6. My first bug report
After a few entrances talking about how to move from #MySQL 5.x to versión MySQL 5.6 (what I write is also valid for MySQL 5.7 although you need to know… Read More »Moving from MySQL 5.5 to MySQL 5.6. Step 6. My first bug report
MySQL 5.6 Config file. Step 5
In previous steps, you could read about creating database backups, how to unistall and install a MySQL server, and how to start working with a new MySQL version, in our… Read More »MySQL 5.6 Config file. Step 5
Moving from MySQL 5.5 to 5.6. Step 4: Starting with MySQL 5.6.10
On previous post, I already wrote about how to create a database backup, how to unistall a MySQL version, ad how to install a new MySQL version, in this case,… Read More »Moving from MySQL 5.5 to 5.6. Step 4: Starting with MySQL 5.6.10
Moving from MySQL 5.5 to 5.6. Step 3: Install MySQL 5.6.10
In previous steps, I have explained how to create backups of your MySQL-MariaDb databases and how to unistall MySQL, including all configuration files (very important!!). Now, let’s install the new… Read More »Moving from MySQL 5.5 to 5.6. Step 3: Install MySQL 5.6.10
Moving from MySQL 5.5 to 5.6. Step 2. Uninstall MySQL 5.x
I already wrote about the less information I got from migrating from version 5.0, 5.1 or 5.5 to version 5.6 on Windows, so … I’ll write about the way I… Read More »Moving from MySQL 5.5 to 5.6. Step 2. Uninstall MySQL 5.x
Moving from MySQL 5.5 to 5.6. Step 1: Backup
Today I start a serie of post dedicated to #MySQL database, one of the most used databases on Internet sites. Apart from this, I must say that I found less… Read More »Moving from MySQL 5.5 to 5.6. Step 1: Backup