DevOps Engineer
When you run MySQL commands MySQL, mysqlcheck, mysqdump and psql, psqldump, etc; they will pick username & password from this file if you do not provide them as argument (-u and -p). It can save you time.
Of course, if you specify username and password explicitly as part of the … Read more
When you run MySQL commands MySQL, mysqlcheck, mysqdump and psql, psqldump etc; they will pick username & password from this file if you do not provide them as argument (-u and -p). It can save you time.
Of course, if you specify username and password explicitly as part of the … Read more
Introduction
MySQL is one of the most popular open-source relational database management systems used by developers worldwide. Whether you’re a beginner or an experienced user, understanding how to install, configure, create users, and databases with permissions in MySQL is essential for effective database management. In this blog post, we’ll guide … Read more
PostgreSQL: The World’s Most Advanced Open Source Relational Database
PostgreSQL is arguably the most advance and powerful opensource enterprise class relational database system. It is the object relational database system and provides the most standard compliant system for the Database designers. It provides the complete support for reliable transactions that … Read more
Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consists of a single file ready to deploy to the target server. Adminer is available for MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Firebird, SimpleDB, Elasticsearch, and MongoDB.
sudo mkdir /usr/share/adminer
--max_allowed_packet=512M to your mysqldump command.max_allowed_packet=512M to [mysqldump] the section of your my.cnfNote: it will not work if it is not under the [mysqldump] section…