Here is how I have been doing it, for years, and I have used this to
restore from, which has always worked for me.
http://dl.getdropbox.com/u/340087/Drops/10.29.09/mysql_backup-0196a0c2-013914.txt
A quick explanation, and some caveats:
First, set the u and p variables to a mysql user and passw
Dear all,
I have a table which contains taxonomic data (species, genera, family,
order, class) and it is organized as adjacency list model.
mysql> select* from taxonomic_units1 limit 5;
+-+---+-+
| tsn | name | paren
Not sure if this is the exact problem you're trying to solve, but this helped
me in a similar situation.
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
kabel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
Thanks Kabel,
Not sure if this is the exact problem you're trying to solve, but
this helped
me in a similar situation.
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
Yes, I have seen this article before, and it is really nice. However
they do not discuss any optimizat
Hi Olga,
On Thu, Oct 29, 2009 at 03:29:58PM +, Olga Lyashevska wrote:
> I have a table which contains taxonomic data (species, genera, family,
> order, class) and it is organized as adjacency list model.
>
> mysql> select* from taxonomic_units1 limit 5;
> +-+-
On Thu, Oct 29, 2009 at 07:53:25PM +0300, Sergey Petrunya wrote:
> ... taxonomic_units1 AS O1
> LEFT OUTER JOIN taxonomic_units1 AS O2
> ON O1.tsn = O2.parent_tsn
>
> current optimizer has only one option(*): use Nested-Loops Join algorthm, with
> the outer table being the first one. That is,
Olga,
Would you post "SHOW CREATE TABLE taxonomic_units1\G;"?
It should give us more info on the table you are dealing with
Regards,
Mikhail Berman
Olga Lyashevska wrote:
Dear all,
I have a table which contains taxonomic data (species, genera, family,
order, class) and it is organized as a
Sorry if this is a n00b question, I did read the docs for mysqldump
before posting, but couldn't figure it out.
I'm successfully doing a mysqldump, but I want only a few of the
columns, and want them in a different order. Is this possible without
substantially slowing it down? The table has
mysqldump is not really a data manipulation tool.. as the name
implies, it is a dumper.
What you are trying to accomlish can be done rather elegantly via the
SELECT .. INTO OUTFILE syntax
http://dev.mysql.com/doc/refman/5.1/en/select.html
and then loaded into your new structu
2009/10/29 Michael Dykman :
> mysqldump is not really a data manipulation tool.. as the name
> implies, it is a dumper.
>
> What you are trying to accomlish can be done rather elegantly via the
> SELECT .. INTO OUTFILE syntax
>
> http://dev.mysql.com/doc/refman/5.1/en/select.html
Jaime Crespo Rincón schrieb:
> 2009/10/29 Michael Dykman :
>> mysqldump is not really a data manipulation tool.. as the name
>> implies, it is a dumper.
>>
>> What you are trying to accomlish can be done rather elegantly via the
>> SELECT .. INTO OUTFILE syntax
>>
>>http://dev
11 matches
Mail list logo
