How to mysqldump specific tables?

This solution is from stackexchange.com- http://dba.stackexchange.com/questions/9306/how-do-you-mysqldump-specific-tables DBTODUMP=mydb SQL=”SET group_concat_max_len = 10240;” SQL=”${SQL} SELECT GROUP_CONCAT(table_name separator ‘ ‘)” SQL=”${SQL} FROM information_schema.tables WHERE table_schema=’${DBTODUMP}’” SQL=”${SQL} AND table_name NOT IN (‘t1′,’t2′,’t3’)” TBLIST=`mysql -u… -p… -AN -e”${SQL}”` mysqldump -u… -p… ${DBTODUMP} ${TBLIST} > mydb_tables.sql 0

Read More »

Virtualhost code in Apache

<VirtualHost www.website.com:80> ServerAdmin root@localhost DocumentRoot /var/www/website/www_website_com/ ServerName www.website.com ServerAlias www.website.com ErrorLog /var/www/website/logs/www.website.com.error_log CustomLog /var/www/website/logs/www.website.com.access_log common <Directory /var/www/website/www_website_com/> AllowOverride All Order allow,deny Allow from all Require all granted </Directory> </VirtualHost> 0

Read More »

Alias code in Apache

If you want to add alias in apache, place this code in apache.conf or httpd.conf (depending on your OS) Alias /alias_name/ “/var/www/alias_dir/” <Directory “/var/www/alias_dir”> Options Indexes MultiViews FollowSymLinks AllowOverride None Order allow,deny Allow from all </Directory> 0

Read More »