NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
===Take full backup===__NOEDITSECTION__
Take a full backup and make sure that the country has a separate file backup of the attachments (especially for countries that has GBs of attachments).
It is recommended for your future reference to save all backups produced during the upgrade process.
===Extract MySQL===__NOEDITSECTION__
The MySQLtoPGSQL tool does not have any installation program. Just copy the folder to somewhere on the C-drive.
# Restore the 5.08.04 database <br/> [[Image:MySQLtoPGSQL1.png]]# If there is already a dump.sql and/or views.sql in the folder, the tool will '''append''' to these files. So do not forget to delete these files between working with different countries.<br/> <br/> [[Image:MySQLtoPGSQL1.png]]
# Click on run.bat to start the tool.
# Rename the MySQL dump.sql that you have in the original backup folder to e.g. MySQLdump. <br/> <br/>[[Image:MySQLtoPGSQL2.png|500px]]# When the tool has finished, scroll through up in the window and check if there are any error messages. <br/> <br/> [[Image:MySQLtoPGSQL3.png|500px]]
# If not, copy the raw dump.sql and/or views.sql files to the original backup folder.