RE: [Phpwiki-talk] Multiple WIKIs

[Alexandre D. <al...@co...>]

On Tue, 7 Jan 2003, Sandy Matheson wrote:

> Thanks for the help.
> 
> Index.php now gets through this OK and starts to load, but locks just
> after creating the TextFormattingRules page.
> 
> HOWEVER if I set up an entirely new MySQL database and use the same
> index.php file (i.e. only altering the 'prefix' part as well as
> database, username and password), then everything works fine.

Using prefix in table namespace ? I don't think it's a great idea. Why
don't you  create a new  database ? (For  performance & so  on... It's
also better)

> 
> I can use multiple databases, but backing up will be so much easier with
> one database using PHPMyAdmin. 

I don't know how PHPMyAdmin works.  But we have a multitude of wiki on
the  same machine  and we  have a  comment method  for  expressing the
database name : phpwikidb-XXXX. 

For the backup, we have a  custom script doing a mysqlshow and dumping
all the db starting with phpwikidb-. Clean and working like a charm. 

Have a nice day. 

adulau

-- 
			      Alexandre Dulaunoy -- http://www.foo.be/
  3B12 DCC2 82FA 2931 2F5B 709A 09E2 CD49 44E6 CBCD  ---   AD993-6BONE
"People who fight may lose.People who do not fight have already lost."
							Bertolt Brecht