MySQL Database Server FAQ

Yes, it is safe to upgrade your MySQL. Since InterWorx Control Panel runs its own instance of MySQL, it will not interfere with the functioning of the CP.

PLEASE NOTE that upgrading to MySQL 5 is considered experimental and may cause issues with InterWorx communicating with the MySQL server and thus not being able to administer it properly (or at all).

Testing of this configuration is planned. Please visit the InterWorx forums for more info.

Your MySQL databases are located in /var/lib/mysql

No, you will encounter problems with restoring your databases if you do this. Or, to put it bluntly, "things will break."

For example, your old host has MySQL 4.1 and the InterWorx box has 3.3 (the default), it will not work correctly because MySQL 4 has some differences in the table format that 3.x won't understand.

If this is the case you should download the InterWorx-provided MySQL 4.1 RPM from the http://updates.interworx.info/iworx/ site or do a source based update before trying to import your site.
The same goes for the experimental MySQL 5.

Yes, going from MySQL 3 to MySQL 4 should be fine (though there have been some bugs here which have -- hopefully -- been squashed).

MySQL 5 has not been tested.

MySQL 3.x and 4.x -- Whatever comes standard with your Linux distro

MySQL 5.x is still considered experimental and has not been tested. Update at your own risk.

That depends on your configuration:

open

/home/interworx/iworx.ini

and search for the line

partition=

your databases are stored in

/var/lib/mysql

If

partition="/"

then yes they are included.

If it reads any of the following

partition="/chooot"
partition="/home"
partition="/var"

Then your databases are outside of that and not included in the quota.

If you split MySQL storage and web content storage onto 2 physical disk partitions then there is no way to track both under the account's storage umbrella.

It is possible that server administrators get customers with huge databases, but stay under the disk quota specified in NodeWorx due to small web and email content. There is no supported way around this. The best option we've seen is to copy your /var/lib/mysql to /home and then symlink from /var/lib/mysql ⇒ /home/mysql (for example). Quotas are partition-based so symlinks across partitions won't fix the issue; the files must be physically moved.

Since phpMyAdmin, Horde webmail, Squirrelmail webmail, and InterWorx all run on the same port, you will need to change the port for all of these to get phpMyAdmin to work on the port you want.

This is not recommended.