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

DarKMaSk

Active member
Nov 17, 2020
306
78
43
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

Active member
Babiato Lover
Sep 8, 2019
366
191
43
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.
 
  • Like
Reactions: DarKMaSk

DarKMaSk

Active member
Nov 17, 2020
306
78
43
I have no problem, but I want to learn. So, if you know how to do it, then please guide me.
 

DarKMaSk

Active member
Nov 17, 2020
306
78
43
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

Active member
Babiato Lover
Sep 8, 2019
366
191
43
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

Active member
Nov 17, 2020
306
78
43
Admins are requested to close this thread as the problem has been solved.
 

About us

  • Our community has been around for many years and pride ourselves on offering unbiased, critical discussion among people of all different backgrounds. We are working every day to make sure our community is one of the best.

Quick Navigation

User Menu