• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.5 Where To Enter SQL Commands?

#1
I've searched this forum and have seen a number of SQL commands to directly access the database.

But they don't say WHERE to enter the commands. My questions:

(1) Does XenForo provide a place to type in SQL queries?

(2) Do you need to enter a USE command or is that automatic?

(3) Or do you have to log on to your database using a separate SQL client?

JF
 

Brogan

XenForo moderator
Staff member
#3
In general you shouldn't have to run queries on the database directly and it's not something we would typically recommend.

If you do, ensure you take a backup first.
 

tajhay

Well-known member
#4
If you want to run SQL commands directly from the xenforo ACP - you can do so using this addon - https://xenforo.com/community/resources/querier.2389/

Quite useful wihtout having to log into phpMyAdmin etc.

Edit - you need to know the table and column names though. That information doesnt get exposed. Its only an SQL Query form but enables you to quick select / update etc whatever you need to do.
 

SneakyDave

Well-known member
#7
You might be restricted from using SHOW DATABASES if you're using the MySQL user assigned to your XenForo forum. You might need to be connected as the root or privileged user to see that.

I'd suggest using phpmyadmin or the native command line if you need to view db info.
 
Last edited: