Snipplr

(Bash) File per Table - Leech

Wed, 06 Aug 2008 16:58:33 GMT

Exports all tables in a given DB one per file.

(Bash) Securely access (e.g. firewall filtered) remote services through ssh tunnel - iblis

Wed, 09 Jul 2008 13:48:32 GMT

1. Allows encryption between client and server 2. Bypasses filtered port, if any on the standard port for the given service.

(Bash) Install mySQL gem on a fink (vs self made) mySQL installation - iblis

Wed, 09 Jul 2008 10:51:20 GMT

When installing mysql and mysql-dev with fink, gem is unable to find the mysql headers and libraries: you should specify their location. If compiled manually from source, gem will find it if /usr/local/mysql (or what ever other location you specified at compilation time) is in your path.

(Bash) Remove all tables with a certain pattern from the database - berkes

Mon, 04 Feb 2008 04:18:22 GMT

This script removes (DROPS) all tables that start with foo_. Usefull if you had some CMS or application that (ab)uses table prefixing, and want to clean 0ut your database. NOTE: the data is remove FOREVER! So take good casre: make backups and all the likes. Try on a test-database first!

(Bash) mysql dump only data myisam to innodb and gzip - therobot

Tue, 09 Oct 2007 08:19:15 GMT

(Bash) Change password for mysql root user on debian - therobot

Tue, 09 Oct 2007 06:11:56 GMT

(Bash) Backup a remote MySQL database to your local hard disk - hyperwhat

Tue, 09 Oct 2007 00:41:54 GMT

(Bash) Install mysql gem - therobot

Thu, 04 Oct 2007 03:54:57 GMT

(Bash) Export an .sql file - hyperwhat

Wed, 26 Sep 2007 22:17:52 GMT

(Bash) Import an .sql file - hyperwhat

Tue, 25 Sep 2007 22:33:17 GMT

(Bash) MySQL dump tables like... - remysharp

Sun, 16 Sep 2007 15:34:00 GMT

(Bash) Fix MySQL Table problems - benpjohnson

Mon, 13 Aug 2007 01:13:33 GMT

Useful when your server runs out of disk space

(Bash) mysqldump2mail - miziomon

Sun, 18 Mar 2007 13:01:46 GMT

(Bash) Backup from textdrive to strongspace - sudarkoff

Fri, 01 Dec 2006 11:06:44 GMT