Multiple concurrent MySQL question?

2002-09-22 Thread Paul Maine

I desire to configure MySQL in such a way that it will permit me to have two
different PHP/MySQL e-commerce applications running concurrently on my
development system. The table names and table structure are the same on both
applications(and databases). I have received a SQL backup from the new
client and would just like to be able to restore it to a directory and start
up another copy of MySQL and point it to the new location. I know that I
could create two different databases to accomplish what I desire however, I
would have to change all of the security tables for the new database.

What are your suggestions to solve this issue?

Thank You
Paul


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Multiple concurrent MySQL question?

2002-09-22 Thread Andrew Braithwaite

Paul,

You need to run another server on a different port with a different socket
path. 

See http://www.mysql.com/doc/en/Multiple_servers.html

And http://www.mysql.com/doc/en/mysqld_multi.html to manage multiple MySQL
servers.

Cheers,

Andrew

-Original Message-
From: Paul Maine [mailto:[EMAIL PROTECTED]] 
Sent: Sunday, 22 September 2002 12:26
To: MySQL MySQL
Subject: Multiple concurrent MySQL question?


I desire to configure MySQL in such a way that it will permit me to have two
different PHP/MySQL e-commerce applications running concurrently on my
development system. The table names and table structure are the same on both
applications(and databases). I have received a SQL backup from the new
client and would just like to be able to restore it to a directory and start
up another copy of MySQL and point it to the new location. I know that I
could create two different databases to accomplish what I desire however, I
would have to change all of the security tables for the new database.

What are your suggestions to solve this issue?

Thank You
Paul


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php