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 ...
20th December 2011, 10:55 PM #1
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!!
IDG Tech News
21st December 2011, 08:13 AM #2
I think it should be. When you copied data the folder, did you adjust the ownership and permissions?
21st December 2011, 08:18 AM #3
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?
23rd December 2011, 10:35 AM #4
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!
Originally Posted by kmount
Easy to overlook the basics!
Thanks for your help!
23rd December 2011, 12:39 PM #5
That's great news good job
By Uraken in forum Web Development
Last Post: 28th November 2007, 10:35 PM
Last Post: 6th April 2006, 01:30 PM
By ajbritton in forum Windows
Last Post: 12th December 2005, 09:55 PM
By Adam in forum How do you do....it?
Last Post: 18th July 2005, 04:13 PM
By iking in forum Books and Manuals
Last Post: 11th July 2005, 03:35 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)