Troubleshooting MySQL Server on CentOS 5

Posted on 2007-08-08
Last Modified: 2008-01-09
I am, by far, NOT a SQL guru.  That being said, I can't determine what's broke to even begin to troubleshoot/fix it.  

The Linux server that this affects was completely overhauled, and subsequently got a MySQL server upgrade.  I've copied /var/lib/mysql from the old drive in its entirety, but... the sites that use PHP to query MySQL databases via links, nothing happens when I click a query link; it just seems to reload the page.  Why?  Well, I suppose it's because it's not able to connect to the database to generate the query, right?  However, it's not outputting any errors to the browser on any of these sites.  

I believe that I've probably overlooked something, and any shove in the right direction would be great!
Question by:rcns2317
    LVL 7

    Accepted Solution

    Start with enabling debugging output in your PHP scripts. Then you'll get (probably a lot) info on the screen what happened. If you still need help then, post errors you got after enabling debug output.

    To do so, you need to find your php.ini file, and set
    error_reporting  =  E_ALL & ~E_NOTICE

    Then restart your web server and run php script again.
    LVL 4

    Expert Comment

    don't forget:

    display_errors = On

    Author Comment

    The issue was that PHP globals aren't on by default, fixed this morning.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
    In Solr 4.0 it is possible to atomically (or partially) update individual fields in a document. This article will show the operations possible for atomic updating as well as setting up your Solr instance to be able to perform the actions. One major …
    The viewer will learn how to dynamically set the form action using jQuery.
    The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now