mdl_backup_ids table missing in moodle 1.9.9 So no Backup can be taken
How can I restore the tables required for backup in 1.9.x ?????
Does the MySQL user in the config.php file of your site have the ability to create tables?
Unless you have farily extensive knowledge of MySQL, it might be easiest to simply upgrade your Moodle version. 1.9.9 is 10 points below current/most secure/most fixed version (1.9.19+).
In reading over the mysql.php file contained in a 1.9.19 version of Moodle code located in moodle/backup/db/ it looks as if that table has undergone quite a few changes over build dates. Table changes that might also be tied to changes in code.
'spirit of sharing', Ken
sorry its Moodle 1.9.19+ (Build: 20120712) can you send me backup table sql or structure ? I will import table through phpmyadmin Thankx in advance
mysql> desc mdl_backup_ids;
+-------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+---------------------+------+-----+---------+----------------+
| id | bigint(10) unsigned | NO | PRI | NULL | auto_increment |
| backup_code | bigint(12) unsigned | NO | MUL | 0 | |
| table_name | varchar(30) | NO | | | |
| old_id | bigint(10) unsigned | NO | | 0 | |
| new_id | bigint(10) unsigned | NO | | 0 | |
| info | mediumtext | NO | | NULL | |
+-------------+---------------------+------+-----+---------+----------------+
in case the above is hard to read image included.
Or: http://sos.tcea.org/mdl_backup_ids.sql
Check before using.
Wonder how the table went missing!!!!
'spirit of sharing', Ken
Thankx You r gr8. I restored the table . Now I have two tables related to backup mdl_backup_ids and mdl_backup_config Is any othe table required to take backup? mdl_backup_files????????? Please send me sql for the same and or for any additional table required. Thankx in advanced
Anil, I don't have that much working knowledge of *all* the tables in involved in the backup/restore process.
Think you'd be better off (and more independent) installing another 1.9.19+ instance (minimal install - just enough to get it up and running) and getting the tables you need off that instance. You can do that from laptop version ... either/any flavor. Since you might discover many that you don't have.
Still wonder ... how did the tables go missing?
'spirit of sharing', Ken
No success......... Can any one send sql for backup tables??????