mysql database

[plurk]

hi,

i'm trying to instal the coppermine photo album. And it's said in one of the file that it will create the mysql database. But it doesn't do that.
Probably my provider doesn't allow that kind of thing.
so i was trying to make one my self in phpmyadmin. I know how to do this the only thing i don't know is what tables to use with what fields.
anyone who does know?
or can someone show me the code of theirs? something like this
CREATE TABLE `cpg11d_users` (
  `schema` varchar(150) NOT NULL default ''
) TYPE=MyISAM;


plurk

[Joachim Müller]

coppermine install does create the necessary tables, but it doesn't create a database for you (notice the difference? "Database" vs. "table inside database")!

GauGau

[plurk]

yes i've noticed the difference i tierd both. once without a datbase and once with. but it doesn't create tables in my database.
i also tried to make the table myself, but then i don;t know what collums and rows i need.
so if anyone could make a dump of his database i could create them.

plurk

[Joachim Müller]

If the tables aren't created and filled with values during install, you haven't provided a proper mySQL account (one that is allowed to create tables) - this is of course a prerequisite...
For a manual creation of the db structure, take a look at the folder /sql/ that comes with the coppermine package - it contains all necessary queries (you'll have to modify the prefix though).

GauGau