+ Post New Thread
Results 1 to 5 of 5
Virtual Learning Platforms Thread, MySQL Restore in Technical; Hi - we have had a server with our Moodle go down.. and our backup wasn't the greatest! We have ...
  1. #1
    Optimus's Avatar
    Join Date
    Aug 2005
    Posts
    35
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    MySQL Restore

    Hi - we have had a server with our Moodle go down.. and our backup wasn't the greatest! We have never scripted a MySQL dump file...

    Is it possible to restore the Moodle database by copying over the MySQL data folder - when we do this - the MySQL service fails to start. If we put in just the MySQL \ Data \ moodle folder - MySQL service starts - but we can't see the tables in PHPmyAdmin,

    Any help appreciated!!

  2. #2


    Join Date
    May 2009
    Posts
    3,119
    Thank Post
    275
    Thanked 837 Times in 629 Posts
    Rep Power
    332
    I think it should be. When you copied data the folder, did you adjust the ownership and permissions?

  3. #3


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,692
    Thank Post
    352
    Thanked 797 Times in 716 Posts
    Rep Power
    347
    Morning,

    It "might" be possible to repair these but it depends what errors MySQL is throwing up on start up first.

    Is the version of MySQL identical to the previous version?

    What OS is the server running, is this is the same OS as before?

    When it does start can you run "show databases;" from the MySQL CLI and does it show up the moodle database?

  4. #4
    Optimus's Avatar
    Join Date
    Aug 2005
    Posts
    35
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by kmount View Post
    Morning,

    It "might" be possible to repair these but it depends what errors MySQL is throwing up on start up first.

    Is the version of MySQL identical to the previous version?

    What OS is the server running, is this is the same OS as before?

    When it does start can you run "show databases;" from the MySQL CLI and does it show up the moodle database?
    Got it to work in the end... my old server was 32bit and the new one was 64bit - so after I copied over 'my.ini' from the old server - the ini file was pointing to the wrong path for the MySQL service!

    Easy to overlook the basics!

    Thanks for your help!

    Optimus

  5. #5


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,692
    Thank Post
    352
    Thanked 797 Times in 716 Posts
    Rep Power
    347
    That's great news good job

SHARE:
+ Post New Thread

Similar Threads

  1. back up and restore mysql data (joomla-ravenswood)
    By Uraken in forum Web Development
    Replies: 4
    Last Post: 28th November 2007, 10:35 PM
  2. MySQL Network access
    By _Bob_ in forum *nix
    Replies: 5
    Last Post: 6th April 2006, 01:30 PM
  3. Exchange restoration (UHH OHH)
    By ajbritton in forum Windows
    Replies: 1
    Last Post: 12th December 2005, 09:55 PM
  4. Php/MySQL Web Design
    By Adam in forum How do you do....it?
    Replies: 8
    Last Post: 18th July 2005, 04:13 PM
  5. php MySql
    By iking in forum Books and Manuals
    Replies: 0
    Last Post: 11th July 2005, 03:35 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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