[pLog-svn] big LT database

[Jon Daley]

 	I have played with the database, but not with trying to import the 
binary files.  Perhaps something failed with that.  I had shut down mysql, 
so I don't know what would have been wrong with it.
 	I could make a "regular" mysqldump.

  On Sat, 6 May 2006, Oscar Renalias wrote:

> 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
>> 
>
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn

**************************************
Jon Daley
http://jon.limedaley.com/

Everywhere is walking distance if you have the time.
-- Stephen Wright