Difference between revisions of "Replikwando/Installation"
From ISoft Wiki
Jump to navigationJump to search
(Broke into sections, cleaned up a bit, added to "Replikwando" category) |
m (Don't need to echo the page title!) |
||
| Line 1: | Line 1: | ||
== Server Side == | |||
# Create a database on Fonseca where the database name equals the customer's product code | # Create a database on Fonseca where the database name equals the customer's product code | ||
# Create a '''MySQL user''' for the customer | # Create a '''MySQL user''' for the customer | ||
| Line 7: | Line 5: | ||
# 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''' | ||
== Client Side == | |||
# Turn on '''binary logging''' | # Turn on '''binary logging''' | ||
## Open the my.ini and enter '''log-bin''' under the '''mysqld''' section | ## Open the my.ini and enter '''log-bin''' under the '''mysqld''' section | ||
| Line 19: | Line 17: | ||
# Create a Replikwando shortcut in '''C:\Documents and Settings\All Users\Start Menu\Programs\Startup''' | # 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 | * Check the server side database to confirm things are getting replicated | ||
[[Category:Replikwando]] | [[Category:Replikwando]] | ||
Revision as of 12:06, 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:\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
