Hi all
I am trying to backup my courses but keep on getting the same error below
DDL sql execution error
More information about this error
I am not sure what I am doing wrong or how to rectify this problem. Can someone please help. I am using Moodle 2.7.1 on a Linux server with MySQL versions 5.5.47.
Nolan
If you followed the more info link it shows possible reasons for error.
It does mention "It will also occur during backup if moodle database user has not sql privilege: create temporary tables."
DB user in config.php doesn't have the ability to create temporary tables.
If you have access to the DB via MySQL prompt,
mysql -u SUPERUSER -p
Then issue at the mysql> prompt:
show grants for [DBuserseeninconfig.php]
If you have access to some other MySQL, can't tell you specifically, but
look for something that would indicate privileges a mysql user has.
Must be able to create for backup routine to create temporary tables.
If you are remotely hosted on shared system or some other system that restricts, you might have to contact hosting provider and ask them to grant the DB user in your config.php the ability to create.
Official MySQL docs ref:
http://dev.mysql.com/doc/refman/5.7/en/adding-users.html
'spirit of sharing', Ken
Hi Ken
Thank you so much for your quick response. I will contact my service provider immediately because I don't think I have any privileges.
Thanks again.
Nolan
It worked. Awesome. Thank you so much, you're the bomb!!!
Regards
Nolan
A 'bomb'!!!! In some areas of the world today, that's not at all funny. ;) but I think I understand ... thanks for the thanks ... consider rating posting as 'useful' even though it was really the page that provided possible solutions for that error.
'spirit of sharing', Ken