For urgent reason like preventing website down when dumping MySQL, we need to skip lock-tables. You can use -–skip-lock-tables and –skip-add-locks option with mysqldump command. Example : mysqldump -u 412843_reebonzsg -p –skip-add-locks –skip-lock-tables db_name \ > dbfile_dump.sql

Just because of my monitoring server being shut down by somebody at office, I should give my customer another availability report. I decided to use awstats, because it’s free to use and also widely use for analysing apache log. By default, awstats will process data at monthly based, but for   Read More ...