Thu 06 February 2020 sysadmin How to repair a corrupted MySQL database Did your MySQL database got corrupted? Don't you have a recent backup? In this post I'll present three simple methods to restore your data.
Thu 30 January 2020 sysadmin MySQL incremental backup with mysqldump and rdiff-backup In this post I will show you a simple method to perform a MySQL incremental backup. This method is quite effective for small and medium databases.
Thu 16 February 2017 snippets Drop all tables in a database Sometimes it can be useful to completely drop all tables in a database, for example to reset a DB to a previous version from a backup. After checking that you are doing this on the right database and that you know what you are doing, you can do this: SET …
Fri 30 May 2014 snippets How to reset mysql root password on Ubuntu 12.04 Fast and easy! $ sudo stop mysql $ sudo -umysql mysqld_safe --skip-grant-tables & $ mysql mysql> UPDATE mysql.user SET Password=PASSWORD('newpassword') WHERE User='root'; mysql> FLUSH PRIVILEGES; $ sudo kill `cat /var/run/mysqld/mysqld.pid` $ sudo start mysql Enjoy your new mysql root password!