Installing and upgrading help

Hi Brian,

Assuming you have phpMyAdmin (or some other other way to work with your database) you would start by selecting your Moodle database and then execute the following SQL statement:

SHOW TABLES;

This will generate a list of the tables in the database. You would then need to copy this list and paste it in your text editor, like so: 

mdl_config
mdl_course
mdl_files
  etc.

Then you only have to modify each row to add the SQL keywords, like so:

ALTER TABLE mdl_config  ENGINE=InnoDB;
ALTER TABLE mdl_course ENGINE=InnoDB;
ALTER TABLE mdl_files     ENGINE=InnoDB;
   etc.

Finally, put your site in maintenance mode, copy the SQL statements, go to the SQL command window of your phpMyAdmin, paste them and run them. Once the process finishes, set back your site to normal mode.

First, know/learn how to backup the DB and restore it from SQL file.   Download the DB's sql dump and archive.

There is, but risky ... do a mysql dump of the DB to an sql file.

Download sql file - work with a copy of that file.

In a text editor that can open what might be a large file, first search for "ENGINE" to see what shows.  If it finds ENGINE=MyISAM.  There's your next search term.  Replace with ENGINE=Innodb ... be VERY exacting ... close doesn't count!

On the server, dump all the tables in the DB.  Then import the edited .sql file with your ENGINE edits.

'spirit of sharing', Ken

Hi Michelle,

You then need to fix manually as recommended.

I sincerely doubt that the screenshot is the one (of the db currently being used). Anyway, to determine what database is being used:

1. Open the config.php file located in your moodle installation directory (usually "moodle", unless you renamed it).

2. Look for the $CFG->dbname directive, it will look like:

$CFG->dbname = 'the-moodle-database-name';

If you can't use the command line, then you have to do it by hand. Here is where having, and knowing how to use, a good text editor comes in handy. For example, once I get (with the two queries I posted) the list of tables and/or columns that need to be updated, I paste them into the editor and then I create a macro to update each row. This usually doesn't take but a few minutes. Then I copy everything and paste it in the SQL window of phpMyAdmin, and execute it. All this process really doesn't take that long.

I do understand, however, that this is fairly easy for me because I'm more into the administrative aspect of Moodle, more than anything else. I can help you but I would need you to run each of the aforementioned queries and copy each set of results into a text file; create a zip with both text files and then post it here as an attachment. I'll update the files so you can just copy and paste the SQL statements into your phpMyAdmin SQL command window and execute them.

So, the first text file should have something like:

table_schema  table_name  table_character_set  table_collation
aaa  bbb  ccc  ddd
aaa  bbb  ccc  ddd

and the second one, something like:

table_schema  table_name  column_name  column_character_set  column_collation  data_type  column_type
aaa bbb  ccc  ddd  eee  fff  ggg
aaa bbb  ccc  ddd  eee  fff  ggg

Cheers!

Hi Michelle,

The screenshot shows the basic steps at the phpMyAdmin to get the results from the two queries.

1. Paste the SELECT SQL statement into the SQL command window and click on the Go button.

2. Once the query finishes and lists the results, click on the Print view (with full texts) link near the bottom of the screen.

3. The SQL Result page displayed. Copy this info, paste into a text file (you can use Notepad, or any other text editor) and save it.

Repeat these steps with the second query.

G. has you covered there.  Thanks, G!

For future (maybe soon) reference ... SiteGround has a decent tutorial on using PHPMyAdmin: http://www.siteground.com/tutorials/phpmyadmin/

Some of the items, pertain to SiteGround ... skip those. ;)

'spirit of sharing', Ken

Ok...so I just figured out that I need a semicolon after each line....

So now I'm going through and changing all as you posted before...I will let you know if it all works....

ugh...

Michelle