ravi_sdl

t

Hello, Thanks for reply. I am try to make connection as below: mysql_connect('remotesite.com:3306', 'user', 'password') or die(mysql_error()); It show "Connect failed: Unknown MySQL server host 'remotesite.com:3306' (1)" error.

Hello, Thanks for reply. I am try to make connection as below: mysql_connect('remotesite.com:3306', 'user', 'password') or die(mysql_error()); It show "Connect failed: Unknown MySQL server host 'remotesite.com:3306' (1)" error.

Nothing is set to prevent database connection. I can easily establish simple database connection. I think i am missing some steps. You can read above remote database connection steps which are followed by me.

Thanks for your reply. I have already added ip address in remote mysql host to provide access. Also as you suggested i have created a connection using "mysqli" but still it is not connected.

Hi, I want to establish remote database connection. I have detail of database, user name and password. I tried to create a remote connection but it not connected to remote server. For example my website name is "http://test.com" and another website name is "http://remotesite.com". I want to fetch data of http://remotesite.com from http://test.com. I have followed following steps: 1. Firstly login at http://remotesite.com control panel and click on remote database icon and enter http://test.com and its ip information. 2. I make a connection in http://test.com to connect with http://remotesite.com. I have used following tricks. (a). mysql_connect("http://remotesite.com","username","password"); mysql_select_db("database_name"); (b). mysql_connect("http://remotesite.com:portname","username","password"); mysql_select_db("database_name"); ©. mysql_connect("IP Address:portname","username","password"); mysql_select_db("database_name"); (d). mysql_connect("IP Address","username","password"); mysql_select_db("database_name"); But it is not connect with remote database. It means not connect with http://remotesite.com database. Any on can help me in this regards. Thanks,

Thanks for reply. I will use array_chunk() and try to fix my issue. I will back after use array_chunk(). Thanks..

Hi, I want to insert large xml feed data into mysql. XML feed size is 450mb. It will take approx 4-5 hrs to insert records in data base. I have write a code which are not working properly. Means it show maximum execution time error. It will insert only 20-25 thousand records into mysql table. I have already set "ini_set" code for maximum_execution_time but it is not working. Anyone can suggest any tips. Please note that script will take 4-5 hrs to execute. Is any method to execute php code in backend or any setting in mysql. Please suggest me about this issue. Regards, Ravi