I have trouble trying to secure my website by changing prefix

famecherry
(@famecherry)

13 years, 1 month ago

I am following the steps shown here

http://tdot-blog.com/wordpress/6-simple-steps-to-change-your-table-prefix-in-wordpress

however when I try to change wp_user_roles under wp_options to the new prefix

I get this error

SQL query: Edit

UPDATE famech5_wrdp1.acess_options SET option_name = ‘acess_user_roles’ WHERE acess_options.option_id =95

MySQL said: Documentation
#1062 – Duplicate entry ‘acess_user_roles’ for key 2

Can somebody please help me ? What is going on ?

Viewing 8 replies - 1 through 8 (of 8 total)

Rahul Sonar
(@rahulsonar)

13 years, 1 month ago

that means this key has already been updated

Thread Starter famecherry
(@famecherry)

13 years, 1 month ago

That means I dont have to do anything ? Its all done ?

Rahul Sonar
(@rahulsonar)

13 years, 1 month ago

yes, try accessing your site.. especially creating a new user, login with that user .. if all this works fine, you are already done..

Thread Starter famecherry
(@famecherry)

13 years, 1 month ago

Thank you.

I have been fiddling with this for the past hour.

Now I have moved on to editing the wp_usermeta, suddenly my whole databank got wiped out !

I am now requesting for my host to help me restore my backup as we speak.

Can you please tell me the possible cause of this ? How can I safely do this the next time ?

Is there a plugin which can allow me to secure wordpress without going through this ?

Rahul Sonar
(@rahulsonar)

13 years, 1 month ago

1) next time, take a full backup of your database 🙂
2) In phpmyadmin or some other tool, search for wp_ in your database, and replace it at all possible places, especially mentioned here

It is always better to do this before install, rather than changing afterwards… 🙂

Thread Starter famecherry
(@famecherry)

13 years, 1 month ago

There is no magic plugin that can change everything in one go ? =(

Rahul Sonar
(@rahulsonar)

13 years, 1 month ago

http://www.seoegghead.com/software/wordpress-table-rename.seo

Thread Starter famecherry
(@famecherry)

13 years, 1 month ago

Thank you very much, I shall try this once I got my site backed up =)

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘I have trouble trying to secure my website by changing prefix’ is closed to new replies.

I have trouble trying to secure my website by changing prefix

Tags

Topics

Topics with no replies

Non-support topics

Resolved topics

Unresolved topics

All topics