Creating a new db using DBI

All - Using MySQL under Linux. I'd like to create a new database using the DBI. I thought I could connect to the test database, create the new database, assign grants, then reconnect to the new database. I'm trying to connect to the test database without a username or password and I'm getting an

Remote MySQL Backups

ick I didn't know about. Thought about using the telnet module to perform these tasks, however, would prefer to do it under DBI. Any suggestions? Thanks, Mark - Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED]

Populating indexed versus non indexed tables

populating an indexed table. But is it still faster than creating indexes afterwards? Some of the tables might be fairly large (a few million records each). Thanks, Mark - Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED]

DBI, Access, and DATETIME

e 171. SELECT execute ERROR for sa table: DBI::db=HASH(0x236cc78)->errstr Is this a quirk with Access - seemed to work ok with MySQL. Any suggestions/workarounds? Thanks, Mark - Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED] Office: (732) 528-9305 Fax: (732) 528-9308 Cell: (732) 996-7630

Transferring from Access to MySQL

QL. 2. Export the table from Access, then use a load data file to pull it into MySQL. Each of the exported files is ~ 1 GB. Any other suggestions? How would you do this? Thanks, Mark - Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED]

Float vs. double in MySQL

y idea what's causing the problem? Am I missing something obvious? Thanks for the help, Mark - Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED]

FW: Dynamic DSN generation?

te the DSN creation without having to run the ODBC Data Source Administrator for each database? Thanks, Mark - Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED]

Placeholders and select

y does it say that I need 2 bind variables? I know that there is an issues with selects, placeholders, and NULLs, but I don't think that this is the issue here. Any suggestions? Thanks for the help, Mark - Mark Riehl Agile Communications, Inc.

MySQL Question

111 (command bound to event) I establish the connection and successfully make the query - I can see the results when I have the trace on, but I can't seem to track down the problem. Works fine locally, problem using it remotely. Account, password, and permissions are correct, no firewalls. Any

dump_results() Question

All - I'm running under ActiveState on Win2k and using MySQL. I'm using dump_results() to print the results of a database query. I need to print the same result to multiple files with different delimiters and formats. Questions 1. Is there a way to use the same statement handle result set witho

MySQL DBI Error

All - I'm using ActiveState, MySQL, and Win2k. I'm trying to insert data into the following table: +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+--

Signal Woes

or die "Can't connect to mysql on 127.0.0.1: $DBI::errstr\n"; # Assume result from the db is named result. my $result = "Test"; print "Disconnecting \$dbh\n"; $dbh->disconnect() or warn "Disconnection failed: $DBI::errstr\n"; r

Creating a new database using DBI?

s possible, anyone have any examples? Thanks, Mark -- Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED] Business: (732) 528-9305 Fax: (732) 528-9308 Cell: (732) 996-7630

RE: PPM available for DBD-Oracle 1.12 (OCI8)

e DBD-Oracle8 [1.06] Oracle 8 database driver for the DBI module PPM> install DBD-Oracle-1_12 Install package 'DBD-Oracle-1_12?' (y/N): y Installing package 'DBD-Oracle-1_12'... Bytes transferred: 98144 Mark -- Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED

DBI and Signals

ect to mysql on 127.0.0.1: $DBI::errstr\n"; # Assume result from the db is named result. my $result = "Test"; print "Disconnecting \$dbh\n"; $dbh->disconnect() or warn "Disconnection failed: $DBI::errstr\n"; return ($result); } sub catch_int

RE: mod_perl and DBI

Mark -- Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED] > -Original Message- > From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 17, 2001 1:56 PM > To: 'Wilson, Doug '; ''Mark Riehl' '; ''[EMAIL PR

mod_perl and DBI

see an increase in speed if I had a large number of simultaneous users? Thanks, Mark -- Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED]

Anyone using PostgreSQL?

All - Just curious if anyone is successfully using DBI with PostgreSQL under Linux? I don't see a lot of traffic about it and may need to use it in the near future. Thanks, Mark -- Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED]

DBI and Signals

cting \$dbh\n"; $dbh->disconnect; return ($result); } sub catch_int { my $sig = shift; print "Caught $sig\n"; $quit++; } -- Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED]

Easiest way to tell if a table already exists?

ble exists. Any other way (other than calling $dbh->tables() and looping through the results? Thanks, Mark -- Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED]

DBI in sys design

7;d prefer option 1. Any suggestions? Thanks, Mark -- Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED]

Embedding DBI into a C++ app?

gone some through some of the CPAN docs. I'm looking for a solution that will let me (easily) run the same C++ (headless daemon) app under Win2K, Linux, and Solaris that can to connect to Oracle and MySQL. If this works, it would be just what I'm looking for. Thanks, Mark -- Mark Riehl

Looking for suggestions

he C++ app, open a socket from the C++ app to the Perl app, and take advantage of the DBI. The large number of databases supported by the DBI really helps me out. Any ideas? Thanks for the help, Mark -- Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED]

DBI Capability Questions

with each other? 3. Are some database interfaces better supported than others? 4. If I set up the Perl DBI using CGI on a Win 2K machine, it should work the same on a Linux or Solaris box, correct? Thanks for the help, Mark -- Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED]