How To IMPORT MySQL TABLES backup to PHPmyAdmin

Discussion in 'WordPress' started by sagarrai000, Dec 17, 2010.

  1. #1
    Well last week my server was crashed and my host support team did the backup themselves. They did 2 copies of backup. One folder had the Wordpress files backup and another folder had all the "mysql tables" backup in the format .opt, .frm, .myd, .myi [I was expecting .sql file backup instead] but these people did the backup of TABLES.

    I restored my wordpress files but I'm unable to restore these .opt, .frm, .myd, .myi. I have no idea where to upload these files. Also there on phpmyadmin there is no option to IMPORT these kind of files.

    Is there any easy way restoring. Please suggest

    Well I forgot to say that right now my site is giving an error too

    Warning: require(/home/active10/public_html/alltechgulf.com/wp-includes/functions.php) [function.require]: failed to open stream: No such file or directory in /home/active10/public_html/alltechgulf.com/wp-settings.php on line 67

    Fatal error: require() [function.require]: Failed opening required '/home/active10/public_html/alltechgulf.com/wp-includes/functions.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/active10/public_html/alltechgulf.com/wp-settings.php on line 67


    Well I think this might be resolved once the mysql is restored so can anyone tell me how to restore.
     
    sagarrai000, Dec 17, 2010 IP
  2. wpfan

    wpfan Member

    Messages:
    64
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    31
    #2
    Hmmm is there an option in your cpanel to import the file? Otherwise best bet ask your hosts.
     
    wpfan, Dec 17, 2010 IP
  3. sagarrai000

    sagarrai000 Peon

    Messages:
    1,475
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Like others I have option to IMPORT , EXPORT... I know how to import .sql file but never seen such kind of files.
     
    sagarrai000, Dec 17, 2010 IP