Importing a MySQLDUMP From your SSH command prompt type … mysqladmin -u {username} -p {password} create {databasename} mysql -u {username} -p {password} < {databasename.sql} Replace the parameters with the appropriate values {username} – this is your database username {password} – this is the password for your database {databasename} – the name of your database {databasename.sql}…
Often time, you may need to know which file contains large file size, and delete it to save space. Here’s a code pattern to show you how to find large file size on Linux : 1. File size >= 100MB Find all files that have a size >= 100MB, from root folder and its sub-directories….
Restore MySQL databases with innodb_force_recovery Why use the innodb_force_recovery option? A higher rate of database restore failures have been observed in MySQL 5.7 and higher versions, after innodb_file_per_table became the default tablespace option. This is due to the data consistency standards that InnoDB adheres to. In short, when an attempt is made to restore a database, the…
To check the load: sar -q -f /var/log/sa/sa$(date +%d -d yesterday) To check the CPU status: sar -p -f /var/log/sa/sa$(date +%d -d yesterday) To check the Swap Space usage: sar -S -f /var/log/sa/sa$(date +%d -d yesterday) To check the RAM memory usage: sar -r -f /var/log/sa/sa$(date +%d -d yesterday)
If you have too many files to remove, try this trick: find . -name ‘*’ | xargs rm -v