Moving SQL Database to Another ISP?

[wildview1]

Hi, I’m trying to move our DB to another ISP service, but when importing the DB is dumps the wp_newsletter table because it’s locked. How do I unlock the newsletter table so the import will work?

Here is the error:
LOCK TABLES `wp_newsletter` WRITE;
/*!40000 ALTER TABLE `wp_newsletter` DISABLE KEYS */;

Thanks,
R.

[Stefano]

Hi, there is no reason to have that table locked, I don’t know why. I moved database from different providers many time without problem. Try to remove the lock from the dump.

Stefano.

[Author]

Posts