Archive for November 4th, 2008
Tuesday, November 4th, 2008
copy/paste from the Moodle forums:
There are some good papers around on tuning PostgreSQL, and Moodle's case does not seem to be different to the general case.
The first thing to recognise is that if you really need to worry about tuning you should be using a separate machine for the database ...
Posted in BrnDmp | No Comments »
Tuesday, November 4th, 2008
Based on earlier attempts, I did a migration of a Moodle database from mysql2postgresql:
1. install 'clean' postgresql database exactly like mysql database (copy codebase and do upgrade)
2. dump mysql, data only with full insert:
[bash]
mysqldump --skip-opt --single-transaction -u moodleuser -p -c -t db > db.20081104.sql
[/bash]
3. converting pg_dump to mysqldump by removing ...
Posted in BrnDmp | No Comments »
Tuesday, November 4th, 2008
If you want to search and replace with sed and immediately save to the file, use the -i option like this:
sed -i s/pattern1/pattern2/g filename
then pattern1 is replaced by pattern2 and replaced in the filename. If you're not sure first run the command without -i to check the output.
Posted in BrnDmp | No Comments »
