[ic] "upgrade" from DBM files to a MySQL server solution in IC
racke at linuxia.de
Thu Apr 15 10:55:34 EDT 2004
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 should
> >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.
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team
More information about the interchange-users