I am having to operating MySQL 4.0.18, I had heared that I could copy a db
folder out of the mysql/data folder to the same folder on a different machine
running its own local host server and that server would have a copy of the
database. HOWEVER, o some occasions this seemed to work Ok, and on others I
could use db, show tables etc, but on select I got a failure (which
unfortunately I have not copied sorry) something to do with finding?
<tablename>.innodb.
Now as far as I know both servers were at the same version and both had innodb
enabled and I THNK I quit both clients before copying.
Is this a valid way to copy a db or only sometimes. Should I really always use
mysqldump. Although I am suspecting given the amount of data this may make for
a v large sql file?
Can some-one advise this newbie, thanks,
Andrew H
