Media Temple Tips
Here are a few Media Temple (mt) tips that I’ve collected over the years.
1. Quick Access to phpMyAdmin
Use this URL to directly access phpMyAdmin without logging in through Media Temple’s AccountCenter. Be sure to replace ##### with your site number.
https://s#####.gridserver.com/.tools/phpMyAdmin/index.php
2. Backing Up MySQL Databases
This method works regardless of the size of your database. You must have SSH enabled for the serveradmin user.
1. Log into your server via SSH and cd into a directory where you have write access such as:
cd /home/s#####/domains/mt-example.com/html/ |
2. Enter the following command:
mysqldump --add-drop-table -h internal-db.s#####.gridserver.com -u username -p dbname > dbname.sql |
* Replace ‘username’ with your MySQL username.
* Replace ‘db#####’ with the name of the database to be backed up.
* Replace dbname.sql with what you’d like to name the backup file.
3. Enter your MySQL password at the prompt. If you do not know your password you can reset it in your AccountCenter.
3. Find out your Cluster and Storage Segment
Each (gs) grid-service resides on one of Media Temple’s clusters and each cluster is divided into individual storage segments. Although the cluster is the permanent home for your (gs) grid-service, while the storage segment is subject to change. Due to grid server system maintenance, it’s important to know which cluster and storage cluster your (gs) grid-service is using so you’ll know whether your grid-service will be affected.
System status: http://status.mediatemple.net
To find your grid-service’s grid cluster and storage segment, you can use either of the following URLs to find this information as well.
http://s#####.gridserver.com/gs-bin/gridinfo
http://yourdomain.com/gs-bin/gridinfo
Be sure to replace ##### with your site number, or replace yourdomain.com with your domain.