11-03-2011
Quote:
Originally Posted by
Astrocloud
I love the idea on Sybase it's just that my boss (who doesn't make mistakes) has already hired someone to create a duplicate database in SQL Server and now I'm stuck with figuring out how to get our existing system to work with it (if it can be done).
Honestly, who knows if I will be here long enough to ask other questions...
Try switching to mssql_ calls instead of mysql_ calls. That's about all I can reccomend.
This User Gave Thanks to Corona688 For This Post:
9 More Discussions You Might Find Interesting
1. AIX
Hi everybody,
I want ask if it is possible to copy all storage structure (VGs, LVs & filesystems) from one server to another. In other words, I want to move my system from old server to new one, so I want the new server exactly have the same sizes and number of VGs, LVs, & filesystems.
Thanks... (11 Replies)
Discussion started by: aldowsary
11 Replies
2. UNIX for Advanced & Expert Users
How does everyone else handle this?
My Setup:
Server A:
CentOS 5.x
10.0.0.1
Apache
MySQL Master
Server B:
CentOS 5.x
10.0.0.2
Apache
MySQL Slave
My Domains:
dom1.com A record: 10.0.0.1
A Record: 10.0.0.2
dom2.com A record: 10.0.0.1
A Record: 10.0.0.2 (3 Replies)
Discussion started by: Ikon
3 Replies
3. AIX
Can any one help.....
How will do migration through NIM server? (4 Replies)
Discussion started by: AIXlearner
4 Replies
4. Solaris
Hi All
We are having a very old server that is working on solaris 5.6 and oracle7.
now We are planning to migrate it to a Solaris 8 and oracle 9 environment.
The application software of the server is basically written in ProC and there are few sql ,perl and shell scripts on the server . We... (13 Replies)
Discussion started by: asalman.qazi
13 Replies
5. Shell Programming and Scripting
I am migrating from a host to another and I am trying to mimic the attributes on the old server.
Only problem is I can't figure out a fast way. Any recommendations?
Initially I thought about listing all my files on my previous host, but for some reason the listing of all files produced... (2 Replies)
Discussion started by: raykon
2 Replies
6. UNIX and Linux Applications
Hi,
i have a server installed samba+openldap (pdc). Need to migration windows server 2003 (active directory) object users, computers.
Where you can read how to do it? Or can tell me how to do it?
Thanks.
P.S. Sorry for bad english (0 Replies)
Discussion started by: ap0st0l
0 Replies
7. Web Development
Hello everyone,
I would like to setup a lamp server from a minimal distro and to compile PHP, MySQL and Apache myself.
I have chosen CentOS minimal for the OS and I am trying to build the stack by hand... But well, it appears I need some help!
First: I am looking for good and recent... (3 Replies)
Discussion started by: freddie50
3 Replies
8. AIX
Hi,
Existing several p5 server with lpar (aix5.3), also implemented with hacmp.
And now planning to buy new set of server (installing aix7.1)and SAN to replace the existing server.
My question is, how to perform data migration from old server/SAN to new server/SAN.
Suppose I install... (6 Replies)
Discussion started by: Oceanlo2013
6 Replies
9. Solaris
hi all,
i am refreshing my hardware, but i do not want to do a clean installation/reinstallation.
I am wondering if i could do
- do a ufsdump of the / partition (into a file on a nfs share)
- bootup using cdrom in the new machine
- mount the boot device/slice, and restore the ufsdump on... (7 Replies)
Discussion started by: javanoob
7 Replies
LEARN ABOUT SUSE
apache::session::lock::mysql
Session::Lock::MySQL(3) User Contributed Perl Documentation Session::Lock::MySQL(3)
NAME
Apache::Session::Lock::MySQL - Provides mutual exclusion using MySQL
SYNOPSIS
use Apache::Session::Lock::MySQL;
my $locker = Apache::Session::Lock::MySQL->new();
$locker->acquire_read_lock($ref);
$locker->acquire_write_lock($ref);
$locker->release_read_lock($ref);
$locker->release_write_lock($ref);
$locker->release_all_locks($ref);
DESCRIPTION
Apache::Session::Lock::MySQL fulfills the locking interface of Apache::Session. Mutual exclusion is achieved through the use of MySQL's
GET_LOCK and RELEASE_LOCK functions. MySQL does not support the notion of read and write locks, so this module only supports exclusive
locks. When you request a shared read lock, it is instead promoted to an exclusive write lock.
CONFIGURATION
The module must know how to connect to your MySQL database to acquire locks. You must provide a datasource name, a user name, and a
password. These options are passed in the usual Apache::Session style, and are very similar to the options for
Apache::Session::Store::MySQL. Example:
tie %hash, 'Apache::Session::MySQL', $id, {
LockDataSource => 'dbi:mysql:database',
LockUserName => 'database_user',
LockPassword => 'K00l'
};
Instead, you may pass in an already opened DBI handle to your database.
tie %hash, 'Apache::Session::MySQL', $id, {
LockHandle => $dbh
};
AUTHOR
This module was written by Jeffrey William Baker <jwbaker@acm.org>.
SEE ALSO
Apache::Session
perl v5.12.1 2008-01-08 Session::Lock::MySQL(3)