Jump to content

Easy way to remove SQL tables prefix?


motomac

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.

Link to comment
Share on other sites

Archived

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

  • Recently Browsing   0 members

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