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
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...
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:...