Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Renaming prefixes of table names within phpmyadmin?

Is there a more dynamic way to rename all prefixes in a database within phpmyadmin, rather than manually typing to replace the name for each table? I have about 50 tables to change prefixes on... Maybe I should grab a snickers bar?

like image 720
klewis Avatar asked Nov 04 '11 16:11

klewis


People also ask

When naming a table what prefix would you use?

Tables do not require prefixes. This is purely up to you. However, we prefix tables with relation to the MODULES in the application they belong to, just to group the tables more easily.


1 Answers

Have all the corresponding tables in phpMyadmin ticked and select With Selected..->Replace table prefix

like image 91
Thomas Avatar answered Oct 10 '22 00:10

Thomas