[pLog-svn] big LT database

[Oscar Renalias]

What version of mysql do I need? 4.0.x doesn't seem to understand the  
"meta commands" at the top of the file:

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,  
FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE,  
SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


On 6 May 2006, at 22:29, Jon Daley wrote:

> 	New format of dump is available.  This is a "regular" dump,  
> instead of the binary form.  300MB, converts to 900MB when  
> uncompressed.
> I used the DROP TABLE IF EXISTS switch, so it should clear out old  
> stuff, though since the binary form didn't work so well, probably  
> you want to completely destroy that database to avoid future problems.
>
> 	I also used a "DISABLE KEYS" switch, since that greatly increased  
> my import time.  It says it will reenable them at the end, but I  
> haven't ever used that command before.
>
> http://jon.limedaley.com/dump.sql.gz
>
>
>
> 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/
>
> "I think that too much media in the hands of one powerful entity
> or one individual is a mistake. I think it runs counter to the
> foundation of our country. I think it runs counter to the need
> for Americans to know that they are getting news and information
> from multiple sources that are not singularly controlled."
> -- John Kerry, June 2004
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn
>