Difference between revisions of "Replikwando/Installation"
From ISoft Wiki
Jump to navigationJump to search
m (Don't need to echo the page title!) |
|||
Line 10: | Line 10: | ||
## Restart the mysql service | ## Restart the mysql service | ||
# Download Replikwando from [http://dl.isoftdata.com dl.isoftdata.com] | # Download Replikwando from [http://dl.isoftdata.com dl.isoftdata.com] | ||
# Place the files in '''"C:\Replikwando\"''' | # Place the files in '''"C:\ISoft Data Systems\Replikwando\"''' | ||
# Open '''Replication.ini''' and change '''binologpath''' and '''mysqlbinpath''' if needed. | # Open '''Replication.ini''' and change '''binologpath''' and '''mysqlbinpath''' if needed. | ||
# Setup the '''[todatabase1]''' section to correspond to the server side setting just setup (host should be '''backup.isoftdata.com''', '''port: 3306''') | # Setup the '''[todatabase1]''' section to correspond to the server side setting just setup (host should be '''backup.isoftdata.com''', '''port: 3306''') |
Revision as of 12:09, 11 February 2009
Server Side
- Create a database on Fonseca where the database name equals the customer's product code
- Create a MySQL user for the customer
- Setup full privileges for that user to access the the database just created
- Go to the mysql database and give the user "Super" privileges in the user table
Client Side
- Turn on binary logging
- Open the my.ini and enter log-bin under the mysqld section
- Restart the mysql service
- Download Replikwando from dl.isoftdata.com
- Place the files in "C:\ISoft Data Systems\Replikwando\"
- Open Replication.ini and change binologpath and mysqlbinpath if needed.
- Setup the [todatabase1] section to correspond to the server side setting just setup (host should be backup.isoftdata.com, port: 3306)
- Save replication.ini
- Make sure Replikwando is set to run when the user logs into Windows
- Create a Replikwando shortcut in C:\Documents and Settings\All Users\Start Menu\Programs\Startup
Finishing Up
- Check the server side database to confirm things are getting replicated