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 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 ? )
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql