PDA

View Full Version : phpMySQLadmin help



Longover
08-05-2007, 06:38 PM
I need a little help with my database for WP. I am trying to install a "related posts" plugin but need to run this script first. here is what the step says:

b) If automatic creation of a full text index fails. You will have to set it up manually. Don't worry it's not hard. Just open your database in phpMySQLadmin and run the following command (cut & paste):

ALTER TABLE `wp_posts` ADD FULLTEXT `post_related` (
`post_name` ,
`post_content`
)

Note: You may have to change wp_posts to something else if you are using a different prefix, which is common when you have multiple WP installs running of the same database.

KMyers
08-05-2007, 06:47 PM
What happends when you try to do it?

Longover
08-05-2007, 06:59 PM
I don't know how to run a command from the phpMYSQL screen.

Longover
08-05-2007, 07:56 PM
I wasn't sure how to run the script in the first place.

linFox
08-06-2007, 07:17 AM
First, go the the phpMyAdmin interface, http://www.yourdomain.com:2082/3rdparty/phpMyAdmin/

From the dropdown box in the left pane, select the database you are using. Then, click 'SQL' on the menu bar near the top of the page. Then just paste your query in there and hit Go.

Longover
08-06-2007, 10:53 AM
Thanks for the help