Tag: mysql

How to Import a Compressed MySQL Database From bz2 Format

If you have a compressed MySQL database in bz2 format that you need to import, just do the following: bunzip2 < db_filename.sql.bz2 | mysql -u root -p target_db_name

/ July 20, 2015

How to Store Two Way Encrypted Passwords (and Credit Cards) in MySQL

As part of my open source IMAP mail filtering applet, Filtered, I wrote code to securely encrypt and store email user names and passwords in a MySQL database so that they can be decrypted as well. The technique is outlined...

/ January 13, 2014

How to fix fatal error “Call to undefined function: mysql_connect()”

I thought I’d post this so people can find the answer more easily than I was able to. If you get this error when a PHP 4 page tries to connect to MySQL on Debian Sarge (testing release): Fatal error:...

/ May 29, 2005