General

• MySQL overview
• phpMyAdmin overview
• Finding your database login credentials

Backing Up / Importing / Migrating / Restoring

• Database backup overview
• How do I migrate my database to DreamHost?
• Restore a database in the panel
• phpMyAdmin — How to backup or export a database or table
• phpMyAdmin — How to import a database or table
• SSH — Backing up your database

See all 7 articles

Connecting to MySQL Databases

• Access a database before pointing DNS to DreamHost
• Connect to a database via SSH
• Connecting to a database using MySQL Workbench
• Using SQLyog to connect to your database

Managing Databases

• Creating a MySQL database
• Adding and deleting a database user
• Dropping or deleting a database
• Managing MySQL users, allowable hosts, and privileges
• MySQL limitations due to shared hosting
• Changing the collation of your database

MySQL VPS (private server)

• MySQL VPS overview
• Add or delete a MySQL VPS

Troubleshooting / Optimization

• Using reserved words in MySQL 8
• Error establishing a database connection
• Troubleshooting your MySQL database
• Optimize a database
• Troubleshooting database import errors
• Viewing your database logs

Alternative databases

• SQLite
• Installing a custom version of SQLite3
• PostgreSQL