InterBase (29)
MS-SQL (5)
mysql (37)
Oracle (1)
Exchange Links
About this site
Lock an entire mysql database with all its tables
11 comments. Current rating: 
(6 votes). Leave comments and/ or rate it.
Question:
How can I lock my entire mysql database? And how can I lock a single table?Answer:
Go to the mysql shell and use the FLUSH command.This clloses all open tables and locks all tables for all databases with a read lock until you execute UNLOCK TABLES. This is very convenient way to get backups.
 |  | |
FLUSH TABLES WITH READ LOCK; /* alternatively lock a single table: LOCK TABLES customers READ; */ /* running my backup */ UNLOCK TABLES; | ||
 |  |
|
||||||||
Comments:
| ||
|
Hai all,
This information about the MySQL in nice.. thank u..!  Keywords: | ||
| ||
|
thanks
| ||
| ||
|
I guess you're talking about a filesystem backup, as you wouldn't need to lock anything if backing up the database.
| ||
| ||
| ||
|
Dear
How can i lock all the tables of a single database or to lock a particular table. Thanks Anil | ||
| ||
|
lock tables db.* read;
| ||
| ||
 Keywords: | ||
| ||
 Keywords: | ||
| ||
|
What u have to do to lock all tables...
Get all tables ( select * from information_schema.tables ) and put in a Cursor... Iterate in cursor and lock each table... ( Lock Table X ) | ||
| ||
|
Wf7fBs <a href='
 http://aedcqianhedk..lt;/a>, [url= http://skzohrxgwytv..ytv[/url], [link= http://ydjtdjsgecud..ud[/link], http://lmkmjtaghekw.com/ | ||
| ||
|
FLUSH TABLES WITH READ LOCK; works just fine in locking all the tables in a databse.
|
