Roland RoLaNd Database lock on mysql import - Information
Sep 10, 2012; 10:38
Roland RoLaNd
Database lock on mysql import - Information
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 ? )
Sep 10
Johnny Withers Re: Database lock on mysql import - Information
Sep 10, 2012; 06:09
Johnny Withers
Re: Database lock on mysql import - Information
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!