Probleme mit db lock

Hi there,

i have execute an php script which as locked my entire db access.
here is my script:

if ($_SESSION["loginUsername"])
$query = "LOCK TABLES inventory READ, items WRITE";
else
$query = "LOCK TABLES inventory READ,
orders WRITE,
items WRITE";


in fact this query should only lock this tables not the entire access.

if try manually to unlock via pma i donīt get access to this db!


what can i do now?
STORMFIELD [ Mi, 04 Juli 2007 12:53 ] [ ID #1759445 ]
Datenbanken » de.comp.datenbanken.mysql » Probleme mit db lock

Vorheriges Thema: Load data Fehler - aber warum?
Nächstes Thema: DB designfrage