Forum LAMS for Tech-Heads - General Forum: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Requested resource not available

The error is this bit:

import-db:
      [sql] Executing file: C:\DOCUME~1\ANDERS~1\LOKALA~1\Temp\dump.sql
      [sql] Failed to execute:    /*!40000 ALTER TABLE `lams_auth_method_type` DISABLE KEYS */

BUILD FAILED
C:\DOCUME~1\ANDERS~1\LOKALA~1\Temp\build.xml:95: java.sql.SQLException: Table 'lams_auth_method_type' is read only

But why mysql thinks this table is read only I have no idea.

I assume you are trying to do a fresh install - not upgrade from a previous version. If you are trying to do a fresh install, can you MySQL client and delete the lams2 database manually before running the install.

We are still finalising the 2.0.2 installer so wait till that one is ready (real soon now!)

I'm not sure how you can drop a database in WinMySQLadmin - I've never managed to get it working properly since I reinstalled XAMPP on my PC.

To do it via the command line version you should be able to go to the command line and do the following, replacing "c:\Program Files\xampp\mysql" with your path to mysql:

C:\Documents and Settings\Administrator>"c:\Program Files\xampp\mysql\bin\mysql" -ulams2 -p
Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 234
Server version: 5.0.33 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> drop database lams2;
Query OK, 139 rows affected (5.00 sec)

mysql> exit
Bye



The number of rows bit will be different if you have only 7 tables!

Fiona

Posted by Fiona Malikoff