Click here to Skip to main content
15,891,136 members
Home / Discussions / Database
   

Database

 
AnswerRe: What is the right SQL Query... Pin
Mycroft Holmes20-Jan-09 20:45
professionalMycroft Holmes20-Jan-09 20:45 
QuestionThe syntax 'for replication startup options' is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead. Pin
BobClarkSQL20-Jan-09 6:44
BobClarkSQL20-Jan-09 6:44 
AnswerRe: The syntax 'for replication startup options' is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead. Pin
Wendelius20-Jan-09 7:04
mentorWendelius20-Jan-09 7:04 
GeneralRe: The syntax 'for replication startup options' is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead. Pin
BobClarkSQL20-Jan-09 7:09
BobClarkSQL20-Jan-09 7:09 
GeneralRe: The syntax 'for replication startup options' is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead. Pin
Wendelius20-Jan-09 7:52
mentorWendelius20-Jan-09 7:52 
GeneralRe: The syntax 'for replication startup options' is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead. Pin
BobClarkSQL20-Jan-09 8:23
BobClarkSQL20-Jan-09 8:23 
GeneralRe: The syntax 'for replication startup options' is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead. Pin
Wendelius20-Jan-09 8:39
mentorWendelius20-Jan-09 8:39 
GeneralRe: The syntax 'for replication startup options' is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead. Pin
BobClarkSQL20-Jan-09 8:51
BobClarkSQL20-Jan-09 8:51 
I ran the same command set on each of the slaves, stopped each of the slave servers after updating the information and then restarted them each. Went back to the Main server and stopped it and restarted it. Got the same exact error message upon starting the server.

Trying to start the server ...
Server was started.
The syntax 'for replication startup options' is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.

Slave SQL thread initialized, starting replication in log 'MEDCO1.000002' at position 4, relay log '.\MEDCO1-relay-bin.000036' position: 4

Event Scheduler: Loaded 0 events

C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld-debug: ready for connections.
Version: '5.1.30-community-debug-log' socket: '' port: 3306 MySQL Community Server - Debug (GPL)

Slave I/O: error connecting to master 'slave-user@master-hostname:3306' - retry-time: 60 retries: 86400, Error_code: 2005
GeneralRe: The syntax 'for replication startup options' is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead. Pin
Wendelius20-Jan-09 8:58
mentorWendelius20-Jan-09 8:58 
GeneralRe: The syntax 'for replication startup options' is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead. Pin
BobClarkSQL20-Jan-09 9:02
BobClarkSQL20-Jan-09 9:02 
GeneralRe: The syntax 'for replication startup options' is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead. Pin
Wendelius20-Jan-09 9:47
mentorWendelius20-Jan-09 9:47 
QuestionI have Seven Separate MySQL Servers that Have The Same Local Databases on Each Platform that need to update each other at the completion of a run (or test). Each Server will Retain its local results and also update the other 6 Servers when it complet Pin
BobClarkSQL20-Jan-09 6:01
BobClarkSQL20-Jan-09 6:01 
AnswerRe: I have Seven Separate MySQL Servers that Have The Same Local Databases on Each Platform that need to update each other at the completion of a run (or test). Each Server will Retain its local results and also update the other 6 Servers when it com Pin
Ashfield21-Jan-09 0:41
Ashfield21-Jan-09 0:41 
QuestionHow to use DBI Module Pin
sk8te32019-Jan-09 22:49
sk8te32019-Jan-09 22:49 
AnswerRe: How to use DBI Module Pin
Reza Raad20-Jan-09 0:32
Reza Raad20-Jan-09 0:32 
AnswerRe: How to use DBI Module [modified] Pin
Wendelius20-Jan-09 6:50
mentorWendelius20-Jan-09 6:50 
QuestionTable Date Migration Pin
faizurrahman19-Jan-09 20:49
faizurrahman19-Jan-09 20:49 
AnswerRe: Table Date Migration Pin
Wendelius20-Jan-09 7:08
mentorWendelius20-Jan-09 7:08 
QuestionBackup & Restore. Pin
Nanda_MR19-Jan-09 20:15
Nanda_MR19-Jan-09 20:15 
AnswerRe: Backup & Restore. [modified] Pin
Wendelius20-Jan-09 6:36
mentorWendelius20-Jan-09 6:36 
GeneralRe: Backup & Restore. Pin
Nanda_MR20-Jan-09 19:38
Nanda_MR20-Jan-09 19:38 
GeneralRe: Backup & Restore. Pin
Wendelius20-Jan-09 21:13
mentorWendelius20-Jan-09 21:13 
GeneralRe: Backup & Restore. [modified] Pin
Nanda_MR20-Jan-09 22:36
Nanda_MR20-Jan-09 22:36 
GeneralRe: Backup & Restore. Pin
Wendelius21-Jan-09 5:07
mentorWendelius21-Jan-09 5:07 
GeneralRe: Backup & Restore. Pin
Nanda_MR21-Jan-09 20:01
Nanda_MR21-Jan-09 20:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.