Hi Ken,
ok, I will check into converting to InnoDB. Guess that's gonna take a while
:D:D
thanks for the help so far.
cheers
Andy
2012/5/20 Ken Youens-Clark <kycl...@gmail.com>
> Andy,
>
> Looks like you have no foreign keys defined. Also, MyISAM tables don't
> use FKs, so sqlt can create no links among your tables. You must do this
> manually or switch to InnoDB and define them in your schemes.
>
> Ken
>
> On May 20, 2012, at 12:04 PM, Andy Kannberg <andy.kannb...@gmail.com>
> wrote:
>
> Hello Ken,
>
> When I look into the schema.sql file, I see some 'foreign key' strings:
>
> /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
> FOREIGN_KEY_CHECKS=0 */;
>
> the engine is MyISAM
>
> What to do now ?
>
> cheers,
> Andy
>
>
>
>
>
> 2012/5/18 Ken Youens-Clark <kycl...@gmail.com>
>
>> 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
