Support / KnowledgeBase

Using MySQLTuner Applies to: (gs) Difficulty: Medium Time Needed: 60 Tools Required: SSH, MySQL GridContainer Applies to: All (dv) Difficulty: Medium Time Needed: 60 Tools Required: SSH, root Overview MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and mak ... Applies To: (gs), All (dv)

FAQ: PostgreSQL EOL Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: AccountCenter access, SSH Overview EOL is an acronym for End Of Life. Hosting related technology and services develop quickly and are constantly changing. Periodically, some products become antiquated or deprecated due to ... Applies To: (gs)

(gs) Backing Up Site Content Applies to: (gs) Difficulty: Medium Time Needed: 20 Tools Required: FTP, SSH Overview This list is not meant to be comprehensive, but rather more of an introduction. There are other tools available for your operating system that would work equally well. These can range from both manual ... Applies To: (gs)

Making it Better: Basic MySQL performance tuning (MySQLd) Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: AccountCenter access, phpMyAdmin access Applies to: All (dv) Difficulty: Medium Time Needed: 20 Tools Required: SSH, root, vi knowledge Introduction The following is just one simple way to get started with optimizing your ... Applies To: (gs), All (dv)

How do I generate a MySQL report? Applies to: (gs) Difficulty: Medium Time Needed: 30 Tools Required: AccountCenter access, MySQL GridContainer Applies to: All (dv) Difficulty: Medium Time Needed: 60 Tools Required: SSH, root or sudo access Overview The following will show you the steps to run a MySQL Report on your M ... Applies To: (gs)

Managing a MySQL database with phpMyAdmin Applies to: (gs) Difficulty: Medium Time Needed: 20 Tools Required: AccountCenter access, database user login Applies to: (dv) 4.0 Difficulty: Medium Time Needed: 20 Tools Required: Plesk administrator access, database user login Applies to: (dv) 3.5 Difficulty: Medium Time Needed: 20 Too ... Applies To: (dv) 3.5, (dv) 4.0, (gs)

Export and import MySQL databases Applies to: (gs) Difficulty: Medium Time Needed: 20 Tools Required: SSH Applies to: All (dv) Difficulty: Medium Time Needed: 20 Tools Required: SSH CloudTech Can Help! If you’re having trouble with the steps in this article, additional assistance is available via CloudTech, our premi ... Applies To: (gs), All (dv)

Dreamweaver - PHP/MySQL Configuration Applies to: (gs) Difficulty: Easy Time: 10 Tools needed: Dreamweaver Applies to: All (dv) Difficulty: Easy Time: 10 Tools needed: Dreamweaver Overview This article will help you configure a PHP and MySQL testing server in Dreamweaver. READ ME FIRST (mt) Media Temple does not suppor ... Applies To: (gs), All (dv)

Setting up external MySQL connections Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: AccountCenter access, SSH Applies to: All (dv) Difficulty: Easy Time Needed: 10 Tools Required: SSH Introduction When attempting to connect externally to your MySQL server through a database-management software, such as ... Applies To: (gs), All (dv)

Tunnel local MySQL server through SSH Applies to: (gs) Difficulty: Medium Time Needed: 10 Tools Required: SSH Applies to: All (dv) Difficulty: Easy Time Needed: 10 Tools Required: SSH Overview This article explains how to tunnel a MySQL connection through SSH. This is useful when you want to execute MySQL commands or deve ... Applies To: (gs), All (dv)

Why can't I connect to my MySQL database from PHP? Applies to: (gs) Difficulty: Medium Time: 30 Tools needed: AccountCenter access, FTP Applies to: All (dv) Difficulty: Medium Time: 30 Tools needed: Plesk administrator access, FTP Overview This article contains the basic information you need to connect from PHP to your MySQL database o ... Applies To: (gs), All (dv)

Create timestamped database backups Overview This article will walk you through how to create timestamped database back-up of your website on the (gs) Grid-Service. READ ME FIRST This article is provided as a courtesy. Installing, configuring, and troubleshooting third-party applications is outside the scope of support provided ... Applies To: (gs)

How do I increase the MySQL connections for my server? Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: None Applies to: (dv) 4.0 Difficulty: Medium Time Needed: 10 Tools Required: SSH, vi knowledge Applies to: (dv) 3.5 Difficulty: Medium Time Needed: 10 Tools Required: SSH, vi knowledge Overview The MySQL SmartPool v.2 ... Applies To: (dv) 3.5, (dv) 4.0, (gs)

Default MySQL character set and collation Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: None Applies to: All (dv) Difficulty: Easy Time Needed: 10 Tools Required: None Overview The default character set for MySQL at (mt) Media Temple is latin1, with a default collation of latin1_swedish_ci. This is a commo ... Applies To: (gs), All (dv)

(gs) Database naming scheme Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: AccountCenter access Introduction All new databases created on the (gs) Grid-Service follow this naming pattern: db00000_dbname Viewing databases You can view all of your database names in the AccountCenter. Log into ... Applies To: (gs)

HOWTO: Change or update various account passwords Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: AccountCenter access Applies to: (dv) 4.0 Difficulty: Easy Time Needed: 10 Tools Required: AccountCenter access, Plesk adminsitrator access Applies to: (dv) 3.5 Difficulty: Easy Time Needed: 10 Tools Required: AccountCent ... Applies To: (gs), All (dv)

How do I create a database? Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: AccountCenter access Applies to: (dv) 4.0 Difficulty: Easy Time Needed: 10 Tools Required: Plesk administrator access Applies to: (dv) 3.5 Difficulty: Easy Time Needed: 10 Tools Required: Plesk administrator access ... Applies To: (gs), All (dv)

Getting started with your MySQL GridContainer Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: AccountCenter access Overview The MySQL GridContainers are designed for customers who demand guaranteed performance and absolute reliability for their hosted database systems. For more general details on our MySQL GridCon ... Applies To: (gs)

Errors logging into phpMyAdmin Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: MySQL database user login credentials Symptoms It's not unusual to type in an incorrect username or password when logging into phpMyAdmin. However, a failed login can sometimes lead to a frustrating experience: When y ... Applies To: (gs)

Database users on the (gs) Grid-Service Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: AccountCenter access Overview This article provides instructions on how to change the password for database users on the (gs) Grid-Service. You can find more database information within your Server Guide. Database User T ... Applies To: (gs)

Edit my.cnf for MySQL GridContainer Applies to: (gs) Difficulty: Medium Time Needed: 20 Tools Required: AccountCenter access, MySQL GridContainer Overview The MySQL my.cnf editor allows you to directly edit your MySQL server's my.cnf configuration file. Editing this file can dramatically increase your MySQL performanc ... Applies To: (gs)

How do I connect to a MySQL database using Sequel Pro? Applies to: (gs) Difficulty: Easy Time Needed: 10 Tools Required: Sequel Pro Overview The following article will show you how to setup Sequel Pro to make a secure connection to your MySQL Databases. Requirements Before you start, you'll need: Your (gs) Grid-Service access domain. ... Applies To: (gs)

(gs) How do I create a database? TIP: This page has moved. Please see: How do I create a database? Applies To: (gs)