restoring moodle data base (mysql) taking unusual time

restoring moodle data base (mysql) taking unusual time

by vishnu prasad -
Number of replies: 3

hello,

i am facing issues with backup and restoring moodle from one server to another.

i have 3 live moodle setup, its databases exported with normal speed and (500MB, 1.5gb, 2 gb size respectively)

i wanted to restore it in a different server but the restoration process are running more than 15+ hours and still not done, 

moodle version 3.1

any help?

Average of ratings: -
In reply to vishnu prasad

Re: restoring moodle data base (mysql) taking unusual time

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

How are you doing it?

In reply to Howard Miller

Re: restoring moodle data base (mysql) taking unusual time

by vishnu prasad -
as sql dumb,

tried with mysql administrator and command.

In reply to vishnu prasad

Re: restoring moodle data base (mysql) taking unusual time

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

It's not really a Moodle problem then... you might get better answers posting in a MySQL/Database forum. 

But (Google is your friend)...

https://dba.stackexchange.com/questions/98814/mysql-dump-import-incredibly-slow-on-my-developers-machine

https://dba.stackexchange.com/questions/20832/slow-mysql-database-import-with-mysqldump-and-use-source

https://stackoverflow.com/questions/10227078/why-is-import-of-sql-so-slow

Caveat - I haven't read the above in detail so you should make sure that the advice is compatible with producing a database that meets Moodle's requirements.