Add database prefix...

[Alex Clarke]

I know that when you setup Zen Cart you can choose a 'database prefix'. This would be 'zencart_' by default.

However, when I first installed Zen Cart I did not opt for this prefix. Now I want/need it!

How hard would it be to add this prefix?

So far I have planned to do the following:

1 - add prefix to all tables within database via phpmyadmin
2 - use dreamweaver to do a 'find and replace', which will allow me to add the prefix to all relevant bits of code in my php files.

Anything else I should consider?

BTW - I have a heavily modified store.

Thanks in advance.

Alex

[superprg]

<<However, when I first installed Zen Cart I did not opt for this prefix. Now I want/need it!>>

Well, what is the need?

I would recommend doing the new install rather than doing such things which might creep some errors!

[Alex Clarke]

<<However, when I first installed Zen Cart I did not opt for this prefix. Now I want/need it!>>

Well, what is the need?

I would recommend doing the new install rather than doing such things which might creep some errors!

I was planning on installing other database software within one database (eg - phpbb, more zen cart stores, ect...).

[Alex Clarke]

Just found this line in my configure.php

define('DB_PREFIX', '');

I'm guessing that I need to add the prefix there and then rename each table within my database.

After that it should be a case of modifying any customer code to reflect the database changes.

:)

I'll post my results later on today.

[DrByte]

You can add the prefixes in automated fashion using zc_install.

1. Make your two configure.php files read-write.
2. Upload the zc_install folder to your server (you had deleted it after installation).
3. On the System Inspection page, choose Database Upgrade
4. At the bottom of the page, you have the option to specify new prefix details.
5. Set your configure.php files to read-only again
6. Look at your database in phpMyAdmin to ensure that all tables were renamed ... if you had created custom tables, they may or may not have been converted... you can address any stragglers manually.

[Alex Clarke]

You can add the prefixes in automated fashion using zc_install.

1. Make your two configure.php files read-write.
2. Upload the zc_install folder to your server (you had deleted it after installation).
3. On the System Inspection page, choose Database Upgrade
4. At the bottom of the page, you have the option to specify new prefix details.
5. Set your configure.php files to read-only again
6. Look at your database in phpMyAdmin to ensure that all tables were renamed ... if you had created custom tables, they may or may not have been converted... you can address any stragglers manually.

Thanks for the info DrByte! I didn't fancy running the ZenCart installer again (just incase it dumped all of my database). So instead I edited the config files and then manually added 'zen_' as a prefix to all db tables via phpmyadmin. This worked a treat and all the contributions in my heavily customised shop still work!

Thanks for the help! :)