When you say locked, do queries on the other databases fail with an
error? If so, whats the error? Is it all queries, or just inserts?
Also, how are you doing your export and import?
Sent from my iPad
On Sep 10, 2012, at 2:38 AM, Roland RoLaNd <r_o_l_a_n_d@stripped> wrote:
> 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 ? )