mysqldump - Error 1794 loading mysql 5.6 master dump while configuring replication slave -

-

e:>mysql -u root < masterdump.db error 1794 (hy000) @ line 22: slave not configured or failed initialize properly. must @ least set --server-id enable either master or slave. additional error messages can found in mysql error log. there no additional messages in error log.

in respective my.ini files (yes, i'm on windows) master server-id=1 slave server-id=2

when open dump file , @ line 22 have (x's inserted privacy): change master master_host='1x2.21.42.xxx', master_port=3306, master_user='replicant', master_password='masteaccessxxx', master_log_file='mysql-bin.000004', master_log_pos=335723162; don't have --server-id on line not part of "change master to" command (http://dev.mysql.com/doc/refman/5.6/en/change-master-to.html)

i started slave said:

mysqld --skip-slave-start

does have idea missing?

thanks,

andrew

ok figured out. 

you must @ least set --server-id enable either master or slave.

i thought needed when starting mysql not flag command.

i added --server-id=2 mysqld startup , dump file loading.

thanks looking. hope helps else.

andrew


Comments

Post a Comment

Popular posts from this blog

Issues changing the value of an element in an array in matlab -

-
i'm trying create program sum n-1 , n-2 numbers create n , store value in array. currently, output (assuming numdisp > 2 ) num1 , num2 , 0 , 0 , 0 ... size of array correct, i'm having issues reassigning elements. num1 = input('input first integer of fibonacci sequence: '); num2 = input('input second integer of fibonacci sequence: '); numsdisp = input('how many integers display? --> '); list = zeros(numsdisp,1); list(1) = num1; list(2) = num2; if (numsdisp <=0) disp('value must integer greater zero.') elseif (numsdisp == 1) disp(num1) elseif (numsdisp == 2) disp(num1) disp(num2) else disp(num1) disp(num2) index = 3:numsdisp disp(list(index)) list(index) = list((index-1)) + list((index-2)); end end example input: 3 3 4 corresponding output: 3 3 0 0 you aren't printing out final result, intermediate steps. in for loop, printing list(index) updating value, rather updat...
Read more

php - MySQLi binding parameters in a prepared statement doesn't work unless inserted after "WHERE" -

-
i have php code pulls info database. uses prepared statement, works fine written below: <?php $n = '5'; if ($stmt = $connection->prepare("select title items id = ?")) { $stmt->bind_param("s", $n); $stmt->execute(); $stmt->bind_result($title); while ($stmt->fetch()) { echo $title; } $stmt->close(); } ?> and let's echo "batman". however, when move placeholder here: "select ? items id = 5" and change: $n = 'title'; instead of echoing "batman", echoes "title". not possible use placeholder select parameter? what have done this: select "title" items id = 5 you cant use prepared statement bindings identifiers, parameters.
Read more

vb.net - Alternative to the T-SQL AS keyword -

-
please see code below: imports system.data.sqlclient imports system.configuration public class form1 private _constring string private sub form1_load(byval sender object, byval e system.eventargs) handles me.load dim objdr sqldatareader dim objcommand sqlcommand dim objcon sqlconnection dim id integer try _constring = configurationmanager.connectionstrings("testconnection").tostring objcon = new sqlconnection(_constring) objcommand = new sqlcommand("select person.urn, car.urn person inner join car on person.urn = car.urn , personid=1") objcommand.connection = objcon objcon.open() objdr = objcommand.executereader(connectionstate.closed) while objdr.read id = objdr("urn") 'line 19 loop objdr.close() ...
Read more