2. PHPRunner General questions
  3. Can I recover database from phprunner project file
This topic is locked

Can I recover database from phprunner project file

 		12/17/2013 3:31:45 PM
PHPRunner General questions
T
 Tayyab Ilyas author

Hi,

My local system get crashed yesterday i lost my all databases on that machine. I have my phprunner project files, is there a way i can restore my database (which were used in phprunner applications) through phprunner projects files.

Regards
Sergey Kornilov admin 12/17/2013

Open project file (.phpr) in any text editor and find <databaseinfo> node. It contains info about all project tables.
You will have to re-create all those tables manually based on this info.

<databaseinfo>

<dbtables>

<v>

<schema />

<name>mail_messages</name>

<type>0</type>

<dbfields>

<dbfield>

<name>id</name>

<type>3</type>

<typeName>int</typeName>

<size>10</size>

<scale>0</scale>

<defaultValue />

<nullable>0</nullable>

<autoInc>1</autoInc>

<charset />

<enumValues />

</dbfield>

<dbfield>

<name>created</name>

<type>135</type>

<typeName>datetime</typeName>

<size>0</size>

<scale>0</scale>

<defaultValue>0000-00-00 00:00:00</defaultValue>

<nullable>0</nullable>

<autoInc>0</autoInc>

<charset />

<enumValues />

</dbfield>