If you are a database administrator, it could be really useful to hava available good tools. When this blog started, I already wrote about frameworks for MySQL DBA, and I’ve read several entrances about common_schema, another useful framework under the MySQL-MariaDB ecosystem. Today it’s time for Sys Schema, a collection of views, functions and procedures to help MySQL administrators get insight in to MySQL Database usage, so let’s install it. Install SYS on Windows The project is available to download on GitHub: https://github.com/MarkLeith/mysql-sys, so, I downloaded it and unzip on...read more

The post Install Sys_Schema on MySQL – MariaDB appeared first on Manejando …

Last week I was asked for help to the invertigation group I work with at University of Cordoba UCO for setting up a  WordPress page, instead of Joomla. In order to access the files by FTP, I use Filezilla with success, but I didn’t know how to access the database for creating a backup (backup). …

Continue reading »

Esta entrada Adminer, a simple but effective database manager es contenido original de Manejando datos - Blog de bases de datos y programación. This entrance Adminer, a simple but effective database manager is created by …

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 published the 6.0 beta version of this tool, with new features and improvements (previuos version was 5.2), and right now you can download version 6.1. …

Continue reading »

The post DBA tools: MySQL WorkBench appeared first on Manejando datos.