How To Run A Query

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    How To Run A Query

    In the vB3 Admin CP:

    To run a single query you first need to give yourself permission to run queries in the Admin CP. To
    do this, edit this section of config.php:

    Code:
    // ****** USERS WITH QUERY RUNNING PERMISSIONS ******
    // The users specified here will be allowed to run queries from the control panel.
    // See the above entries for more information on the format.
    // Please note that the ability to run queries is quite powerful. You may wish
    // to remove all user IDs from this list for security reasons.
    $canrunqueries = 'x';
    ...with x being your userid number. Then to run a query:

    Admin CP -> Import & Maintenance -> Execute SQL Query

    Using phpMyAdmin:

    1. Open your database in phpMyAdmin.
    2. Click on the SQL tab
    3. Enter the query in the Run SQL query box.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...