This KB article is a quick 'how to', for a more detailed set of instructions see this topic viewtopic.php?f=16&t=588696
1. Go into phpMyAdmin in your web browser and enter your login and password : you should see a screen like this :
http://www.phpbb.com/kb/images/phpmyadmin1.jpg
2. Now, find your database on the left part of the screen :
http://www.phpbb.com/kb/images/phpmyadmin2.jpg
3. You should see something like this :
Top of the screen :
http://www.phpbb.com/kb/images/phpmyadmin3.jpg
4. Look for the SQL tab and click it. Once you are on this page, copy/paste the SQL query to run into the box :
http://www.phpbb.com/kb/images/phpmyadmin4.jpg
5. Click on "Go" (or Execute) :
http://www.phpbb.com/kb/images/phpmyadmin5.jpg
6. Now, you should see a page like this :
http://www.phpbb.com/kb/images/phpmyadmin6.jpg
7. If you get a message error, like this :
http://www.phpbb.com/kb/images/phpmyadmin7.jpg
Just read the error message and correct the sql query and try it again.
If all has gone well you have then successfully executed a SQL query using phpMyAdmin.
Knowledge Base
Executing SQL Queries in phpMyAdmin
Article ID: 121
Written By: morpheus2matrix
Written On: Thu Feb 04, 2010 4:27 pm
Description: Get the steps to executing SQL queries for MODs in phpMyAdmin
Article ID: 121
Written By: morpheus2matrix
Written On: Thu Feb 04, 2010 4:27 pm
Description: Get the steps to executing SQL queries for MODs in phpMyAdmin
- link to this article on phpbb.com: Select All
[kb=executing-sql-queries-in-phpmyadmin]Executing SQL Queries in phpMyAdmin[/kb]
- link to this article on your own board: Select All
[url=http://www.phpbb.com/kb/article/executing-sql-queries-in-phpmyadmin/]Knowledge Base - Executing SQL Queries in phpMyAdmin[/url]
