If I cut and paste the create table commands one at a time, the tables do get created and appear when I do 'show tables' from the mysql command prompt. Now, I went to the setup.cgi program and Recreate .def files only, I get

Creating def file for Build_Update ... ok
Creating def file for Category ... failed (table doesn't exist?)
...
the rest of the def files also fail, so it's not seeing the tables that I cut and pasted into the mysql command prompt.

If I delete the tables, however, the Build_Update table does not get removed.

The mysql server and web server are on the same machine. It's not a virtual host, it's my own box. There are only about 20 or 30 sites on the box, max.

From what I see on the mysql list archive on listquest, it seems that mysql needs to fetch the results before doing the next query, but I'm not sure exactly what that means or how to fix it.... For example, this post refers to the same error message I appear to be getting - in case this starts pointing someone in the right direction.

http://www.listquest.com/lq/view.cgi?ln=mysql&mid=11709&sp=&q=Commands+out+of+sync&b=1&s=1&o=0&ci=c061704845

I know mysql runs fine, I have other databases running on the server that I work with every day, on a regular basis. FWIW, I'm running FreeBSD 2.2.8 and mysql 3.22.14b-gamma. The database is called mylinks, in case the name of the db matters, and I'm running the setup.cgi as root, using my root login to mysql that has full privileges.

As I mentioned, I'm trying the 1.1b3 beta, I have not installed any 1.0x version at all. I really haven't made many changes to any of the files, except to set up as appropriate for my machine.

Any ideas or other info I can get to help figure out the problem?

Jerry