From: Johnny Withers
Date: September 10 2012 11:09am
Subject: Re: Database lock on mysql import - Information
List-Archive: http://lists.mysql.com/mysql/228146
Message-Id: <-8687670680477590282@unknownmsgid>
MIME-Version: 1.0 (1.0)
Content-Type: text/plain; charset=ISO-8859-1

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 ? )
>