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?

phpMyAdmin 4.5 can do this easy.

Try it.

 

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.

 

Nice find! Thx for sharing:)