Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Errors with Replication

Errors with Replication

Errors with Replication

I'm literally at wits end with MySQL, I'm trying to replicate my server. After carefully following the steps on the MySQL website I get the following errors:

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

Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=NT3-relay-bin' to avoid this problem.

Column count of mysql.db is wrong. Expected 22, found 20. The table is probably corrupted

Slave SQL thread initialized, starting replication in log 'NT10-bin.000001' at position 752, relay log '.\NT3-relay-bin.000003' position: 896

mysql.user has no `Event_priv` column at position 29

Slave SQL: Error 'Duplicate entry '_transient_doing_cron' for key 'option_name'' on query. Default database: 'cjwilkes'. Query: 'INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1424421994.5183739662170410156250', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)', Error_code: 1062

Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.

Slave: Duplicate entry '_transient_doing_cron' for key 'option_name' Error_code: 1062

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

Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'NT10-bin.000001' position 752

Slave I/O thread: connected to master 'replicator@',replication started in log 'NT10-bin.000001' at position 3891665

Any ideas?

RE: Errors with Replication

What steps did you take to create the slave?

Are both master and slave using the same mysql version?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close