mySQL数据库表有2个不同的前缀，给我数据库连接问题

Question

I was working on a site, and restored a database and file back-up, and I am getting the "Error Establishing a Database Connection".

When I check the mySQL database, half of the tables are running a 'wsd_' prefix, while the other files are running 'ahc_'.

wp-config currently has $table_prefix: 'wsd_'

Is there any way to tell the wp-config file to look for both "wsd_" and "ahc_"?

Sorry ahead of time, as I'm still new to mySQL.

Answer 1

The most easiest and reliable method is to export your whole database. Then open database in the notepade or any editor software specially if you have notepad++ or dreamweaver.

Keep one prefix. Suppose you want to keep "ahc_" then find all "wsd_" and replace with "ahc_"

Save the file. Now import that file to your database. All prefix will be same :)