← Back to Knowledgebase

Managing MySQL Databases

How to access phpMyAdmin and manage your database tables directly.

---

Accessing phpMyAdmin

1. Log in to the RYN Host Panel.
2. Go to the "Databases" tab.
3. Click the "Eye" icon (or "Manage") next to your database.
4. Click the "phpMyAdmin" button. This will open a new tab and log you in automatically.

Common Tasks

Exporting a Database (Backup)

1. Select your database from the left sidebar.
2. Click the "Export" tab at the top.
3. Keep the format as SQL.
4. Click "Go" (or "Export"). This will download a .sql file to your computer.

Importing a Database

1. Select your database from the left sidebar.
2. Warning: Importing will overwrite existing tables with the same name.
3. Click the "Import" tab at the top.
4. Click "Choose File" and select your .sql backup.
5. Click "Go" (or "Import") at the bottom.

Deleting Data (Truncate/Drop)

• Drop: Deletes the table and all its data completely.
• Truncate: Deletes all data inside the table but keeps the empty table structure.

Be extremely careful with these operations. There is no "Undo" button in databases!