Advertisement:

Database Lock/Unlock

Aloittaja pixeleyes, lokakuu 19, 2010, 10:43:48 AP

« edellinen - seuraava »

pixeleyes

Recently my account was suspended cause of overloading. After request they give me backup.

But in Database SQL file I have confusion, many table have like that  LOCK & UNLOCK?

Why tables are like this and whether after uploading it will unlock automatically?

LOCK TABLES `pknfrm_aeva_albums` WRITE;
/*!40000 ALTER TABLE `pknfrm_aeva_albums` DISABLE KEYS */;
/*!40000 ALTER TABLE `pknfrm_aeva_albums` ENABLE KEYS */;
UNLOCK TABLES;

JimM

Did you use mysqldump to make your backup?  I think that is a something that you see when using that. Try Google for additional information.
Jim "JimM" Moore
Former Support Specialist

pixeleyes

I didnt make backup myself, actually the hosting company sent me backup like that.

Anyway problem is solved,

when i uploaded database all tables unlocked automatically and working fine.

Advertisement: