Using (remote) MS-SQL databases with PHP on a (dv) This article has the following dependencies: If you currently do not have your root user enabled or our Developer Tools installed please visit the Root Access & Developer Tools section of your AccountCenter. Whenever installing Third-Party software please consult the official documentati ... Applies To: (dv) 2.0, (dv) 3.0

How can I Backup and Restore a MySQL database? Details METHOD 1 - PHPMyAdmin You can use PHPMyAdmin to backup/restore your database if it is relatively small (~10MBs) If your database is larger than that please skip to METHOD 2 - command line BACKUP: Select the database you'd like to back up from the column on the left Click on "Export" ... Applies To: All Service Types

Dreamweaver MX - PHP/MySQL Configuration NOTE: This article will help you configure a PHP/MySQL testing server in Macromedia Dreamweaver. Although this is Third-party software, and we do not support Third-party software configurations, we have created this article as a courtesy to our customers. DETAILS: First, create a "Site" t ... Applies To: All Service Types

Using MySQLTuner on your Dedicated-Virtual Server This guide will show you how to install MySQLTuner. This script will provide various tips for optimizing MySQL on your Dedicated-Virtual Server. This article has the following dependencies: If you currently do not have your root user enabled or our Developer Tools installed please visit the ... Applies To: All (dv)

How do I enable remote access to my PostgreSQL server? The default configuration of PostgreSQL does not allow incoming connections from external machines. This article has been mirrored from the Parallels Knowledge Base as a courtesy to our (dv) Dedicated-Virtual Server customers. As they are the authoritative source of the information covered in ... Applies To: (dpv) Nitro, (dv) 3.0, (dv) 3.5

What is the root username for MySQL? For (dv) Dedicated-Virtual Servers Plesk renames the 'root' account for mysql to 'admin'. Whenever referring to any documentation regarding MySQL's root user just consider this user 'admin' on your server. This article has been mirrored from the Parallels Knowledge Base as a courtesy to our ( ... Applies To: All (dv)

Default MySQL character set and collation DETAILS: All versions of MySQL on (mt) Media Temple server are installed with the default character set 'latin1'. The default collation for latin1 is 'latin1_swedish_ci' which in most cases does not cause any problems. If you have a (gs) Grid-Service and wish to change the character set of a M ... Applies To: All Service Types

Using MySQL Report on a Dedicated-Virtual Server The following guide will show you how to install MySQL Report on your Dedicated-Virtual Server. This report generates a large, comprehensive report that displays values for practically every MySQL statistic available. You can use this report to analyze specific areas of your MySQL usage patter ... Applies To: All (dv)