Sponsored Content
Full Discussion: Oracle to MySQL through Unix
Top Forums UNIX for Dummies Questions & Answers Oracle to MySQL through Unix Post 46472 by Z24_2000 on Friday 16th of January 2004 03:06:05 PM
Old 01-16-2004
Thanks for all of the input

Hi All,

thank you for taking the time to respond to my post.

As it stands, it appears I am going to go with a driect data grab from the Oracle DB using a PHP script then a driect write to the the MySQL DB using PHP as well.

Thanks again,
Andrew
 

7 More Discussions You Might Find Interesting

1. HP-UX

Restore of oracle 8i from hp unix 11.0 to HP unix 11i

Hi, We are planning to migrate oracle 8.1.7.2 (8i) currently installed on a host with HP unix 11.0 to a host with HP Unix 11i. The method we are adopting is backup and restore of all file systems. Could this be a problem, apart from linking libraries on the target system. Thanks for the... (1 Reply)
Discussion started by: amitb
1 Replies

2. UNIX for Dummies Questions & Answers

Unix is killing mysql or something else is happening

I don't know what is happening but none of my queries work. When I start mysql, even the use <database> option fails... So when I start mysql with -A, it atleast opens the database and shows the tables. But now, when I perform even a select option on the database, it hangs... Repair is not working... (5 Replies)
Discussion started by: Legend986
5 Replies

3. UNIX for Dummies Questions & Answers

Connect MySQL database from Unix

How to connect a MySQL database from unix using unix shell scripting ( people are using perl scrpt to connect the same database). I want to access a MySQL database through a shell script (4 Replies)
Discussion started by: apsprabhu
4 Replies

4. UNIX and Linux Applications

couldn login mysql in unix ...

hi am getting this error when i tried to login in unix.. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) but my application works fine... can u guide me,, (0 Replies)
Discussion started by: senkerth
0 Replies

5. Shell Programming and Scripting

Error in installing mysql on unix server

Hi , I am trying to install mysql but getting below error $# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) can anyone provide me this file 'mysql.sock' Thanks (6 Replies)
Discussion started by: aish11
6 Replies

6. UNIX and Linux Applications

Please help: Oracle gqsql or sqlplus output format like mysql

On psql select titolo,lingua from titolo where titolo ~* 'brivid'; titolo | lingua ------- + ------ Brivido | 1 On Sqlplus/gqsql SQL> select titolo,genere,anno,lingua from titolo where titolo like '%rivid%'; TITOLO... (6 Replies)
Discussion started by: Linusolaradm1
6 Replies

7. Programming

MySQL query does not work on Oracle 11g

Dear community, I have to make a "simple" query on ORACLE 11g DB who will output ONLY numbers in field1 who exceeded a specific threshold. In other words, assuming I have the following data in database. FIELD1 FIELD2 FIELD3 ========= ============== ... (3 Replies)
Discussion started by: Lord Spectre
3 Replies
IGNORE_USER_ABORT(3)							 1						      IGNORE_USER_ABORT(3)

ignore_user_abort - Set whether a client disconnect should abort script execution

SYNOPSIS
int ignore_user_abort ([string $value]) DESCRIPTION
Sets whether a client disconnect should cause a script to be aborted. When running PHP as a command line script, and the script's tty goes away without the script being terminated then the script will die the next time it tries to write anything, unless $value is set to TRUE PARAMETERS
o $value - If set, this function will set the ignore_user_abort ini setting to the given $value. If not, this function will only return the previous setting without changing it. RETURN VALUES
Returns the previous setting, as an integer. EXAMPLES
Example #1 A ignore_user_abort(3) example <?php // Ignore user aborts and allow the script // to run forever ignore_user_abort(true); set_time_limit(0); echo 'Testing connection handling in PHP'; // Run a pointless loop that sometime // hopefully will make us click away from // page or click the "Stop" button. while(1) { // Did the connection fail? if(connection_status() != CONNECTION_NORMAL) { break; } // Sleep for 10 seconds sleep(10); } // If this is reached, then the 'break' // was triggered from inside the while loop // So here we can log, or perform any other tasks // we need without actually being dependent on the // browser. ?> NOTES
PHP will not detect that the user has aborted the connection until an attempt is made to send information to the client. Simply using an echo statement does not guarantee that information is sent, see flush(3). SEE ALSO
connection_aborted(3), connection_status(3), Connection Handling for a complete description of connection handling in PHP. . PHP Documentation Group IGNORE_USER_ABORT(3)
All times are GMT -4. The time now is 03:02 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy