motomac Posted October 8, 2015 Share 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? Link to comment Share on other sites More sharing options...
Ibragim Pupkevich Posted October 22, 2015 Share Posted October 22, 2015 phpMyAdmin 4.5 can do this easy. Try it. Link to comment Share on other sites More sharing options...
motomac Posted October 25, 2015 Author Share 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. Link to comment Share on other sites More sharing options...
Daniel F Posted October 25, 2015 Share 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:) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.