restoring moodle data base (mysql) taking unusual time

restoring moodle data base (mysql) taking unusual time

vishnu prasad
Vastuste arv 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?

Keskmine hinnang: -
Vastuses vishnu prasad

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

Howard Miller
Core developers pilt Documentation writers pilt Particularly helpful Moodlers pilt Peer reviewers pilt Plugin developers pilt

How are you doing it?

Vastuses Howard Miller

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

vishnu prasad
as sql dumb,

tried with mysql administrator and command.

Vastuses vishnu prasad

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

Howard Miller
Core developers pilt Documentation writers pilt Particularly helpful Moodlers pilt Peer reviewers pilt Plugin developers pilt

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.