How to Convert informix to MySQL?

Code:

<?php 
//Write the data to the database

$results=mysql_query("INSERT INTO $db_table  
      VALUES ('$rec[0]', '$rec[1]', '$date', '$rec[3]')") or

  die('Error making query');

I get back 'Error making query'

[Join us @ facebook]

First try this :

Code:

<?php 
//Write the data to the database

$results=mysql_query("INSERT INTO $db_table  
      VALUES ('$rec[0]', '$rec[1]', '$date', '$rec[3]')") or die('Mysql error : '.mysql_error().'<br />');

and let us know what is the error that it gives.

Ah got it, made a typo in the table name 

[Join us @ facebook]

hehe, ok

Oke, I do have a data problem now: the filling of the table works untill I encounter a record that has a ' in the data...

[Join us @ facebook]

Oke, I do have a data problem now: the filling of the table works untill I encounter a record that has a ' in the data...

That is an easy one :

Code:

<?php
$records = explode("\n", $input); //$input = the data you have
foreach ( $records as $l )
{
    $rec = explode('|', addslashes( substr($l,0,-1) ));
    //Do something with the $rec
}

thats it Thanks!

[Join us @ facebook]

Now you should pack this and make a nice tutorial about this

I might just do that

oke, still not done
One of the data files is quite big (50MB) I've tried a few records first to see if the conversions in my php script where working and they did. Now after trying the script on the 50MB file I get a "Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request." page.
I've just contacted the hosting provider and they say: "PHP works fine on the server, you can try to upload your custom php.ini file."
What should be in the php.ini file to fix my problem?

[Join us @ facebook]

Just put this in the first line of your php file :

Code:

<?php
set_time_limit(0);

that didn't do anything

[Join us @ facebook]

Then the problem is the memory.

Check the memory_limit directive in the php.net site

I've tried

Code:

memory_limit = 200M

in my php.ini, but that doesn't work...

tried several other ways, but still no luck... I've now chopped the file into smaller pieces to get them in the database

[Join us @ facebook]

tried several other ways, but still no luck... I've now chopped the file into smaller pieces to get them in the database

Is it working with smaller files?

yes, I now have 12MB files and there is no problem with them

[Free WordPress Themes]

yes, I now have 12MB files and there is no problem with them

I have this too, tried to import 1mio addresses into a table, it doesn't work with one file. Now I use chunks with less data.

[Join us @ facebook]

This is because you execute php through a web server.

If you execute the same script as CLI (from dos/console) it will be ok with any size of file, unless the operating system can't handle it.

[Free WordPress Themes]

This is because you execute php through a web server.

If you execute the same script as CLI (from dos/console) it will be ok with any size of file, unless the operating system can't handle it.

that should be true
(I'm happy to run php code, now what next ?)

most of the people can't run scripts because they are using a shared host...

[Guest]

[36.906]

Yahoo crawler, Googlebot, Baidu Spider