Copying data from MySQL to Oracle

[riskhan]

Hi friends

I am developing a PHP program with support of MySQL and Oracle. I like to copy table data from MySQL to Oracle. MySQL table contains more than 250000 records. When i starts running php script, only 4000 records copied into oracle tables. Can any one help me to solve this problem.

Thanks in advance

Krishna Kumar

[ak1dnar]

Hi friends

I am developing a PHP program with support of MySQL and Oracle. I like to copy table data from MySQL to Oracle. MySQL table contains more than 250000 records. When i starts running php script, only 4000 records copied into oracle tables. Can any one help me to solve this problem.

Thanks in advance

Krishna Kumar

The top most reason for this might be time out problem.I think you can change the settings for increase the execution time in php.ini.

Change it to -1, I guess.

; Maximum time (in secondes) for connect timeout. -1 means no limit
mysql.connect_timeout = 60

[make sure to re-start your Node after changes to php.ini]

[riskhan]

The top most reason for this might be time out problem.I think you can change the settings for increase the execution time in php.ini.

Change it to -1, I guess.

; Maximum time (in secondes) for connect timeout. -1 means no limit
mysql.connect_timeout = 60

[make sure to re-start your Node after changes to php.ini]

Very Very Thanks Thanks Thanks
ajaxrand

Krishna Kumar

[ak1dnar]

Very Very Thanks Thanks Thanks
ajaxrand

Krishna Kumar

Have you figured it out ? Is it working?

[pbmods]

Changed thread title to better describe the problem.