Managing multiple databases

Running several applications - perhaps a WordPress site, a separate shop and a custom app - is easy when you give each its own database. Keeping them separate makes backups, restores and troubleshooting far simpler.

To add another database, open MySQL Databases in the DirhamHost panel and repeat the create-database and create-user steps for each application. Use clear, descriptive names:

• dad1234_mainsite
• dad1234_shop
• dad1234_crm

Best practices:

• One user per database where possible - if one app is compromised, the others stay protected.
• Keep a note of which application uses which database and user.
• Back up each database individually via phpMyAdmin so you can restore one without touching the others.

All your databases share your account's disk space and inode allowance, so periodically clean up ones you no longer use - select the database in MySQL Databases and delete it (export a backup first). If you manage many sites and are outgrowing shared hosting, a VPS gives you dedicated resources and full database control. To review your current databases and their sizes, open phpMyAdmin. Questions on structuring multiple sites? Contact support@dirhamaday.ae.