Jump to content

Easy way to remove SQL tables prefix?


motomac
 Share

Recommended Posts

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

  • 2 weeks later...

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.

Edited by motomac
Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...