SQL ERROR [ mysqli ]: Table 'rabi.rbpb0319_config' doesn't exist [1146]

[DarKMaSk]

Hi!

I am facing a problem and in dire need of a solution. I searched Google and no answer is working. That's why I have come to my last resort, you.. my friends here.

I am trying to change all the table prefixes of my existing database from 'rbpb0319_' to 'rbp_' and I am doing it on my localhost. I replaced them using the 'Raplace table prefix' option inside phpMyAdmin and by opening the database in Notepad and replace all the instances of 'rbpb0319_' to 'rbp_' and alongwith changing the database prefixes, I also changed the database prefix in 'config.php'. After doing these I restarted the XAMPP server, but unfortunately, the result remains the same. It is showing this error:

General Error

SQL ERROR [ mysqli ]
Table 'rabi.rbpb0319_config' doesn't exist [1146]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

Some info on my current database:

Database Engine: InnoDB
Database Name: rabi
Database Table Prefix: rbpb0319_

I just want to change all the table prefixes in this database from 'rbpb0319_' to 'rbp_' , that's all.

Please help.

 

[nesym]

Hi!

I am facing a problem and in dire need of a solution. I searched Google and no answer is working. That's why I have come to my last resort, you.. my friends here.

I am trying to change all the table prefixes of my existing database from 'rbpb0319_' to 'rbp_' and I am doing it on my localhost. I replaced them using the 'Raplace table prefix' option inside phpMyAdmin and by opening the database in Notepad and replace all the instances of 'rbpb0319_' to 'rbp_' and alongwith changing the database prefixes, I also changed the database prefix in 'config.php'. After doing these I restarted the XAMPP server, but unfortunately, the result remains the same. It is showing this error:

General Error

SQL ERROR [ mysqli ]
Table 'rabi.rbpb0319_config' doesn't exist [1146]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

Some info on my current database:

Database Engine: InnoDB
Database Name: rabi
Database Table Prefix: rbpb0319_

I just want to change all the table prefixes in this database from 'rbpb0319_' to 'rbp_' , that's all.

Please help.

I can do that for you if you send me the files and they are not holding some sensitive information.

 

[DarKMaSk]

I have no problem, but I want to learn. So, if you know how to do it, then please guide me.

 

[DarKMaSk]

I can do that for you if you send me the files and they are not holding some sensitive information.

I have a good news for you, I have solved the problem with the help of a friend in another forum. Thanks for your reply.

 

[nesym]

I have a good news for you, I have solved the problem with the help of a friend in another forum. Thanks for your reply.

I would do it with grep command in Linux. Check it out on Google.

 

[DarKMaSk]

I would do it with grep command in Linux. Check it out on Google.

I just had to delete the 'production' folder inside 'cache' folder and it solved the problem.

 

[DarKMaSk]

Admins are requested to close this thread as the problem has been solved.