Dear all,
I realize this is a very newbie question so bear with me please.
I know that when you import/export a DB its tables are locked to ensure consistency and no
data corruption.
but why would other DBs on the same server get locked if im importing/exporting one DB ?
in other words:
exporting/importing X DB.
will lock every other DB on the server up until it's done.
and is there another way to move a DB from X to N on the same server using rsync/cp or
something of that sort (without using mysqldump which would lock DBs ? )
