Database FAQs

How do I create a database?

Databases can be created in the DreamHost panel only. Databases cannot be created via SSH or phpMyAdmin. View the following article for further details:

Is there a limit to how many databases I can create?

There is no limit and you can create as many databases as you would like for any hosting service.

Do you provide long term backups for my databases?

Long term backups for databases are not available. DreamHost only provides 5 days worth of database backups and these are not guaranteed. It’s highly recommended to continually backup your databases locally.

How can I backup my databases myself?

Backing up databases can be done via Shell or phpmyadmin. Instructions can be found in the following article:

My domain is no longer pointed to your DNS or it has expired. How can I backup my database?

If you have a Shell user, you can log into your web server via SSH and perform a mysqldump. Once you’ve completed the backup, you can log into your web server via FTP to download the backup file.

How do I import my database backup?

You can do this with a Shell user via SSH or phpMyAdmin. View the following article for details:

Can I use my FTP user to access a database?

No. Domain users such as Shell, SFTP, and FTP are isolated from your database users. Additionally, database access is only available on a Dedicated server.

What available services do you have for databases?

All hosting services come with a shared MySQL server. You also have the option to upgrade to a private database server in your panel. View the following article for details:

Do I have root/sudo access to this MySQL VPS server?

No. The MySQL VPS is still a managed service so access to the server is unavailable. Only on a Dedicated server would you have access since the databases are hosted locally on that same machine.

Where can I view the MySQL logs?

Unfortunately logs are not available for shared MySQL. However, if you have upgraded to a MySQL VPS, support can retrieve the logs for you. Just submit a support ticket in your panel requesting this.

Why is my database hostname not working?

Several factors can cause this issue:

I have my domain pointed to another host's nameservers, but the domain is pointed to my DreamHost A record. Why am I not able to access the database via phpMyAdmin?

There is a DNS A record for the actual database hostname in addition to the site’s A records. Just like the domain, you must add that A record as well for the database hostname to work. View the DNS article for details.

Can I update the MySQL version?

No.

Do database users have all privileges on the database?

Not all privileges are available. View the following article for a current list:

Can I provide limited access to other users to my database?

Yes. You can create multiple users to access the database and set their privileges. View the following article for details:

Can I access my database via IP?

No. You cannot use the IP as an alternative to the hostname.

 

See also

Did this article answer your questions?

Article last updated .