Using WordPress Multisite to manage multiple projects?

Export/Import like you would the data for any other WordPress install:

On the development site:

  1. Dashboard -> Tools -> Export -> All Content (save file)
  2. Package up the Theme files as “theme-name.zip”
  3. Make note of any custom settings

On the live site:

  1. Install the custom Theme
  2. `Dashboard -> Tools -> Import -> WordPress data file (upload file)
  3. Change any custom settings noted above

EDIT:

If you still want to try a database export, you could try network-enabling one of the many database-backup Plugins in the repository, such as WP-DBmanager, and running it from your dev site.