Search and Replace Tool

Search and Replace Tool

by Carlos Martinez Gongora -
Number of replies: 1

Hello I have and old Moodle with 2.7 version and Oracle DB

I want to know if in this version this tool is avaiable?

When i enter the URL http://yourmoodlesite.org/admin/tool/replace/index.php 

A message appears saying the driver is not implemented in your  Database


Rgds


Average of ratings: -
In reply to Carlos Martinez Gongora

Re: Search and Replace Tool

by Ken Task -
Picture of Particularly helpful Moodlers

Happen to have access to one of those very old 2.7's ...sigh ... been asking owner at least once a month if it's time to upgrade yet! :\

Server to which I have access uses MySQL as DB ... not Oracle.

When accessing, these warnings:

Search and replace text throughout the whole database

This script is not supported, always make complete backup before proceeding!
This operation can not be reverted!

Several tables are not updated as part of the text replacement. These include configuration, log, events, and session tables.

If you have need of the tool, might be best to use older methods via command line ... sed or a text editor that can do S&R on an sql dump of DB.

Please see:
https://docs.moodle.org/37/en/Moodle_migration
Quick and Hacky method

Replace any links in the database that contain the full site URL:
#sed -e 's/oldserver.com/newserver.com/g' oldmysqldump.sql > newmysqldump.sql

'SoS', Ken