Is it possible to move myIsam frm/myd/myi files across servers with the rsync command, or otherwise?
Two use cases for me. (1) Load large amount of data locally, index and optimize, then move to Python anywhere. (2) Transfer data out of Python anywhere for local post processing (avoiding the relatively inefficient mydqldump procedure, which is slow and requires considerable scratch space).
You do not have access to the underlying data files on PythonAnywhere. You will need to use mysqldump to move your data to and from PythonAnywhere.
Thanks for your quick reply.
Does it also mean that it isn't possible to run myIsamchk (to disable/rebuild indexes when bulk loading)?
How would you suggest to bulk load tables with 200M rows?
Does it also mean that it isn't possible to run myIsamchk (to disable/rebuild indexes when bulk loading)?
Unfortunately not :-(
How would you suggest to bulk load tables with 200M rows?
Unfortunately I think mysqldump/mysql are the best way.
glenn
|
9718
posts
|
PythonAnywhere staff
|
