Exporting from one DB to another

I have 2 dolphin installs running. One is a test environment....the other will be my live environment. I have lots of predefined values, new profile fields, and new language keys setup in my test database. I'd hate to have to re-input them on the live install.

What tables do I have to export?

Keep in mind...I am new to mysql. I'm using MySQL admin to connect and manage my databases. I don't know yet how to export data like that.....I'm hoping when I go home to play with it that it will be apparent.     :-\

Hello pcnetguru!

If u have both DB as one Dolphin version then just switched main site to needing DB via changing next parameters in inc/header.inc.php file:

$db['host']                = 'localhost';
$db['sock']                = '';
$db['port']                = '';
$db['user']                = 'dolphin';
$db['passwd']              = '';
$db['db']                  = 'dol7';

Regard

Well the thing is, I have test accounts on my test environment. Thats why i didnt want to just copy the db over. Could i just wipe all the accounts out somehow?

Then just as admin delete all fakes profiles via admin panel.

That would work for now. But when i get real members I'll need a way to export specific tables.

Main content of profiles is stored in `Profiles` table, but in new Dolphin need to remember about tags (`sys_tags`), matching (`sys_profiles_match`), viewing (`sys_profile_views_track`), rating (`sys_profile_rating`, `sys_profile_voting_track`), messages (`sys_messages`) etc... Don't forget about infro from photos, sounds, videos, blogs and other modules...

Regard