[pLog-svn] big LT database

[Oscar Renalias]

Did anybody try the database? I was trying to deploy it in  
devel.lifetype.net but it doesn't seem to work. I am getting these  
messages:

mysql> use generatedata;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Didn't find any fields in table 'lt_articles'
Didn't find any fields in table 'lt_articles_categories'
Didn't find any fields in table 'lt_articles_comments'
Didn't find any fields in table 'lt_blog_categories'
Didn't find any fields in table 'lt_blogs'
Didn't find any fields in table 'lt_config'
Didn't find any fields in table 'lt_custom_fields_definition'
Didn't find any fields in table 'lt_custom_fields_values'
Didn't find any fields in table 'lt_gallery_albums'
Didn't find any fields in table 'lt_gallery_resources'
Didn't find any fields in table 'lt_global_articles_categories'
Didn't find any fields in table 'lt_host_blocking_rules'
Didn't find any fields in table 'lt_mylinks'
Didn't find any fields in table 'lt_mylinks_categories'
Didn't find any fields in table 'lt_permissions'
Didn't find any fields in table 'lt_phpbb2_users'
Didn't find any fields in table 'lt_users'
Database changed

If I try to repair the tables, I get this message:

mysql> repair table lt_articles;
+--------------------------+--------+---------- 
+-----------------------------------------------------------------+
| Table                    | Op     | Msg_type |  
Msg_text                                                        |
+--------------------------+--------+---------- 
+-----------------------------------------------------------------+
| generatedata.lt_articles | repair | error    | Incorrect  
information in file: './generatedata/lt_articles.frm' |
+--------------------------+--------+---------- 
+-----------------------------------------------------------------+
1 row in set (0.00 sec)

I tried using all the commands I found in http://dev.mysql.com/doc/ 
refman/5.0/en/repair.html but it didn't help. In fact, it actually  
removed all the data for some of the tables.

Does anybody have any idea?

Oscar

On 2 May 2006, at 11:50, Jon Daley wrote:

> On Tue, 2 May 2006, Oscar Renalias wrote:
>> plog.log isn't necessary, it's just there for logging purposes.
> 	Right - I just didn't know if there was anything useful in the log  
> - I assumed not, but wanted to check before I deleted it.
>
>> How about the files? How are you planning to provide them to us?
> 	Yup - just had to upload it.  Now available at:
> http://jon.limedaley.com/generatedata.tgz
>
> This is the /var/lib/mysql/generatedata directory.
>
>> I just hope this wasn't too much trouble!!
> 	Nope - learned a little bit about sql and indexes in the process,  
> so a worthwhile experience.
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn
>