Guyzer Posted December 16, 2008 Share Posted December 16, 2008 I had a website I made quite awhile ago, written in PHP and when I backed it up, I didn't export my database to a text file or anything. :-\ Now I'm sure I could pick through each script and be able to re-build my database tables however this will take a while and I could possible miss or misspell information and could be a long task to get the database structure back in order. And of course I didn't document the database structure in my scripts. Now my question, is there a program out there that could scan all the scripts and generate the tables and field names to help me build the new database. I'm sure I could populate the database when I can get the structure. I know this all my fault and if I spend another 30 second and exported the database I would be running my website by now. Any help would great! Thanks for your help! Guyzer Quote Link to comment Share on other sites More sharing options...
GingerRobot Posted December 16, 2008 Share Posted December 16, 2008 Not that i'm aware of. Moreover, it might not be possible. For example, if you had a query with a join and didn't explicitly declare which tables the columns in the result set were coming from, you wouldn't know which table to put them in. Also, how would you decide the types, collations, lengths etc of each field type from a bunch of SELECT/INSERT and DELETE queries? Quote Link to comment Share on other sites More sharing options...
Guyzer Posted December 17, 2008 Author Share Posted December 17, 2008 Ya, you make a good point. I figured I would have to pick through the scripts on my own to build the data base. Thanks for your input! Guyzer! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.