===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__
# Dump.sql and
# Views.sql.
The MySQLtoPGSQL tool does not have any installation program. Just copy the folder to somewhere on the C-drive. <br/> <br/>1 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.
# Restore the 5.08.04 database # 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|400px]] # 2 Click on run.bat to start the tool.# Rename the MySQL dump.sql that you have in the latest backup folder to e.g. MySQLdump. <br/> <br/>[[Image:MySQLtoPGSQL2.png|500px600px]]# 3 When the tool has finished, scroll through up in the window and check if there are any error messages. <br/> <br/> [[Image:MySQLtoPGSQL3.png|400px]]# 4 If not, copy the raw dump.sql and/or views.sql files to a folder e.g. ''Lebanon Raw''. If you have the latest backup attachments copy them also to ''Lebanon Raw'' [[Image:Raw folder.png|650px]]
The dump file created with the tool is a '''raw''' dump file in PosGreSQL format which is possible to restore with V6.0.