Backups all databases mysqldump -u [user] -p[password] --all-databases > [filename].sql specific databases mysqldump -u [user] -p[password] [database_name] > [filename].sql restore mysqldump -u [user] -p[password] [database_name] < [filename].sql backup specific table from a database mysqldump -u [user] -p[password] […]
update it from the console (will revert upon reboot) from the command line go to the mysql console mysql then edit the sql_mode entry SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); SELECT @@sql_mode; SELECT @@GLOBAL.sql_mode; for a persistent change, in mysql […]
surprisingly, to find the min date per company, which is a super basic query, on mysql you need to do a complicated query. SELECT a.id, a.company, a.email, a.custom_last_email FROM leads a INNER JOIN ( SELECT company, MIN(custom_last_email) mindate FROM […]
sudo apt-get remove --purge phpmyadmin php-gettext php-mbstring -y sudo apt-get autoremove -y sudo apt-get update sudo apt-get install phpmyadmin php-gettext php-mbstring -y
I installed PHPMyadmin to check my help manage my database, eventhough I also use the desktop program MySQL Workbench, I fell sometimes its important to use the webconsole. Recently, upon checking my MySQL Logs (/var/logs/mysql/error.log) I encountered that everyday I […]