Renaming prefixes of table names within phpmyadmin?

database phpmyadmin rename prefix
klewis picture klewis · Nov 4, 2011 · Viewed 43.8k times · Source

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?

Answer

Thomas picture Thomas · May 3, 2013

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

Related questions

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES)

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES) in C:\Users\xampp\htdocs\PHP_Login_Script\config.php on line 6 Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, boolean given in C:\Users\…

Read More
Can't import database through phpmyadmin file size too large

I have been trying to import Database through phpMyAdmin. My database file is a.sql and it's size is 1.2 GB I am trying to import this on local and phpMyAdmin is saying: You probably tried to upload too large file. …

Read More
Update query PHP MySQL

Can anybody help me understand why this update query isn't updating the fields in my database? I have this in my php page to retrieve the current values from the database: <?php $query = mysql_query ("SELECT * FROM blogEntry WHERE …

Read More