MySQL will only allow one webpage at a time to query

[lucas]

This is on a personal server so it does not have anything to do with insiderhosting.

I have a high load script I am using to move some data from one db to another and it is causing the rest of the site to freeze because MySQL is not allowing the scripts in the other pages to access the database so they hang until the script is finished.

I have a fairly default version of MySQL running, what could be the problem?

[Sardtok]

I believe it locks all tables that are in use,
this is to make sure that two connections don't try to write to the same tables.
It is possible to unlock the tables with a query though...

Just search for it on mysql, sorry that I don't do it for you, but I'm sick and feel like ****...