Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with mysql
Search options not deleted
user 101365
All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.
2
votes
1
answer
2k
views
The table mysql.proc is missing, corrupt, or contains bad data [closed]
In MySQL I'm getting the following error message when trying to call a stored procedure:
The table mysql.proc is missing, corrupt, or contains bad data
I've tried performing CHECK and REPAIR on the …
- 151
1
vote
2
answers
2k
views
Possible to get equivalent MySQL bin log position on another server?
Let's say we have three MySQL servers, mysql1, mysql2 and mysql3. Replication is set up such that mysql3 is the slave of mysql2, and mysql2 is the slave of mysql1. …
- 151
2
votes
Accepted
Possible to get equivalent MySQL bin log position on another server?
Given the following master log position on mysql2:
Master log file = mysql-bin.003151
Master log pos = 46678888
I opened the log file:
mysql2> mysqlbinlog mysql-bin.003151 | less
And searched for … Therefore my master log position on mysql1 is:
Master log file = mysql-bin.002966
Master log pos = 46236261
It's probably possible to automate this process somewhat, but to be honest it was very quick …
- 151