[ic] "upgrade" from DBM files to a MySQL server solution in IC 4.8.7

[Stefan Hornburg]

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.

	Racke

-- 
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team