Access to Mysql

[Anon]

Hello,

I am haveing problems converting memo fields from Access into Text or Blob fiels in Mysql. I have written a script in PHP that connects via ODBC to the Access Database:

$query = "Select * from Films";
$result = odbc_do($connection,$query);

while(odbc_fetch_row($result)) {

$t1 = odbc_result($result,1);

}

this gives me the following error

FATAL: emalloc(): Unable to allocate 2043514880 bytes

I have found out that this only happens for MEMO fields. As soon as I change it to text, everything is cool. My problem is, that I cannot change the table to TEXT, so I have to find a solution on how to get the memo working...

any idea ?

Thanks

[Anon]

You might have better luck dumping the data out of Access as a tab delimited file and importing it into MySQL that way.
The other thing you might want to try is increasing the maximum memory allowed by a PHP script. I think it is normally set to about 8MB which is way, way less than what you are trying to allocate at ~2GB 🙂
You might also want to reduce your select to only return a single column at a time or a lower number of rows, that might also help with the memory. Select * on a table with lots of memo fields would probably eat too much memory.

Just some thoughts,

Tim Frank

[Anon]

Try this:
http://www.cynergi.net/exportsql/exportsql2b.txt

[Anon]

Perhaps you should try this: http://dbtools.vila.bol.com.br/
It's a tool to manage your mysql database (no matter where the server is) and it has an import wizard for access files and others.

Bye,
Marc