Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

This is very strange, and troubling. As of 30 minutes ago, phpMyAdmin is not displaying the same records as the command line, and my php pages which connect to the DB are giving inconsistent results. A change I make in phpMyAdmin does not show up when I check it in MySQL, and vice versa.

Any ideas on why this might be happening and how to fix it? Thanks!

share|improve this question
    
Could you provide some examples? –  slm Jan 2 '13 at 23:56
    
I put in some on a comment below. Basically changes I made in phpMyAdmin (schema change, or in-line editing, or deleting rows) would show as normal, even after logging out and back in, or browsing to different databases. But they did not register when browsing the same records in the command line. Very weird... –  Ben Kirchner Jan 3 '13 at 16:06

1 Answer 1

up vote 2 down vote accepted

Sounds like you are connecting to at least two different databases.

share|improve this answer
    
This sounds like it is the issue exactly--or that there's a cluster that's out of sync. –  Andrew M. Jan 2 '13 at 22:52
    
There's only one MySQL server running. I don't see how that could be the problem. How do I tell if a cluster is out of sync and how do I fix it? –  Ben Kirchner Jan 2 '13 at 22:59
    
And now it's back to working properly. So I have to think that it's something getting out of sync somewhere. Any ideas on what to investigate? –  Ben Kirchner Jan 2 '13 at 23:04
    
There's no syncing between MySQL and phpMyAdmin. Is this a system you set up yourself? Or is someone else doing the admining? It sounds like a replicated system of some sort. –  ceejayoz Jan 3 '13 at 1:32
    
My partner and I are the only admins, we set it up. I know that phpMyAdmin shouldn't sync. That's why this was so weird. I have no idea why it would have happened. The changes, i.e. new records, were visible in phpMyAdmin after logging out and logging back in, browsing different databases, etc. But they did not show up when browsing the command line for a while, and then just came back. –  Ben Kirchner Jan 3 '13 at 16:04

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.