Why do I need this? In mysql 5.5 the RENAME DATABASE functionality went away, but the manual does show that RENAME TABLE works: RENAME TABLE current_db.tbl_name TO other_db.tbl_name; While is is good, it’s a pain when there lots of tables, and leaves lots of room for typos and human error. …
There are times when I need to use my netbook and desktop together. I’ve used a KVM setup, but sometimes I want to offload some of my screen space on to the netbook, then it gets annoying. There is a great solution for this called x2vnc This makes the netbook …
Recently I had an issue where a site was restricting itself to a single IPv4 address, unfortunately the server that hosted it also supported IPv6, but the IPv6 on the server was misconfigured. This caused Firefox to error out if it used IPv6 or work if it used IPv4. I …
Recently I had a problem where an InnoDB table was corrupted. It was reporting a 2013 error and actually dropping all the connections to the database. This was all that was being reported: mysql> select * from corrupted_table; ERROR 2013 (HY000): Lost connection to MySQL server during query The logs …
I have a ssh shortcut I use a lot, and I made a script for it. It got annoying to open a terminal, then run my script. I added it to my ubuntu panel by using a custom appliction launcher then use this as the command to run: gnome-terminal -x …