View Single Post
  #6  
Old 24th May 2010, 14:10
Sinchan Sinchan is offline
Member
 
Join Date: Nov 2006
Posts: 48
Thanks: 14
Thanked 2 Times in 2 Posts
Default

Quote:
Originally Posted by zalo View Post
Can somebody tell me how to import this SQL file in to my ISPConfig database? I want to use these header and mime filters on my ISPConfig 3 system.

Thanks
Zalo
$ mysql -u root -p mysql
Enter password:

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use ispconfig; <-- change database name to your ispconfig db
Database changed
mysql> source mail_content_filter.sql.txt;
Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.04 sec)

Query OK, 480 rows affected (0.08 sec)
Records: 480 Duplicates: 0 Warnings: 0

Query OK, 158 rows affected (0.01 sec)
Records: 158 Duplicates: 0 Warnings: 0

mysql> commit;
Query OK, 0 rows affected (0.00 sec)
mysql> exit

And you can check import your sql script above in your ispconfig web on Email -> Global Filters -> Content Filter

Thats it Zalo, and hope this help
but in mine, spam is still didnt reject (see my post above)

Last edited by Sinchan; 24th May 2010 at 14:19.
Reply With Quote