The other day, I was about to add a gallery2 installation and a PHPlist to an already-functioning Drupal 5.2 site, and I realized that if I ever wanted to use PHPmyAdmin to do stuff in this database's tables ever again, I needed to add some sort of prefixing to the Drupal tables first. You see, both of those apps use prefixing on their tables, so to keep my Drupal install's tables from being scattered, I had to prefix them as well, here's how I did it...
I made a backup of the Drupal tables, using the MySQLadministrator program. When I was done, I opened the resulting .sql file in my beloved TextMate program, and began changing things:
This is an example line from a MySLadministrator database dump:
CREATE TABLE `databaseName`.`access` (needs to become:
CREATE TABLE `databaseName`.`drupal_access` (If I'm ever going to get anywhere in an automated fashion, this will have to be written into a module at some point. For now, though, I just ran a find & replace on the text file using the beloved TextMate program.
FIND: CREATE TABLE `databaseName`.`
REPLACE: CREATE TABLE `databaseName`.`drupal_And then also:
FIND: INSERT INTO `databaseName`.`
REPLACE: INSERT INTO `databaseName`.`drupal_I asked several developers in the IRC channel, and I suspect there might be a way to do this in a Drupal module, so I'll lay out the steps for that if I ever figure them out.
Comments
Hey, this one's cool!
I like this approach.