02-03-2014
FYI, this is a forum dedicated to unix and linux systems.
You might not get a response when asking about mysql on windows in these forums.
This User Gave Thanks to Neo For This Post:
8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am trying to import 22 .dmp files but facing the problem with the last table file it never ends the import command, only the table is created but the rows of the table don't get imported.
This is the problem with only ine table rest 21 tables are being imported properly.
Thanks in... (2 Replies)
Discussion started by: anushilrai
2 Replies
2. UNIX for Advanced & Expert Users
I'm hoping someone can help get me moving in the right direction here, so bear with me.
I've got 2 RedHat Linux servers, let's call them A & B.
- A receives "sensitive" files, which are PGP encrypted, and immediately sends them off to B for decryption/processing/deletion
- B needs to make... (1 Reply)
Discussion started by: peteroc
1 Replies
3. Programming
I'm an absolute newbie for unix...
For my work, I have to import a xml file in our system (jsp+sql) via putty telnet.
Once i have copied the file in the right directory, I launch this command:
./thisImport -i input/thisImport/newimport.20071130.xml -l 10 -t
this is a test (as you can see),... (1 Reply)
Discussion started by: tranky
1 Replies
4. Shell Programming and Scripting
Hi All,
I'm try to import a Calendar in Autosys using below command,
autocal_asc -I TKY_Test
Utility to Add/Delete or Print entries in Calendar.
Calendar Name:
But it not allowing me to import the calendar, it asks for the calendar which is similair if we try to manually add calender... (1 Reply)
Discussion started by: arvindcgi
1 Replies
5. Shell Programming and Scripting
Is anyone here know how to make a script in UNIX which will do importing data from PL/SQL then sending it through mail? Can you give me sample script with explanation so it's easy to understand,Thank you very much,any suggestion or advice is welcome, (1 Reply)
Discussion started by: Atrap
1 Replies
6. UNIX for Dummies Questions & Answers
hi guys
I'm added a new disk to my server (virtual environment)
It used to be a Volume Group=Vol_Group01
and Logical Volume= Log_Vol_01_Data
and I see /dev/sdb
Disk /dev/sdb doesn't contain a valid partition table
Disk /dev/sdc: 133.1 GB, 133143986176 bytes
255 heads, 63... (3 Replies)
Discussion started by: karlochacon
3 Replies
7. Shell Programming and Scripting
hi
i want to retrieve talespace, datafile's path , size and another size in following querry in shell
Create Tablespace 'A' Datafile 'Some
Path' Size '10G' extent management Local uniform size '64M';
from another file say 'A.txt' where i ll dumb data in sequence separated by commas... (2 Replies)
Discussion started by: Gl@)!aTor
2 Replies
8. Solaris
A couple of spare disks have been added to a Solaris 10 system, and one of them has a corrupt zpool on it.
I don't care about the data: I want to destroy it and re-use the disk, but it's corrupt so I can't import it. The corrupt pool is called "rpool" so I don't want to destroy it by name... (2 Replies)
Discussion started by: Mysturji
2 Replies
LEARN ABOUT DEBIAN
cgi::session::driver::mysql
CGI::Session::Driver::mysql(3pm) User Contributed Perl Documentation CGI::Session::Driver::mysql(3pm)
NAME
CGI::Session::Driver::mysql - CGI::Session driver for MySQL database
SYNOPSIS
$s = CGI::Session->new( 'driver:mysql', $sid);
$s = CGI::Session->new( 'driver:mysql', $sid, { DataSource => 'dbi:mysql:test',
User => 'sherzodr',
Password => 'hello' });
$s = CGI::Session->new( 'driver:mysql', $sid, { Handle => $dbh } );
DESCRIPTION
mysql stores session records in a MySQL table. For details see CGI::Session::Driver::DBI, its parent class.
It's especially important for the MySQL driver that the session ID column be defined as a primary key, or at least "unique", like this:
CREATE TABLE sessions (
id CHAR(32) NOT NULL PRIMARY KEY,
a_session TEXT NOT NULL
);
To use different column names, change the 'create table' statement, and then simply do this:
$s = CGI::Session->new('driver:mysql', undef,
{
TableName=>'session',
IdColName=>'my_id',
DataColName=>'my_data',
DataSource=>'dbi:mysql:project',
});
or
$s = CGI::Session->new('driver:mysql', undef,
{
TableName=>'session',
IdColName=>'my_id',
DataColName=>'my_data',
Handle=>$dbh,
});
DRIVER ARGUMENTS
mysql driver supports all the arguments documented in CGI::Session::Driver::DBI. In addition, DataSource argument can optionally leave
leading "dbi:mysql:" string out:
$s = CGI::Session->new( 'driver:mysql', $sid, {DataSource=>'shopping_cart'});
# is the same as:
$s = CGI::Session->new( 'driver:mysql', $sid, {DataSource=>'dbi:mysql:shopping_cart'});
BACKWARDS COMPATIBILITY
As of V 4.30, the global variable $CGI::Session::MySQL::TABLE_NAME cannot be used to set the session table's name.
This is due to changes in CGI::Session::Driver's new() method, which now allows the table's name to be changed (as well as allowing both
the 'id' column name and the 'a_session' column name to be changed).
See the documentation for CGI::Session::Driver::DBI for details.
In particular, the new syntax for "new()" applies to all database drivers, whereas the old - and bad - global variable method only applied
to MySQL.
Alternately, call $session -> table_name('new_name') just after creating the session object if you wish to change the session table's name.
LICENSING
For support and licensing see CGI::Session.
perl v5.12.4 2011-07-08 CGI::Session::Driver::mysql(3pm)