Sharing MYSQL

[adb34]

Is it possible to have two Zencart shops and only one MYSQL? If this has already been asked sorry and can you point me to that thread? Thanks

[stevesh]

Yes, you can install Zencart for the first shop, then when you install the second shop, point the installer to the first shop's database, but specify a database table prefix when asked during the installation.

Not sure why you would want to do that, though.

[adb34]

Yes, you can install Zencart for the first shop, then when you install the second shop, point the installer to the first shop's database, but specify a database table prefix when asked during the installation.

Not sure why you would want to do that, though.

Doing this i assume it save some server space

[gjh42]

I doubt it would save a measurable portion of server space (if it does, you will soon have problems with running out of space), and it will require more processing every time the shops look for information in the database. It would be much cleaner to use separate databases; the only reason I can think of to put them both in one db is if you don't have the ability to make more than one.