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.