Today morning, developer told me: please send me the database of ***.
Me: do you really need to it?
Developer: ya, I need it.
Me: okay, wait me for minutes.
And I need to exclude one table in database with him. Databases has some tables securely, he did not know it.
How to export database while excluding the table?
mysqldump --ignore-table=db_name.table_name db_name > export.sql
mysqldump --no-data...
[HOW TO] enable/ configure iptables in Fedora 22
In Fedora 22, firewall has no active. Here I'll learn how to enable the iptables firewall application and make sure that runtime rules persist after a reboot.
The iptables package is already installed, but to be enable, you need to install the iptables-services package.
sudo yum install iptables-servicessudo systemctl enable iptables.servicesudo systemctl start iptables.service
To view the rules,...
[HOW TO] configure Postfix to use Gmail SMTP on Fedora/ Linux/ Ubuntu
I have just created a script to monitoring website. It send the email to me when any website is down. Script store in my local, thus I think to build a MTA in my laptop.
Here I show the outlet for task list:
1. Configure MTA local use Google Mail
2. Create cron job to run script every boot time.
1. Configure MTA local use Google Mail
I have chosen Postfix as MTA. A few time ago, I configured...
[HOW TO] install Postfix MTA
Here I show you the step-by-step to install MTA on server/ client.
123 yum install postfix
127 alternatives --set mta /usr/sbin/sendmail.postfix
133 cp /etc/postfix/main.cf /etc/postfix/main.cf.orig
134 vi /etc/postfix/main.cf
135 /etc/init.d/postfix restart
136 chkconfig postfix on
As you...
[HOW TO] install Geary on Fedora 22 | Geary is having issues
I am using fedora 22 and I am really fed up with Thunderbird. On Linux there are a few Mail Client alternatives to the Thunderbird email client. But I still did not like.
Until now, Geary is an interesting beast. It looks like a beautiful girl to write an email.
I'm fairly confident that you will like it.
On personally social page, I wrote as above. But the fact it runs unstable. It looks like...
[HOW TO] exit MySQL command prompt?
Hello dude,
Mysql gives me a shit :(
I ran the invalid command mysql like this:
mysql> select * from conf ->
I can not exit the. Google, someone suggest me use Ctrl + C or Ctrl + D to solve this. But it give:
-> Aborted
What the fuck? How to solve it?
*Fortunately* I find it: "\c"
mysql> select * from conf -> -> ...