All posts in Linux

Dump và restore mysql

Dump and restore a single table from .sql Dump mysqldump db_name table_name > table_name.sql Dumping from a remote database mysqldump -u <db_username> -h <db_host> -p db_name table_name > table_name.sql For further reference: http://www.abbeyworkshop.com/howto/lamp/MySQL_Export_Backup/index.html Restore mysql -u <user_name> -p db_name mysql> source <full_path>/table_name.sql or in one line mysql -u username -p . . . Read more

Mail.log bị flooded bằng noti Feb 1 05:18:39 nginx-php-fastcgi postfix/master[1592]: fatal: remove public/pickup: Permission denied

[sourcecode language=”powershell”] root@gandalf:/var/spool/postfix# /etc/init.d/postfix stop root@gandalf:/var/spool/postfix# killall -9 postdrop root@gandalf:/var/spool/postfix# chgrp -R postdrop /var/spool/postfix/public root@gandalf:/var/spool/postfix# chgrp -R postdrop /var/spool/postfix/maildrop/ root@gandalf:/var/spool/postfix# postfix check root@gandalf:/var/spool/postfix# postfix reload [/sourcecode]