Koozali.org: home of the SME Server

legacy database sync to mysql

Rich

legacy database sync to mysql
« on: February 11, 2003, 12:06:35 PM »
Hi all.

I am at the beginning of a tricky project, and seem to have fallen at the first fence.

I am trying to duplicate our crusty old production database on my nice new *shiny* e-smith 5.6 mysql. This allows me to run reports against it without inconveniencing everybody trying to use the real one.

Its not very elegant, but I thought I would run a script overnight:
*dumping the old database into ASCII files (6G, 280 files)
*copying them to an ibay
* build a fresh schema on mysql
* import files

I suppose listed like that I've fallen at the second fence. How can I get the files from my crusty AIX box onto e-smith ? The AIX box does NFS/NIS and rcp (plus any other insecure protocol you can think of) but does not do samba.

ftp works, but it involves a lot of fannying around, logging in and changing directories. I want something short and sweet that can be run straight from a shell., as the transfer will be done one file at a time. (I cannot dump all the files at once or I run out of room)

Any ideas ?



Rich.