You can easily manage and restore your MySQL databases online using phpMyAdmin, which is fully integrated into your TrexHost Control Panel. This tool allows you to access, export, and import databases quickly and securely, making database management simple and reliable.
Accessing phpMyAdmin
To open phpMyAdmin for your database:
- Log in to your TrexHost Control Panel and go to Databases > MySQL Databases.
- Locate your database in the list and click the phpMyAdmin icon next to it.
- A new window will open with the phpMyAdmin home screen.
- In the left-hand panel, click your database name to select it.
In the top-right panel, you will see several icons. Click the SQL icon (usually the second one) to open the query window.
Importing Your Database Backup (Dump File)
To restore a database from a backup:
- Click the Import Files tab in the query window.
- Press the Choose… button and select the backup file from your local computer.
- Click Go to start importing the database.
Important: Using this method, you can import dump files up to 20MB in size. For larger files:
- Upload the file to your TrexHost hosting account via FTP (see our guide: How to Upload or Download Your Website Files via FTP with TrexHost).
- Submit a support ticket in your TrexHost Control Panel, and our technicians will assist you with importing the file.
Why Use TrexHost for MySQL Database Management
With TrexHost, restoring and managing MySQL databases is simple, secure, and reliable. Our hosting services offer:
- Full MySQL and phpMyAdmin support for easy database access.
- High-performance servers to ensure smooth website and application operation.
- Expert technical support to assist with database imports, backups, and troubleshooting.
Start hosting with TrexHost today and enjoy hassle-free MySQL database management, giving you complete control over your website and applications.