direct copying/ftp in mysql/data

[patlv23]

noticed some weird behavior.
we're using 3.23.49 on solaris 2.6.

first, we binary ftpd the contents of a working database, say the contents of data/origdb/ folder, to windows. then we made a new directory data/newdb. We then binary ftpd the db files from windows to data/newdb. after which we applied the permissions and ownership of origdb to newdb(mysql:mysql 775 for dir, 660 for inside dir). when we run mysql (mysql -u "root" -p), then tried to insert into a table which already has contents, it displayed "Error 1036: Table 'newdbtable1' is read only". same error also when deleting. if we tried to insert into an empty table, it was ok.

So to experiment, we tried to just copy (with cp) a whole db directory (origdb to newdb2) then we fixed the permissions. it worked normally. anybody knows what's going on?

 

[piti]

i do not have a solution for your prob, but i always do taz/bzip2-ing before moving database between computers and everything works well

 

[patlv23]

thanks piti!

you're right we should probably just use tar all the time. well, we usually do, just experimented a bit =)