OpenVMS VAMP Board

I have also posted this to the VMS-MYSQL list:

I have managed to install MYSQL 051 successfully up to the point of running 'first_start' - I get this error:


first_run_mysqld
InnoDB: Error: auto-extending data file /mysql051_root/data/ibdata1 is
of a different size
InnoDB: 640 pages (rounded down ...

Kalle,

Thanks for the advice - it seems to work fine. Still - a bit non-intiative - shut it down 3 times to get it to actually shutdown seems a bit OTT. Nonetheless, it works, is simple and seems reliable - no complaints.

Regards

Paul

Gents,

I have an application that needs to store arrays in MYSQL and process them in PHP. The elements are either floating point numbers or timestamps. There may be up to 2000 elements and hundreds of arrays. THe only scheme I can think of now is to convert each array to a comma seperated string ...

Gents,

MYSQL does not react well to a system crash (this being VMS, only upon power failure) but also a normal systems shutdown. I then discovered the mechanism in MYSQLADMIN and instructed the server to SHUTDOWN (yes - 2x as it advises!). I would have thought shutting the server down twice would ...

Gents,

I know it is bad form to answer yourself ( and indeed somewhat suspect to be talking to one's self...) But as I have a partial answer ...

There seems to be a bug (or undocumented behavoiur) with fwrite in as much as when a trailing '\n' is not present in the buffer, it fails to write. After ...

Gents,
Me again ...

I have managed to open a file and write one line to it. Unfortunately I ami trying to write multiple lines to it. To shorten the explaination, I offer the following code extract followed by comments:

$handle = fopen($ufname,"w");

///File opens OK

Later on in the script ...

Just to let you know - ran into this problem, found this item and it indeed solved the problem.
Thanks for a good site.

Paul

Gents

I know it is bad form to answer your own post but it is necessary when admiting ignorance (and even stupidity) and to keep you from wasting time ...

My simple error in the posted code is the ; at the end of the FOR statement. This (apparently) causes the statement to not execute.

:oops:
I ...

Gents,

Many thanks for your comments, I have the (now obvious) answer to the first question: The function I am trying to call (split_str) is PHP 5 only ...

IN the online version of the manual there is an example script which, when modified, does the trick however, I have now run into something ...

Thanks for the comment but I'm afraid, in the first instance, I can't control the input format - it is what the generating program gives and is not changeable. Having said that, I tried str_split (return each char to array element) but this does not exist in the VMS version of PHP (PHP 5 only ...

Gents,

I am processing a CSV (Comma Seperated Variables) record containing. in some cases further quoted commas. i.e:
1234,4567,"1,234",string
The quotes are supplied by the generating program and are there to indicate the encloded comma is not a field seperator. I can't seem to find a simple ...

Peter,

I am in your debt. I will have to study the differences to fully understand where I went wrong but in any case, the code you supplied does the trick

Many thanks

Paul

I' m new to php and would li :oops: ke some help. The function here explains what I want it to do:
function add2array(&$array,$index,$value)
//++
// add2array
// construct array ($ARRAY) where $value(s) are summed for duplicate $index
// eg. given a series:
// array index1 1
// array index2 2 ...