database
Postgresql Backup Script – Quick and Simple
Root uses psql to list all databases and then looping through each one, root uses pg_dump as postgres piped into pbzip2 which is a parallel implementation of bzip. Any new databases will be picked up by the script each time it is run.
Resolved: Mediawiki Undefined property: DatabaseMysql mTrxDoneWrites
If you’ve recently upgraded to MediaWiki 1.20 or later and you use MySQL you may see a mediawiki undefined property PHP Notice filling up your web server’s error log. I don’t like it filling my logs. Off with it’s head!
Upgrade or migrate your OpenLDAP database with slapcat and slapadd
Backing up an OpenLDAP installation is a very easy and non-intrusive process. You can backup the database while the old slapd is running using slapcat, so there’s no need for interruption while setting up the new instance. In my example, I will not backup individual databases with -n switch. I want the whole thing in one giant ldif because i’m going to restore the whole thing at once too. Keep it simple.
How to rename a subversion repository
While you could just rename the base directory that contains the repository itself, your historical information would be broken. To rename the repository without breaking any of the history of that repo, simply dump it and reload it to the new repository.
Installing Pylons and BlastOff – YUM alternative to easy-install
The Pylons web framework is aimed at making webapps and large programmatic website development in Python easy. Pylons combines the very best ideas from the worlds of Ruby, Python and Perl, providing a structured but extremely flexible Python web framework. BlastOff is a Pylons application template providing a working site skeleton configured with SQLAlchemy, mako, repoze.who, ToscaWidgets, TurboMail, and WebFlash.
ATI fglrx driver – fix corrupt amdpcsdb
ATI allows xorg.conf to have the normal customized settings you’re used to for X, but it relies on this little PCS database at /etc/ati/amdpcsdb for driver configuration. If you have a customized amdpcsdb, or a binary installation from your favorite package manager is screwing up your X when using the fglrx driver, try reverting back to the default ATI settings.
Securing MySQL Server is Easy
The default out-of-the-box installation should delete any additional anonymous users after installation and disallow remote logins completely, but it doesn’t. At least all you have to do is run the mysql_secure_installation script to do so.