Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => Install and Upgrade Help => Aiheen aloitti: pixeleyes - lokakuu 19, 2010, 10:43:48 AP

Otsikko: Database Lock/Unlock
Kirjoitti: pixeleyes - lokakuu 19, 2010, 10:43:48 AP
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;
Otsikko: Re: Database Lock/Unlock
Kirjoitti: JimM - lokakuu 23, 2010, 06:42:21 IP
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.
Otsikko: Re: Database Lock/Unlock
Kirjoitti: pixeleyes - lokakuu 26, 2010, 12:39:59 AP
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.