RE: Out of memory, mysqld got signal 6;

ly recommended to use official binaries. Sure, can do - but is this a known issue with 4.0.21? I wasn't able to find anything in the bug tracker... TIA, -- Andrew Hill Software Developer m3 Media Services Limited Kirkman House, 12-14 Whitfield Street, London W1T 2RF T: +44 (0)20 7299 7370

Out of memory, mysqld got signal 6;

The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. Fatal signal 11 while backtracing -- Andrew Hill Software Developer m3 Media Services Limited Kirkman House, 12-14 Whitfield Street, London W1T 2RF T: +44 (0)20

RE: Splitting data across tables

recreate them in less than 60 minutes... Cheers, -- Andrew Hill Developer Awarez Ltd. Kirkman House, 12-14 Whitfield Street, London W1T 2RF T: +44 (0)20 7299 7370 F: +44 (0)20 7299 7374 -- The information in this email is confid

RE: insertion of multiple rows

Hi Bruce, You might be interested in the LOAD DATA INFILE syntax. See http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html. The command can either be used to replace duplicate records on unique keys, or can ignore them. Cheers, -- Andrew Hill Developer Awarez Ltd. Kirkman House, 12-14 Whitfield

RE: Splitting data across tables

locks on the clients going crazy. That's why I was hoping there was a way of making MySQL select the table to insert into based on the time... TIA, -- Andrew Hill Developer Awarez Ltd. Kirkman House, 12-14 Whitfield Street, London W1T 2RF T: +44 (0)20 7299 737

Splitting data across tables

n the time? Any ideas or comments? TIA, -- Andrew Hill Developer Awarez Ltd. Kirkman House, 12-14 Whitfield Street, London W1T 2RF T: +44 (0)20 7299 7370 F: +44 (0)20 7299 7374 -- The information in this email is confidential a

RE: [PHP] UPDATE Query works in odbc/Mysql, but fails in odbc/MS Access

mweb, MS points to a datetime issue: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q246570 As far as a reference - I'm guessing somewhere on MS's site? Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal D

RE: [PHP] Re: FOLLOW UP on "column names not liked by odbc/php/access"

mweb, I suggest you use the ODBC Metadata functions in PHP to describe your database, e.g. odbc_tables, odbc_columns, odbc_primarykeys, odbc_foreignkeys, etc. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access &

RE: [PHP] Problem connecting to mysql via odbc

Mweb, Set your ODBCINI environment variable (and others) as per the HOWTO at www.iodbc.org. This HOWTO is for iODBC, but the concepts are the same for this error condition. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data

RE: [PHP] Access to MYSQL via ODBC?

Mweb, This access to mysql conversion tool is availabe at the MySQL site - check the contributed software section for a couple of options. Alternatively, just run both MySQL and Access on Windows, and access it via ODBC. Best regards, Andrew Hill Director of Technology Evangelism OpenLink

RE: [PHP] Access to MYSQL via ODBC?

ons may be verified using "odbctest" application. Be sure to use the syntax "DSN=DSN_NAME" in odbctest. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers

RE: [PHP] Access to MYSQL via ODBC?

Sure, this is entirely possible. Configure PHP --with-iodbc as per the HOWTO at www.iodbc.org and then install the MyODBC driver. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Provi