If you do I suggest you also include relevant table definitions and
possibly a little sample data (plus an indication of total table
sizes) and expected output, this will greatly assist anyone who my be
able to help. Oh yes, and don't forget to state the version of MySQL
you are running.
Coz
On
The mySQL command should read :
mysql -u username -p[password] db_name < dumpfile
Note that you can give the password on the command line but it is best
to get into the habit of just providing -p and typing in the password
when prompted.
BTW, when doing the mysqldump for tables that already exis
On Wed, 9 Feb 2005 15:48:12 +0200, Paul Godard <[EMAIL PROTECTED]> wrote:
> >On Wed, 9 Feb 2005 13:10:16 +0200, Paul Godard <[EMAIL PROTECTED]> wrote:
> >> Hi
> >>
> > > I use mysql/php on several client web sites (each client has its own
> >> db). For development purpose, I have a local web se
On Wed, 9 Feb 2005 13:10:16 +0200, Paul Godard <[EMAIL PROTECTED]> wrote:
> Hi
>
> I use mysql/php on several client web sites (each client has its own
> db). For development purpose, I have a local web server with
> php/mysql. When a web site is still in development, this is the
> master db, ev
On Tue, 08 Feb 2005 15:52:02 +0100, Joachim Klöfers
<[EMAIL PROTECTED]> wrote:
> Oh, oh, Joachim,
> not able to calculate, but asking questions about queries.
>
> Coz , of course its supposed to be 1955 (id 13 & 47)
>
> Joachim
>
>
> Coz Web schrieb:
>
On Tue, 8 Feb 2005 11:37:20 +, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> On Tuesday 08 February 2005 08:09, Joachim Klöfers wrote:
> > Hi, all
> >
> > I hope somebody can help me.
>
>
> >
> > Many thanks in advance
> > Joachim
>
> That is a very thorny problem. May I observe that you wi
Just to confirm, is amount2 for region 1 supposed to be 1630 (id 47)
or 1955 (ids 13 & 47)?
Coz
> What I would like to have is a result like this:
> ++---+--+
> | region | sum(amount1) if current=J | sum(amount2) |
> ++---
Helena, have you tried this link:
http://dev.mysql.com/doc/mysql/en/upgrade.html
It starts:
"2.10. Upgrading MySQL
As a general rule, we recommend that when upgrading from one release
series to another, you should go to the next series rather than
skipping a series. For example, if you currentl
I know it's not quite the same, but I recently upgraded 2 FC2 boxes
from MySQL3.23.xx to MySQL4.0.23 simply by using (as Gleb suggested) :
rpm -U mysql*
I had downloaded the following rpm files from the MySQL site :
Linux x86 RPM downloads
---
Server
