[ic] "upgrade" from DBM files to a MySQL server solution
in IC 4.8.7
info at eros-shop.co.uk
Thu Apr 15 15:00:44 EDT 2004
At 15:55 15/04/2004, you wrote:
>On Thu, 15 Apr 2004 15:29:49 +0000
>"Lyn St George" <lyn at zolotek.net> wrote:
> > On Thu, 15 Apr 2004 13:12:16 +0100, Mark Bryant wrote:
> > >
> > >Hi Everyone,
> > >
> > >I'm thinking it's about time that I stopped using DBM files and moved
> to an
> > >SQL based solution with my IC install. The site it getting quite busy and
> > >I'm hoping to improve its performance by changing to MySQL. The other
> > >benefit, of course, that we'll be able to share the DB data with other
> > >applications more easily.
> > >
> > >So, on to my (probably) daft question....
> > >
> > >Does anyone know the location of a complete HOWTO doc that covers the
> > >conversion process including the importing of the existing DBM file data
> > >into the MySQL server or does anyone have one they are prepared to share?
> > >I've not altered the tables in any way or added new fields (although I am
> > >using the odd redundant table field to store data I need/want rather than
> > >use it for it's intended purpose and have to add new fields), so it
> > >be relatively straight forward?
> > This is one way which works:
> > 1. backup all of your import files (products.txt, transactions.txt, etc)
> > 2. make an html page with [tag export transactions transactions.txt][/tag]
> > and so on for every table you have, and put this in your pages directory.
> > 3. browse to that page and your 'import files' are now updated
> > 4. in variable.txt, set 'mysql <tab>1', 'SQLDSN<tab>dbi:mysql:test_vwe'
> > (being a 'test_*' table it will be created without a username or password)
> > 5. restart IC and break out a cold beer.
>I recommend to copy the whole catalog and test the conversion first.
>Especially you need to check if the field sizes in the SQL database
>are sufficient for your data.
Many thanks for that great set of instructions, it's much appreciated :)
I'll give them a go once I'm able to resolve the other bits of the copy and
trial process ;)
You say that stuff about copying catalogs like I should already know how to
run off a working copy, which sadly I don't. I'm sure it's easy enough when
you know how (or have a vague clue where to start). Could you support this
idea with some kind of process/procedure I should be following to achieve
Also, did you have any particular fields (bearing in mind I'm using a
default foundation install) that are likely to be affected and be too short
after conversion? I assume you've hit this one before and is why you're
suggesting I look out for it? A list of potentials is going to save me a
lot of time :)
Many thanks :)
vwe internet ltd
PO BOX 1067
Shop - http://www.eros-shop.co.uk
EMail - info at eros-shop.co.uk
Tel - 0870 737 3369
Fax - 0870 737 4469
More information about the interchange-users