Have problem, need advice, mysql

Discussion in 'Databases' started by Malik67, Sep 16, 2009.

  1. #1
    Hi, I have a old website years ago which I lost database, tables, all of it. I do have all php files for the website. Is it possable to have the tables/database reconstructed from php files?

    I do not care about the data I lost, just want to recreate database.

    archive.org has the site, between 1/02 and 2/03 are good. After 2/03 it was down. http://www.dailymegajoke.com


    Any advice would be helpfull. thx
     
    Malik67, Sep 16, 2009 IP
  2. titanium1357

    titanium1357 Peon

    Messages:
    8
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    When you install a dynamic website, it have a .sql file, this file contains all table for your database.
    If you want to reconstruct all your tables , you should import this file to your database.
    You can use phpMyAdmin in your hosting to do this.
    Regard.
     
    titanium1357, Sep 16, 2009 IP
  3. Digital Linx

    Digital Linx Peon

    Messages:
    74
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #3
    It's possible, however it would take careful analyzing of the .php files. If you used some pre-made script for your site then just redownload, like titanium1357 said there must be a .sql file which you can import, if it's custom you're looking at elbow sweet for a week at least depending on the size/number of tables in the database.
     
    Digital Linx, Sep 16, 2009 IP
  4. Malik67

    Malik67 Active Member

    Messages:
    56
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    91
    #4
    No sql file... Can't import what I do not have...
     
    Malik67, Sep 16, 2009 IP
  5. Malik67

    Malik67 Active Member

    Messages:
    56
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    91
    #5
    number of tables and size, huge. I was told one time in 2003 by original programmer he would not do it. It would be best to redesign site and move on. Today I talked with him, and he said yes it is possable to do it, but you need someone with considerable experence., scripts are complicated.
     
    Malik67, Sep 16, 2009 IP
  6. FreeCashTube

    FreeCashTube Peon

    Messages:
    378
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #6
    few options you can look at....

    original php file, was it something you wrote? bought? got for free? there should be a install file which create the database for you.

    You need to examine to the php files to understand what fields and what databases are used within the php and then re-create them
     
    FreeCashTube, Sep 16, 2009 IP
  7. unitechy

    unitechy Peon

    Messages:
    350
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Actually you can reconstruct the mysql database, but it will need study of your php files.
    hire an experienced PHP programmer. I am sure it can be done.
    All the best
     
    unitechy, Sep 17, 2009 IP