Tag: mysql

xenForo Test Site Set Up

Posted by – February 2, 2011

I bought a copy of xenForo when it first went on sale. I had it setup on my test server. During my server upgrades and general network maintenance window I upgraded the test server and took the old one offline. I moved the test site to one of the production server. That didn’t go well.

xenForo would not run. 500 errors for everything I did. I tried to upgrade it to xenForo RC 1 and while the installer recognized the xenForo database it didn’t give an option to upgrade. I could only do a clean install.

More

Quick Tip: Adding mySQL and PHP to Your Windows Path

Posted by – January 25, 2008

Here is a quick tip showing you how to add mySQL and PHP to your Windows Server path. Many people ask how to do this and while it is included in the Installing mySQL and Installing PHP tutorials I thought I would make it easier for everyone to get the information.

Lets get to it.
More

Batch File to Backup Your Windows Server Database

Posted by – January 22, 2008

If you read Backing up Your Data with cwRsync and snyc2nas you learned how to send your data to an off site server. Now I’ll show you a couple ways to make incremental and dated zipped backups that you can store on your server to transfer with sync2nas or FTP the backup to your home box.

I’ll attach the batch files at the end of the post for those that don’t want to copy and paste the code. Now lets get started.

More

MySQL Server Privilege Escalation And Denial Of Service Vulnerabilities

Posted by – January 20, 2008

Found this at SecurityFocus. MySQL is vulnerable to a couple new exploits.

MySQL is prone to multiple vulnerabilities, including privilege-escalation and denial-of-service issues.

Exploiting the privilege-escalation vulnerability may allow attackers to perform certain actions with elevated privileges. Successful exploits of the denial-of-service issue will cause the database server to crash, denying service to legitimate users.

These issues affect versions prior to MySQL 5.0.52, MySQL 5.1.23, and MySQL 6.0.4.

To exploit these issues, attackers can use standard database client software in conjunction with standard operating system utilities.

Solution:
The vendor released updates to address these issues. Please see the references for more information.
Note that MySQL 6.0.4 and 5.1.23 have not been released yet.

Upgrading PHP and MYSQL on Windows

Posted by – February 4, 2006

This article will explain the easy way to upgrade PHP and MYSQL on Windows Servers. Easy if you followed my installing PHP and instaling MYSQL tutorials.

If you follow this procedure you can have PHP and MYSQL upgraded in less than an hour.

Of course that doesn’t include the time it takes to download PHP and MYSQL. I will assume you have them downloaded. Lets get started. We’ll upgrade MYSQL first.

More