MoodleDocs - User contributions [en]

Main page

2011-11-08T08:19:36Z

Jtomkinson:

<div class="frontpagetotal"><p class="note">Welcome to the Moodle 2.1 documentation!</p>
<div class="frontpageblock">
<h2>[[About Moodle]]</h2>
*[[Philosophy]]
*[[Pedagogy]]
*[[Moodle site - basic structure]]
*[[Moodle key terms]]
*[[About Moodle FAQ]]

<h2>[[Installing Moodle]]</h2>
*[[Upgrading]]
*[[Installing plugins]]
*[[Installation FAQ]]
</div>
<div class="frontpageblock">
<h2>[[Managing a Moodle site]]</h2>
*[[Authentication]]
*[[Managing accounts]]
*[[Enrolments]]
*[[Roles and permissions]]
*[[Security]]
*[[Performance]]
*[[Backup]]
*[[Site appearance]]
*[[Language]]
*[[Server settings]]
*[[Site-wide reports]]
*[[Developer tools]]
*[[Web services]]
*[[Community hubs]]
*[[More features]]
</div>
<div class="frontpageblock">
<h2>[[Managing a Moodle course]]</h2>
* [[Courses]]
* [[Editing text]]
* [[Activities]]
* [[Resources]]
* [[Blocks]]
* [[Questions]]
* [[Course enrolment]]
* [[Grouping users]]
* [[Tracking progress]]
* [[Reusing activities]]
</div>
<div class="frontpageblock">
<h2>[[Managing content]]</h2>
* [[Working with files]]
* [[Repositories]]
* [[Portfolios]]
* [[Working with media]]
* [[Filters]]
* [[Licences]]
* [[Plagiarism prevention]]
</div>
</div>
__NOTOC__

See the full [[Table of Contents]] for more detail.

For help with Moodle documentation features see [[Help:Contents]].

Coding

2011-08-19T05:30:52Z

Jtomkinson: Redirected page to dev:Coding

#redirect [[:dev:Coding]]

Adminer

2011-02-14T02:38:32Z

Jtomkinson: /* Install phpMyAdmin in Moodle 2.0 or later */

'''phpMyAdmin''' is a useful MySQL database administration tool (if you are using MySQL as the database for your Moodle). When installed as part of Moodle, it becomes part of the Moodle interface. It can be found in the site administration block>Server>database link.

This is a powerful program that should be used with care and be available only to trusted administrators.

==Install phpMyAdmin in Moodle 1.9.x or earlier==
To install phpMyAdmin so it is directly available via Moodle, unzip the archive from [http://moodle.org/mod/data/view.php?d=13&rid=448 Modules and plugins database] inside the ''moodle/admin/'' folder. You should end up with a folder there called 'mysql' which contains all the necessary files. Now go to your site admin block and you will see a new link: ''Server > Database''. Use this link to initially install and/or open phpMyAdmin.

For those that need phpMyAdmin to perform a Moodle install, unpack it in the documents directory (the same directory as your moodle folder, sometimes found in the folder htdocs) of your web server. Note: many web hosting sites have phpMyAdmin already available via their control panel, you can use that to assist with the Moodle install.

For more advanced users: To obtain the most recent version from CVS, go to the ''moodle/admin/'' folder and run

cvs -z3 -d:ext:myusername@cvs.moodle.org:/cvsroot/moodle co mysql

==Install phpMyAdmin in Moodle 2.0 or later==

To install phpMyAdmin so it is directly available via Moodle, unzip the archive from [http://moodle.org/mod/data/view.php?d=13&rid=448 Modules and plugins database] inside the ''moodle/local/'' folder. You should end up with a folder there called 'phpmyadmin' which contains all the necessary files. Now go to your site admin block and you will see a new link: ''Server > Database''. Use this link to initially install and/or open phpMyAdmin.

For those that need phpMyAdmin to perform a Moodle install, unpack it in the documents directory (the same directory as your moodle folder, sometimes found in the folder htdocs) of your web server. Note: many web hosting sites have phpMyAdmin already available via their control panel, you can use that to assist with the Moodle install.

For more advanced users: To obtain the most recent version from git, go to the ''moodle/local/'' folder and run

git clone git://github.com/moodlehq/moodle-local_phpmyadmin.git phpmyadmin

==See also==

*Using Moodle [http://moodle.org/mod/forum/discuss.php?d=56636 Remove database access] forum discussion

[[Category:Administrator]][[Category:SQL databases]]

File:server10-slowtest-innodb.png

2009-03-04T05:49:15Z

Jtomkinson: uploaded a new version of "Image:server10-slowtest-innodb.png"

File:server10-slowtest-innodb.png

2009-03-04T05:22:28Z

Jtomkinson:

File:Loginview300.png

2009-03-04T02:45:13Z

Jtomkinson:

File:Loginpost300.png

2009-03-04T02:44:54Z

Jtomkinson:

File:server10-slowtest1.png

2009-02-18T01:40:27Z

Jtomkinson:

File:server7-perspective.png

2009-02-17T06:56:10Z

Jtomkinson: uploaded a new version of "Image:server7-perspective.png"

File:server7-perspective.png

2009-02-17T06:52:09Z

Jtomkinson:

Hacking the Moodle 2.0 database transfer script to convert a Moodle 1.9 site

2009-02-17T04:59:10Z

Jtomkinson: /* Step 4: Replace all the database definition files in 2.0 with their 1.9 equivalents */

Moodle 2.0 has a database transfer script that will copy the whole of your Moodle database to another server, even doing conversions like MySQL to PostgreSQL.

Very nice, but what if you want to convert a Moodle 1.9 database without upgrading?

The following instructions tell you how. Warning, this is a very quick and dirty hack, no guarantees. Make sure you have a backup of everything first. Even better, take a copy of your real system, and do the transfer on the copy. However, it worked for us.

==Starting point==

Let us suppose you have a working Moodle 1.9 install as follows (vary the instructions as necessary for your particular setup):
* Code in /var/www/moodle19, accessible as http://example.com/moodle19/
* moodledata in /var/moodledata.
* some database, as set up in /var/www/moodle19/config.php.

==Step 1: Get the Moodle 2.0 code==

* Download a copy of the Moodle 2.0 code to somewhere, say /var/www/moodle20.
* Make a new moodledata for this, say: /var/moodledata20.
* copy /var/www/moodle19/config.php to /var/www/moodle20/config.php
* edit /var/www/moodle20/config.php to make wwwroot, dirroot and dataroot point at the new locations.

At this point it is essential that you '''do not''' go to http://example.com/moodle20/ and let your Moodle upgrade itself.

==Step 2: Hack the code to skip the login step==

* Open /var/www/moodle20/admin/dbtransfer/index.php in your editor.
* Comment out the lines
require_login();
admin_externalpage_setup('dbtransfer');
* There are 4 lines that call functions called
admin_externalpage_print_header();
admin_externalpage_print_footer();
: Change these to call plain print_header/footer() instead.
* Save index.php.
* Open /var/www/moodle20/lib/sessionlib.php in your editor.
* Find the function confirm_sesskey();
* Add a line at the start of this function:
return true;
* Save sessionlib.php.

==Step 3: Create the new database you want to copy to==

As if you were about to install Moodle. You need an empty database, and a 'moodle' user that can connect to it with full control.

==Step 4: Replace all the database definition files in 2.0 with their 1.9 equivalents==

What we need to do is delete all of the install.xml files that belong to Moodle 2.0, wherever they are inside the moodle20 directory, and instead copy in all the ones belonging to Moodle 1.9. This is best done with the following command-line magic:

cd /var/www/moodle20
find . -iname 'install.xml' -exec rm -f {} \;
mkdir -p mod/workshop/db mod/lams/db mod/journal/db mod/excercise/db
cd /var/www/moodle19
find . -iname 'install.xml' -exec cp {} ../moodle20/{} \;

Now there is a tricky issue to sort out. Moodle 1.9 had a blocks/db/install.xml and backup/db/install.xml file, which does not exist in Moodle 2.0, and will not be found, even if you copy the file the the corresponding place in Moodle 2.0. Therefore, we cheat, and copy that install.xml file somewhere where it will be found.

cd /var/www/moodle20/mod
mkdir -p blocks/db backup/db
cp /var/www/moodle19/blocks/db/install.xml blocks/db/
cp /var/www/moodle19/backup/db/install.xml backup/db/

==Step 5: Do the copy==

* Go directly to the URL http://example.com/moodle20/admin/dbtransfer/index.php in your web browser.
* Fill in the details of the database you want to copy to.
* Click 'Transfer data' button.
* Wait patiently, and keep your fingers crossed.

Hopefully, that works. Good luck!

Hacking the Moodle 2.0 database transfer script to convert a Moodle 1.9 site

2009-02-13T01:38:32Z

Jtomkinson: /* Step 2: Hack the code to skip the login step */

Moodle 2.0 has a database transfer script that will copy the whole of your Moodle database to another server, even doing conversions like MySQL to PostgreSQL.

Very nice, but what if you want to convert a Moodle 1.9 database without upgrading?

The following instructions tell you how. Warning, this is a very quick and dirty hack, no guarantees. Make sure you have a backup of everything first. Even better, take a copy of your real system, and do the transfer on the copy. However, it worked for us.

==Starting point==

Let us suppose you have a working Moodle 1.9 install as follows (vary the instructions as necessary for your particular setup):
* Code in /var/www/moodle19, accessible as http://example.com/moodle19/
* moodledata in /var/moodledata.
* some database, as set up in /var/www/moodle19/config.php.

==Step 1: Get the Moodle 2.0 code==

* Download a copy of the Moodle 2.0 code to somewhere, say /var/www/moodle20.
* Make a new moodledata for this, say: /var/moodledata20.
* copy /var/www/moodle19/config.php to /var/www/moodle20/config.php
* edit /var/www/moodle20/config.php to make wwwroot, dirroot and dataroot point at the new locations.

At this point it is essential that you '''do not''' go to http://example.com/moodle20/ and let your Moodle upgrade itself.

==Step 2: Hack the code to skip the login step==

* Open /var/www/moodle20/admin/dbtransfer/index.php in your editor.
* Comment out the lines
require_login();
admin_externalpage_setup('dbtransfer');
* There are 4 lines that call functions called admin_externalpage_print_header/footer(); Change these to call plain print_header/footer() instead.
* Save index.php.
* Open /var/www/moodle20/lib/sessionlib.php in your editor.
* Find the function confirm_sesskey();
* Add a line at the start of this function:
return true;
* Save sessionlib.php.

==Step 3: Create the new database you want to copy to==

As if you were about to install Moodle. You need an empty database, and a 'moodle' user that can connect to it with full control.

==Step 4: Replace all the database definition files in 2.0 with their 1.9 equivalents==

What we need to do is delete all of the install.xml files that belong to Moodle 2.0, wherever they are inside the moodle20 directory, and instead copy in all the ones belonging to Moodle 1.9. This is best done with the following command-line magic:

cd /var/www/moodle20
find . -iname 'install.xml' -exec rm -f {} \;
cd /var/www/moodle19
find . -iname 'install.xml' -exec cp {} ../moodle20/{} \;

==Step 5: Do the copy==

* Go directly to the URL http://example.com/moodle20/admin/dbtransfer/index.php in your web browser.
* Fill in the details of the database you want to copy to.
* Click 'Transfer data' button.
* Wait patiently. Do not panic that there is no feedback at all about what is going on. (Actually, I may soon edit the code to add some feedback display!)

Hopefully, that works. Good luck!