On May 18, 2012, at 8:20 AM, Andy Kannberg <andy.kannb...@gmail.com> wrote:
> How do I check if foreign keys are defined and if they are MyISAM tables ??
Do you see the words "foreign key" anywhere? What is the "ENGINE" (MyISAM or
InnoDB)?
Ken
> 2012/5/18 Ken Youens-Clark <kycl...@gmail.com>
> Does the schematic have foreign keys defined? If they are MyISAM tables,
> they won't.
>
> Ken
>
> On May 18, 2012, at 7:51 AM, Andy Kannberg <andy.kannb...@gmail.com> wrote:
>
>>
>>
>> ---------- Forwarded message ----------
>> From: Andy Kannberg <andy.kannb...@gmail.com>
>> Date: 2012/5/18
>> Subject: Re: [sqlfairy-developers] Problem with using sqltgraph
>> To: Ken Youens-Clark <kycl...@gmail.com>
>>
>>
>> Hi,
>>
>> I did the --no-data dump, and tried to convert the resulting schema file to
>> a diagram. I got a diagram, but it only showed all tables separately without
>> the relations between the tables.
>>
>> Any tips ?
>>
>> cheers,
>> Andy
>>
>>
>> 2012/5/16 Ken Youens-Clark <kycl...@gmail.com>
>> Did you "mysqldump --no-data"?
>>
>> Ken
>>
>> Sent from my iPad
>>
>> On May 16, 2012, at 4:19 AM, Andy Kannberg <andy.kannb...@gmail.com> wrote:
>>
>>> Hi all,
>>>
>>> I run into a problem when I want to create a graph from a mySQL database
>>> dump.
>>> The dump is fairly large (400 MB) and as a result, I run into a
>>> out-of-memory error.
>>> I run the following command:
>>>
>>> sqlt-graph -f MySQL -o mydatabase.png -t png mydatabase.sql\
>>>
>>> But after a while, it just quits with the message ´out of memory'
>>> First few attempts were on a Ubuntu VM with 1300MB memory. Next attempts
>>> where on a Ubuntu vm with 12 GB memory, same
>>> problem. Is there a way to prevent this problem ?
>>> Please bear with me, I'm not a database expert in case I ask silly or
>>> obvious questions. All I want to do is create a nice graph of this Database
>>> (Actually, it's the static dump of the database of the game 'Eve Online' )
>>>
>>> cheers,
>>> Andy
>>> ------------------------------------------------------------------------------
>>> Live Security Virtual Conference
>>> Exclusive live event will cover all the ways today's security and
>>> threat landscape has changed and how IT managers can respond. Discussions
>>> will include endpoint security, mobile security and the latest in malware
>>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>>> --
>>> sqlfairy-developers mailing list
>>> sqlfairy-developers@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers
>>
>>
>> ------------------------------------------------------------------------------
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and
>> threat landscape has changed and how IT managers can respond. Discussions
>> will include endpoint security, mobile security and the latest in malware
>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>> --
>> sqlfairy-developers mailing list
>> sqlfairy-developers@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers
>
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
--
sqlfairy-developers mailing list
sqlfairy-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers
