MySQL

mysql configuration File

nano /etc/my.cnf

[mysqld]
default-storage-engine=InnoDB
innodb_file_per_table=1
max_allowed_packet=268435456
open_files_limit=10000
interactive_timeout=300
key_cache_block_size=4096
max_heap_table_size=32M
max_join_size=1000000000
max_allowed_packet=268435456
open_files_limit=10000
query_cache_size=32M
thread_cache_size=100
tmp_table_size=32M
wait_timeout=7800
max_user_connections=50
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=0
innodb_purge_threads=1
innodb_support_xa=0
innodb_thread_concurrency=8
innodb_use_sys_malloc=0

How to copy files from one machine to another using ssh [duplicate]

To copy a file from B to A while logged into B:

scp /path/to/file username@a:/path/to/destination

To copy a file from B to A while logged into A:

scp username@b:/path/to/file /path/to/destination


more info visit

http://unix.stackexchange.com/questions/106480/how-to-copy-files-from-one-machine-to-another-using-ssh

TUNCATE TABLES SMTP,SEND,DEFERS,FAILURES
************************************************************************
use eximstats;TRUNCATE TABLE smtp;TRUNCATE TABLE sends;TRUNCATE TABLE defers;TRUNCATE TABLE failures;
************************************************************************
use eximstats;delete from smtp;delete from sends;delete from defers;delete from failures;
************************************************************************

use eximstats;check table sends,smtp,defers,failures;


*****************************************************************************
Remove Duplicate Email address from email_list_subscribers table 
*****************************************************************

Delete e1 FROM email_list_subscribers e1, email_list_subscribers e2 WHERE e1.emailaddress = e2.emailaddress AND e1.subscriberid > e2.subscriberid;

******************************************************************
Download Domain list from table domain wise
******************************************************************
SELECT DISTINCT DOMAINNAME FROM `email_list_subscribers` where
domainname not like ('%.com') and
domainname not like ('%.co.in')and
domainname not like('%.net')and
domainname not like ('%.net.in')and
domainname not like ('%.edu.in')and
domainname not like ('%.in')and
domainname not like ('%.org') and
domainname not like ('%.biz') and 
domainname not like ('%.co')and 
domainname not like ('%.edu')

********************************************************************
Delete Data from table domain wise
********************************************************************

DELETE FROM `email_list_subscribers` where domainname not like ('%.com') and domainname not like ('%.co.in')and domainname not like('%.net')and domainname not like ('%.net.in')and domainname not like ('%.edu.in')and domainname not like ('%.in')and domainname not like ('%.org') and domainname not like ('%.biz') and domainname not like ('%.co')and domainname not like ('%.edu')

********************************************************************

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s