Results 1 to 8 of 8
  1. #1
    Join Date
    Jun 2001
    Location
    New Orleans, LA
    Posts
    261

    Question restoring a database with no .sql file?

    My former host made back-ups with all of the database files in a folder, but no .sql file. How do I turn a folder of MYI and MYD files into a restored database?

    I searched the topic, but the answers were for .sql files.

    Any help would be appreciated.

  2. #2
    I did the same whilst moving servers recently as it seemed (and was) quicker than mysql - mysqldump. Was quite simple really (and this is assuming you have root access).

    # cd /var/lib/
    # wget http://www.oldserver.com/mysqlfile.tar.gz or .zip
    # tar zxvf mysqlfile.tar.gz or unzip mysqlfile.zip
    # mv mysql mysql_old
    # mv mysqlfile mysql
    # cp mysql_old/mysql.sock mysql/

    It worked for me and might be a good template to base everything off. Do remember to backup though (moving the old mysql folder instead of removing, etc.). If you don't have root access you could always ask your host but otherwise, sorry. You could always download a linux distro, install mysql, and do it through that generating a .sql dump through mysqldump? I'm quite stumpted if you have no root access.

    Best of luck.

  3. #3
    Join Date
    Jun 2001
    Location
    New Orleans, LA
    Posts
    261
    thanks for the quick response...

    so you did all of this via telnet?

  4. #4
    Join Date
    Jan 2003
    Posts
    1,715
    Probably ssh, but same deal, yeah. I don't recommend root over telnet -- give me something encrypted.
    Game Servers are the next hot market!
    Slim margins, heavy support, fickle customers, and moronic suppliers!
    Start your own today!

  5. #5
    Yep through SSH / shell. As above, I would never use Telnet - or never have done. Let me know if you have any problems (or I could help you out for a small fee $$).

    Thanks.

  6. #6
    Join Date
    Jun 2001
    Location
    New Orleans, LA
    Posts
    261
    how do I browse from the root to see where the files go? I have root acess but it's not working for ftp access.

  7. #7
    Join Date
    Jun 2001
    Location
    New Orleans, LA
    Posts
    261
    Bizarre you've been an incredible help on AIM.

    I can't thank you enough.

  8. #8
    No probs. Glad to be of assistance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •