motomac Posted October 8, 2015 Posted October 8, 2015 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?
Ibragim Pupkevich Posted October 22, 2015 Posted October 22, 2015 phpMyAdmin 4.5 can do this easy. Try it.
motomac Posted October 25, 2015 Author Posted October 25, 2015 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.
Daniel F Posted October 25, 2015 Posted October 25, 2015 On 23.10.2015, 00:17:33, Ibragim Pupkevich said: phpMyAdmin 4.5 can do this easy. Try it. Nice find! Thx for sharing:)
Recommended Posts
Archived
This topic is now archived and is closed to further replies.