Importing a database

When moving a website to Dirham A Day, you often need to import a database export (a .sql file). Here is how:

1. First create an empty database and user in MySQL Databases and grant All Privileges.
2. Open phpMyAdmin and click your new database on the left.
3. Go to the Import tab.
4. Click Choose File, select your .sql (or .sql.gz) file, leave the format as SQL, and click Import.

For large files that exceed the phpMyAdmin upload limit:

• Compress the file to .sql.gz first - it uploads faster and phpMyAdmin can read it directly.
• Or upload the .sql file via FTP and import it through the command line if you have SSH access.
• Or open a ticket and we can import very large databases for you.

After importing a WordPress site, update the wp-config.php file with the new database name, user and password, and check the siteurl value. If the import fails partway, drop the tables and try again with a fresh export. We are happy to help - reach support 24/7 on WhatsApp +971 58 553 6767.