Archive for MySQL

You are browsing the archives of MySQL.

Get An Email List Out of Your osCommerce Database

I’ve found it necessary to get an email list out of a few osCommerce stores so that I can export that data to a mailing house.
Please note that this SQL doesn’t look at the customer’s newsletter selection – our external company handles whether or not they wish to receive e-mail from us. So you may [...]

Request Tracker 3.8.0 vs. MXWest

This was an upgrade – well, no, upgrade and move (to another server) – that actually went fairly well. I was able to download the latest version, and export my “old” (RT 3.4.x) database, re-import and upgrade it.
The trick, it seemed, was to use mysqldump instead of phpMyAdmin. Oh, that and also to do increase [...]