Extract Table from SQL Dump – MYSQL The script below creates individual table exports from a SQL dump. ./MyDumpSplitter.sh yourfile.sql your_table_name [code] #!/bin/sh # http://kedar.nitty-witty.com #SPLIT DUMP FILE INTO INDIVIDUAL TABLE DUMPS # Text color variables txtund=$(tput sgr 0 1) # Underline txtbld=$(tput bold) # Bold txtred=$(tput setaf 1) # Red txtgrn=$(tput setaf 2) # […]
MYSQL Event Scheduler – Auto Enable If you are finding the MYSQL event scheduler is disabled everytime you start MYSQL, use the following my.cnf or mysql.ini settings; event_scheduler=on That Simple!!
Comparison of the network types Type Bridged NAT (Network Address Translation) Host-only Description The VM appears as if it was a physical host on the network. The VMware hides behind the IP address of the VMware host. Other VMs in the same NAT network can access it directly. The VM can only access the VMware […]
Ubuntu – IPtables – redirect port to different IP Read IP tables; iptables -t nat -L -n -v For redirecting port to different IP and port echo “1” > /proc/sys/net/ipv4/ip_forward Then, we will add a rule telling to forward the traffic on port 1111 to ip 2.2.2.2 on port 1111: # iptables -t […]
Outlook Crash – IMAP 0xc0000005 – ISPCONFIG Outlook was crashing on startup every time it synced IMAP folders, not a problem in Thunderbird. This is my fix; Removing the empty first empty line from the files subscriptions and courierimapsubscribed fixes it in /var/vmail/MAILBOX/Maildir/
A number of JQUERY plugins can throw up syntax errors after setting setlocale(“LC_ALL”,XXX.utf8) Make sure you change back the LC_NUMERIC variable; setlocale (LC_ALL, $language); setlocale(LC_NUMERIC, ‘C’);
Opt out of BT FON – BT Openzone BT may activate your BT home hub to automatically become a BT openzone public hub!! Little do most people know that when you sign up to BT you are automatically opted IN to this service!!! Yes annoying. You can opt out … this link worked for me: […]
Hold down the ALT key and type the numbers next to the character you need. German / deutsch Portuguese / português ä 132 Ä 142 à 133 À 0192 ö 148 Ö 153 á 0225 Á 0193 ü 129 Ü 154 â 131 Â 0194 ß 0223 ã 0227 Ã 0195 € […]
Automatically find and re-attach to a detached screen session SCREEN -RR OR SCREEN -X SCREEN -R ……
Extract CREATES from SQL dump If you are trying to extract the create routines from a SQL dump, this might help you! Basically it picks out the contents between “CREATE” and “\;” You can modify these two variables as need be.. [bash] cat dump.sql |awk ‘/CREATE/,/\;/ { print $0 ; }’ > create.sql […]