> Hi,
>
> MySQL v4.1.22 on Linux 2.6.18-6-686
>
> I have a dump file generate with mysqldump created by a version 4.1.10 server.
>
> I want to import the dump file into a different server. When I run
>
> mysqldump --database mydb --debug < mydumpfile.sql
>
> I get the following:
>
> -- MySQL dump 1
> I'm using MySQL 5.1.30 and have several memory tables with indexes on the
> appropriate columns. When I try and join 2 particular memory tables together
> to get 5k rows, it takes 90 seconds.
> This is incredibly slow considering table1 has 11k rows and table2 has 5k
> rows. A table join like thi
> Need some facts for a Report ...
> For a hypothetical Kitchen Company's shopping Catalogue.
> a.. What advantages does a database have over flat-file systems ?
great advantage when processing large amounts of data.
> b.. Are there any disadvantages in switching to a database solution ?
databas
> Hello everyone,
>
> Upscene Productions introduces the FREE "Lite Edition" of
> Database Workbench for MySQL.
>
> More info:
> http://www.upscene.com/displaynews.php?item=20090331
> and
> http://www.upscene.com/products.dbw.index.php#lite
>
> This is a limited but useful version of "Database Work
> Hi,
>
> At my table i have fields a, b and lets say i want to calculate the
> number of entries at the table which has the mentioned propery: if there
> are consecutive rows with a=x, b=y and the next line a=y and b=x but the
> third line should be a != x and b != y, is it possible with an sql q
