coppermine-gallery.com/forum

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: plurk on January 08, 2004, 01:22:30 PM

Title: mysql database
Post by: plurk on January 08, 2004, 01:22:30 PM
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
Title: mysql database
Post by: Joachim Müller on January 08, 2004, 03:09:55 PM
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
Title: mysql database
Post by: plurk on January 08, 2004, 04:42:15 PM
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
Title: mysql database
Post by: Joachim Müller on January 09, 2004, 08:54:16 AM
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