|
|
MySQL Information |
EasyStreet runs a shared MySQL server running Versions 4.0.27 and 5.0.27 of MySQL. The system generates a single MySQL username for you when you add the first MySQL database to your account. Multiple MySQL users with different permissions are not allowed on this server.
If you need a different version of MySQL, or need multiple database users with varying permissions, call 503-646-8400 during business hours to talk to your account manager about pricing for a Linux Managed Server or about our Colocation options.
Value and higher Unix hosting accounts come with the Database Manager control panel which allows customers to enable up to two MySQL databases on our shared MySQL server. After two databases have been added, addtional MySQL databases must be installed by an EasyStreet engineer with a setup fee of $99. When more than two databases are installed, Database Manager will no longer work; customers must use either the command line Unix mysql utility or a graphical database client such as phpMyAdmin to manage their databases.
EasyStreet offers limited support for MySQL. We assume that your web site developer has the necessary expertise in MySQL to work independently. We can show your web developer how to create a MySQL database on this system and provide the settings needed to connect to that datatabase. However, once we have confirmed that the database exists and we can connect to it, we cannot offer further support beyond what is contained in this documentation.
MySQL4 Hostname: sql.hosting.easystreet.com
MySQL5 Hostname: sql5.hosting.easystreet.com
Username: domaincomXXXXXX
Password: replace with the password you created
Database Name: www_domain_com replace with actual database name
Notes:
If you are having trouble with your password, make sure that the one you have chosen is under 13 characters and not the same as your webOS/FTP password.
You can connect to your hosted mySQL database remotely, but must use the new username format (domaincomXXXXXX). The old username format (dbm.domaincom.com) will not work from remote connections. For future compatability, we encourage you to begin modifying your code to utilize the new username format.
If you are using MySQL5, you will need to replace the hostnames in the commands found in the following sections with the MySQL5 hostname. If you are not sure if you are using MySQL4 or MySQL5, you can view that information by selecting your DB username in the Database Manager in WebOS.
mysql -h sql.hosting.easystreet.com -u domaincomXXXXXX -p use www_domain_com;
mysql -h sql5.hosting.easystreet.com -u domaincomXXXXXX -p use www_domain_com;
phpMyAdmin is a popular open source application for managing MySQL databases.
Configuring phpMyAdmin explains the settings needed in the config.inc.php file to make phpMyAdmin work in EasyStreet's Environment.Create a mysql dump from your database hosted by your other provider to create a text file with all the steps necessary to recreate your tables and data. Once you have the dump file named databasenamebackup.sql (replace with actual database backup file name), you can restore from it by following the mysqlsdump restoration instructions.
Database Manager should be used to change your database password or to create and drop databases Once the databases have been created, you should use something other than Database Manager to popluate your databases with tables and data. Popular options include:
Yes, you can connect from off site. However, you must specify the database name that you are connecting to. The show databases mysql command is not allowed on this server.
Maintaining a regular backup of your database is your responsibility.
The mysqldump utility is not available from the Unix shell account associated with your hosting account. However, if you have access to command line Unix on another system/server, you can use mysqldump from off site to create a backup of your database. Below are the settings you would use to backup a database named www_domain_com to a file named databasenamebackup.sql. Be sure to replace domaincomXXXXXX with your actual database username. Also replace www_domain_com with your actual database name:
mysqldump -h sql.hosting.easystreet.com -u domaincomXXXXXX -p www_domain_com > databasenamebackup.sql
mysqldump -h sql5.hosting.easystreet.com -u domaincomXXXXXX -p www_domain_com > databasenamebackup.sql
To restore the data you've backed up via a mysqldump command follow the following steps:
Use Database Manager to ensure that there is an empty database with the name of the database you are restoring.
Upload the file databasenamebackup.sql (replace with actual name of database)
to your hosting account in the top level directory.
Assuming you have enabled ssh access, connect via SSH to your hosting account and use the following mysql command. Replace domaincomXXXXXX with your actual database username. Replace www_domain_com with the actual database name. Replace databasenamebackup.sql with the name of your backup file for this database:
mysql -h sql.hosting.easystreet.com -u domaincomXXXXXX -p www_domain_com < databasenamebackup.sql
mysql -h sql5.hosting.easystreet.com -u domaincomXXXXXX -p www_domain_com < databasenamebackup.sql
If you have already installed phpMyAdmin, the export tab allows you to create a SQL dump. Once you have the dump file, you can restore from it by following the mysqlsdump restoration instructions.
Copyright © 2004-2008 EasyStreet Online Services, Inc. All rights reserved.
EasyStreet and the EasyStreet logo are registered trademarks of EasyStreet Online Services. Certain other names, logos, designs, titles, words or phrases on this site may constitute trademarks, servicemarks or tradenames of EasyStreet or other entities which may be registered in certain jurisdictions.