Author Archives: Randy

MySQL: How To Repair & Optimize All Tables in All Databases

The following command can be used to repair and optimize all tables in a MySQL database.  This can be useful on a busy server with many tables after a hard reboot or otherwise unclean shutdown. mysqlcheck -u root -p –auto-repair –optimize –all-databases

Creating a .tar.gz archive (*nix ‘tarball’)

The following command can be used to create a .tar.gz archive, commonly referred to as a ‘tarball’ file. tar -pczf name_of_your_archive.tar.gz file1 file2 directory1 directory2 ect…

Categories: Linux. Comments Off on Creating a .tar.gz archive (*nix ‘tarball’)