2005-11-13, 04:08 PM
There are quite a few question on the MyBB forums regarding how to properly run SQL queries with phpMyAdmin. Here is a small tutorial I put together that explains the easiest method.
-------------------------------------------------------------------------
1) Login to phpMyAdmin. If you do not know where or how to do this, please consult your host.
[attachment=1555]
2) In some cases, you may have to choose which database your MyBB tables are located on. If this is the case, please choose using the dropdown box.
[attachment=1556]
3) You should now be at a screen that looks similar to this:
[attachment=1557]
4) To run a SQL query, click on "SQL" on the navigation bar.
[attachment=1558]
5) Enter your SQL in the box provided.
[attachment=1559]
6) Click "Go".
[attachment=1560]
7) If all goes well, your SQL query will now be succesfully entered.
Cheers!
-------------------------------------------------------------------------
1) Login to phpMyAdmin. If you do not know where or how to do this, please consult your host.
[attachment=1555]
2) In some cases, you may have to choose which database your MyBB tables are located on. If this is the case, please choose using the dropdown box.
[attachment=1556]
3) You should now be at a screen that looks similar to this:
[attachment=1557]
4) To run a SQL query, click on "SQL" on the navigation bar.
[attachment=1558]
5) Enter your SQL in the box provided.
[attachment=1559]
6) Click "Go".
[attachment=1560]
7) If all goes well, your SQL query will now be succesfully entered.
Cheers!