Have contacted my host, but they say that InnoDB is not available. i see that they do have Postgres available but don't know if this would be an option.
Am i stuck or what?
Have a great evening!
In reply to Fred Frazelle
Re: Want to upgrade to 2.3 from 2.2.1 but database not InnoDB
by Dan Poltawski -
Hi Fred,
No, you are still able to upgrade, Moodle 2.3 works with myisam too.
We highly recommend innodb over myisam because it works more robustly, performs better with big sites and allows better data integrity features (transactions).
In the future its possible that we might require innodb in Moodle, but this is not the case right now. I'd recomend you find a host which supports innodb in the future, i'm sure others can share experiences on this forum.
No, you are still able to upgrade, Moodle 2.3 works with myisam too.
We highly recommend innodb over myisam because it works more robustly, performs better with big sites and allows better data integrity features (transactions).
In the future its possible that we might require innodb in Moodle, but this is not the case right now. I'd recomend you find a host which supports innodb in the future, i'm sure others can share experiences on this forum.
In reply to Dan Poltawski
Re: Want to upgrade to 2.3 from 2.2.1 but database not InnoDB
by Fred Frazelle -
Dear Dan: thanks a million for such a swift reply!
My other question was: could i switch to a Posgres db - i understand it's pretty powerful?
With warmest greetings and have a wonderful evening!
In reply to Fred Frazelle
Re: Want to upgrade to 2.3 from 2.2.1 but database not InnoDB
by Dan Poltawski -
Hi Fred,
You could switch to postgres using the Moodle database transfer tool (yourmoolde/admin/tool/dbtransfer/), however this is much more involved and than migrating to innodb. Though I highly recommend postgres.
You could switch to postgres using the Moodle database transfer tool (yourmoolde/admin/tool/dbtransfer/), however this is much more involved and than migrating to innodb. Though I highly recommend postgres.
In reply to Dan Poltawski
Re: Want to upgrade to 2.3 from 2.2.1 but database not InnoDB
by Fred Frazelle -
Thanks, Dan. i've always wanted a Postgre db! i'm glad to see that they are so highly recommended here.
i'm going to try to do the transfer, but first need to backup my db and then figure out what each field refers to in the transfer script. giggle - i clicked the button at the bottom of the screen when i got the original db transfer screen - to see if there was any documentation on the process. lol, nothing at all. It's late so i'm going to try this when i'm more rested - like tomorrow.
Thanks again for all your help and encouragement.
Have a great evening!
In reply to Dan Poltawski
Re: Want to upgrade to 2.3 from 2.2.1 but database not InnoDB
by Martin Dougiamas -
Further to Dan's accurate comments about innodb working much better in general, it is actually required if you want to use Moodle's web services (for the Mobile app, for example), and possibly for more features in future.
So we really really really recommend you find a way to get off MyISAM as soon as you can.
In reply to Martin Dougiamas
Re: Want to upgrade to 2.3 from 2.2.1 but database not InnoDB
by Fred Frazelle -
Dear guys:
Thanks again for such encouragement! Well, here is the first hurdle. If i can get some good info on this, perhaps i could even create a page in the Wiki for it...
Database export
Type
Host server
Database
User
Password
Tables prefix
Port
Unix socket
Where do i find the Port and Unix socket?
Can the tables prefix be anything i wish? Like "mdle", for example?
Have a great afternoon! 
In reply to Fred Frazelle
Re: Want to upgrade to 2.3 from 2.2.1 but database not InnoDB
by Fred Frazelle -
Well, i asked my hosting co. and they gave me all the info to fill in the fields. However they replied that
Unix Socket - Socket connections are not supported on our service due the security reasons.
so i don't know if i can proceed with this database transfer or not without Unix Sockets.
If i remember correctly, this field was not listed as a "Required field." so...
i'm going to try and see what happens. i've already d/l my db so it's safe.
Have a wonderful afternoon!
In reply to Fred Frazelle
Re: Want to upgrade to 2.3 from 2.2.1 but database not InnoDB
by Dan Poltawski -
Hi Fred,
You don't need to use a unix socket, it can be used optionally.
thanks,
Dan.
You don't need to use a unix socket, it can be used optionally.
thanks,
Dan.
In reply to Dan Poltawski
Re: Want to upgrade to 2.3 from 2.2.1 but database not InnoDB
by Fred Frazelle -
Thanks, Dan. Well, i finally got enough info for the script to proceed and this is what i got in reply...
Current database structure does not match all install.xml files.
table question:
- Field oldquestiontextformat is not expected in table question.
table backup_files:
- Table backup_files is missing in database.
table backup_ids:
- Table backup_ids is missing in database.
table hotpot:
- Table hotpot is not expected.
table hotpot_attempts:
- Table hotpot_attempts is not expected.
table hotpot_details:
- Table hotpot_details is not expected.
table hotpot_questions:
- Table hotpot_questions is not expected.
table hotpot_responses:
- Table hotpot_responses is not expected.
table hotpot_strings:
- Table hotpot_strings is not expected.
table question_rqp:
- Table question_rqp is not expected.
table question_rqp_servers:
- Table question_rqp_servers is not expected.
table question_rqp_states:
- Table question_rqp_states is not expected.
table question_rqp_types:
- Table question_rqp_types is not expected.
table unit_table:
- Table unit_table is not expected.
table wiki_entries_old:
- Table wiki_entries_old is not expected.
table wiki_locks_old:
- Table wiki_locks_old is not expected.
table wiki_pages_old:
- Table wiki_pages_old is not expected.
....doesn't this thing have an "insert code" option?
Anyway, what can i do now?
Warmest greetings and have a great morning!
In reply to Fred Frazelle
Re: Want to upgrade to 2.3 from 2.2.1 but database not InnoDB
by Fred Frazelle -
i used a different Tables Prefix - mdl - instead of frazelle0 after examening the actual database. Of course it is not my regular Joomla! database, it's Moodle!, so of course it will probably use a different Tables Prefix. Duh.
So now the only error i get is "targetdatabasenotempty"
i'm trying to figure out how the script knows which db to migrate the data to. It doesn't ask this question, so how could it tell if the targetdatabasenotempty was empty or not?
Have a great afternoon! Are we getting there?
In reply to Fred Frazelle
Re: Want to upgrade to 2.3 from 2.2.1 but database not InnoDB
by Dan Poltawski -
Hi Fred,
The tool does know the target database, because this is what you enter in the fields: "Host server Database User Password Tables prefix Port Unix socket"
It knows the source database because that is the database of the Moodle you are currently connected to. So - are you sure you are putting the target details into those fields?
In reply to Dan Poltawski
Re: Want to upgrade to 2.3 from 2.2.1 but database not InnoDB
by Fred Frazelle -
Dan, welcome back!
Uh, yes i'm pretty sure that i have all of the details correct, now.
Let's see...
Database export
Type
Host server supremecenter.com
Database frazelle0_mdle1
User frazelle0_mdle1
Password xxxxxx
Tables prefix mdl_
Port 3306
Unix socket -- Was told that this is not necessary.
For some reason, the db does have tables in it whose prefix is not mdl_ . They seem to be a "copy" of the mdl_ tables.
Does the above look correct to you? Could/should the server be "localhost"?
Have a wonderful evening and good to see you online again!
In reply to Fred Frazelle
Re: Want to upgrade to 2.3 from 2.2.1 but database not InnoDB
by Fred Frazelle -
Arg. i was confused. Thought i was looking for info about the current db.
So i entered the data for the Pg db and got
"Error: Database connection failed
It is possible that the database is overloaded or otherwise not running properly.
The site administrator should also check that the database details have been correctly specified in config.php"
Upon examination, the config.php file under Moodle does not contain any reference to the Pg db, only the Mysql db. Can it have info about both databases at the same time?
Have a great evening!