Newbie - Mysql question

[lazyz]

First off, I know nothing about SQL other than I installed a program on my server and it worked - I got lucky...

I'm about to install another program, same site - does it use the same mysql data-base? For the previous program, I had to edit a file to add the name of the mysql data-base, user, password. Does each program need a unique data-base/name, etc. or does it all run from separate tables within the data-base?

[Nick_W]

Who knows?

You'll have to check the documentation with the program. You certainly need to tell it which db to use. Unless it tries to create one itself....

Nick

[c3oc3o]

Usually a seperate DB is not needed, but obviously there will be problems if both scripts use tables with the same name.

[shady]

Unless the new scripts use tables of the same name as your existing scripts, there is no technical reason why you can't run many different applications using the same database.

However, for administrative purposes, if you have the facility, you are better to use seperate databases for each system. This will make tasks such as backups/restores much simpler as you'll be able to specify an entire database rather than manually selecting which tables you wish to backup/restore.