[pLog-svn] big LT database

Sun May 7 14:55:40 GMT 2006

No, wait a sec. Those work, but what doesn't work is the "DEFAULT  
CHARSET = ..." appended at the end of every table description.

On 7 May 2006, at 17:54, Oscar Renalias wrote:

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