Difference between revisions of "Replikwando/Installation"
From ISoft Wiki
Jump to navigationJump to search
Line 4: | Line 4: | ||
# Setup full privileges for that user to access the the database just created | # 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''' | # Go to the '''mysql''' database and give the user '''"Super" privileges''' in the '''user table''' | ||
# Run the '''flush privileges''' query. | |||
== Client Side == | == Client Side == |
Revision as of 12:10, 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
- Run the flush privileges query.
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