itdoctor (Page 42)

When you run mysqldump , by default it will not export your procedures or function , if you want to include these info , you need to add –routines option in your mysqldump command. mysqldump —routines > outputfile.sql Let’s assume we want to backup ONLY the stored procedures and triggers and not the mysql tables and data (this can be useful to import these in another db/server that has already the data but not the stored procedures and/or triggers), then we should run something like: mysqldump –routines –no-create-info –no-data –no-create-db –skip-opt > outputfile.sql and this will save only the procedures/functions/triggers of the . If you need toRead More →

There are 3 commands that we can use sar top mpstats You may need to install sysstat package to use these commands : apt-get install sysstat If you install sysstat , enable systat by edit: nano /etc/default/sysstat    -> change ENABLE from false to true.Read More →

Today, my server is out of disk and i see there are lot of files in /tmp , their names are phpXXXX , i know these  files are uploaded by PHP, but why they are not deleted after the scripts end. After a lot of troubleshooting , i found that there is some errors in my apache error log with “child process exit , filesize limit…” i did some research , and found that it’s because apache can not  work with file larger than 2GB , i searched though my file system and saw there are some of my application logs files generated files atRead More →