Jump to content

Easy way to remove SQL tables prefix?

Featured Replies

Posted

I'm doing to move from 3.4.x to 4.x soon and want to remove MySQL tables prefix. My DB is very big (about 6 Gb), so I'm afraid, it will be very slow and also dangerous to rename them one by one after converting.

Is there any easy way to get rid of prefix while converting from IPS 3 to IPS 4?

  • 2 weeks later...

phpMyAdmin 4.5 can do this easy.

Try it.

phpmyadmin_4.5_prefixes.thumb.png.9bfbf5

 

phpmyadmin_4.5_prefixes2.PNG.ade12089ade

  • Author

I was afraid that it could corrupt the table, because they are very huge, but I made it via console, and it was surprisingly fast. Only one thing was hard: to make an SQL query with the full list of my tables :)

Anyway thanks for the reply.

On 23.10.2015, 00:17:33, Ibragim Pupkevich said:

phpMyAdmin 4.5 can do this easy.

Try it.

phpmyadmin_4.5_prefixes.thumb.png.9bfbf5

 

phpmyadmin_4.5_prefixes2.PNG.ade12089ade

Nice find! Thx for sharing:) 

Archived

This topic is now archived and is closed to further replies.

Recently Browsing 0

  • No registered users viewing this page.