Databases
StackOverflow2013
Postsdbo
POmysql replication phpmyadmin windows version
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POmysql replication phpmyadmin windows version
    text
    copied!<p>First of all let me say there are no CLEAR tutorials for how to do this on windows, I'm a programmer and have been using MySQL and PHP for years, and have never seen so many different answers when it comes to linux, and absolutely nothing for windows users.</p> <p>Anyway I have been working for 2 weeks trying to solve this myself, and I am at the same place no matter what tutorial, method or whatever I try. Basically I have two MySQL Servers. One Master, and One Slave (setup through phpMyAdmin)</p> <p>I have both servers online and they can see each other and are connected to each other, however when it comes to syncing under the Slave Status table in phpMyAdmin I am constantly getting errors saying tables don't exist. But they do. Now I'm not sure if I am supposed to completely import the databases from my master manually, and then it updates it or whatever (again no clear tutorials are out there for windows). Below is the table i copied from phpMyAdmin.</p> <pre><code>Slave_IO_State Waiting for master to send event Master_Host XX.XX.XX.XX Master_User XXXXXXXX Master_Port 3306 Connect_Retry 60 Master_Log_File mysql-bin.000012 Read_Master_Log_Pos 1221 Relay_Log_File *servername*-relay-bin.000003 Relay_Log_Pos 253 Relay_Master_Log_File mysql-bin.000001 Slave_IO_Running Yes Slave_SQL_Running No Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno 1146 Last_Error Error 'Table '*databasename*.*tablename*' doesn't exist' on query. Default database: '*databasename*'. Query: 'DELETE FROM *tablename* WHERE expires Skip_Counter 0 Exec_Master_Log_Pos 107 Relay_Log_Space 211493 Until_Condition None Until_Log_File Until_Log_Pos 0 Master_SSL_Allowed No Master_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master (blank but would like this setup) </code></pre> <p>I should also add that this database that supposedly has missing tables is working perfectly on the master for an active website.</p> <p>Any help to point me in the right direction would be appreciated.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload