To export a Drupal database from localhost to a production server, here’s what you will need to do:
1. Log in to phpmyadmin and select the database you wish to export.
2. Clear all tables starting with ‘cache_’ or ‘<prefix>_cache_’.
3. Export database in SQL format
4. Import the SQL data to your web sever