If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Pervasive.SQL > recreate DB from .mkd and .ddf files?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-07-08, 17:53
normwheatley normwheatley is offline
Registered User
 
Join Date: May 2004
Posts: 4
recreate DB from .mkd and .ddf files?

Hi,

I have a bunch of .mkd and .ddf files that represent a backup or dump of a database. I have been asked to re-create the Pervasive database (so I can work on it and the apps that go along with it).

Do you know how I can re-create the database. Pervasive has an export Db function (makes .sdf files) but no import.

thanks very much for your help
Norm
Reply With Quote
  #2 (permalink)  
Old 05-07-08, 18:57
mirtheil mirtheil is offline
Registered User
 
Join Date: Dec 2001
Posts: 1,026
You should be able to just create the Pervasive Database Name using the Pervasive Control Center. Right click on the engine name (machine name where the engine is running) and select New Database (I think).
__________________
Mirtheil Software
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.
Reply With Quote
  #3 (permalink)  
Old 05-07-08, 20:15
normwheatley normwheatley is offline
Registered User
 
Join Date: May 2004
Posts: 4
answer

sure. I can make any database I want through the PCC but how do I associate the .mkd amd .ddf files with the database.
I made a database with the correct name and a dummy table then I copied the .mkd and .ddf files to the location where dummy table was, bounced all the Pervasive services and went back into the PCC. The database just had the dummy table in it.

How does one associate (ie import) the .mkd and .ddf files?

ta
Norm
I
Reply With Quote
  #4 (permalink)  
Old 05-07-08, 20:42
normwheatley normwheatley is offline
Registered User
 
Join Date: May 2004
Posts: 4
answer

Hi,
I think I've figured it out. I created the new database then shut down PSQL. I then moved the new .ddf and .mkd files out and copied in the ones I'd been given from the previous database. I then restarted PSQL and voila, the tables from the good database are imported. Kinda clunky but I hope the apps work now.

thanks
Norm
Reply With Quote
  #5 (permalink)  
Old 05-07-08, 21:21
mirtheil mirtheil is offline
Registered User
 
Join Date: Dec 2001
Posts: 1,026
Actually when you create the database name, you can (and should) point to the directory where the DDFs and MKDs reside. You don't need to create a DatabaseName, a dummy table, and then copy the files over them. Just put your DDFs and MKDs in a directory and point to that directory when creating the Database Name.
__________________
Mirtheil Software
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On