Here's a trivial example. Run something like this out of cron every
night.
--- cut
#!/bin/sh
DATE=`/bin/date +%Y-%m-%d`
mysqldump -u root -p [password] --all-databases --opt > \
/path/to/large/partition/backup_${DATE}.sql
--- cut
> -Original Message-
> From: adi [mailto:[EMAIL
The way I look at it, MySQL gives you a choice of table types, so you
can pick the one best suited to the task at hand. For raw speed where
you can do without transactions, you can go with MyISAM. Otherwise you
have Innobase. I'm not sure where/why db3 fits in, haven't been
bothered to look int
Whether or not the default table type is changed to InnoDB, in the
spirit of the original poster's question, and what I think Sinisa is
trying to get you to admit, transaction support is no longer one of the
issues to consider when comparing MySQL to PostgreSQL. MySQL supports
transactions *now*
Whether or not the default table type is changed to InnoDB, in the
spirit of the original poster's question, and what I think Sinisa is
trying to get you to admit, transaction support is no longer one of the
issues to consider when comparing MySQL to PostgreSQL. MySQL supports
transactions *now*
The way I look at it, MySQL gives you a choice of table types, so you
can pick the one best suited to the task at hand. For raw speed where
you can do without transactions, you can go with MyISAM. Otherwise you
have Innobase. I'm not sure where/why db3 fits in, haven't been
bothered to look int
> WITH_LINUXTHREADS=yes Use the linuxthreads pthread library.
> This is _NOT_ recommended for
production
> servers. Expect problems when enabled.
How fresh or stale is this information? Are there in fact problems
under hea
Unfortunately Mascon doesn't have any ER diagramming tools for schema
modeling. I bought Heraut Solutions' Dezign for Databases for this
purpose a while back, but its somewhat clunky, unprofessional look/feel
has been a bit of a turn off. I've enjoyed using Sybase' Powerdesigner
for this purpos
Nope. Looks like you're stuck with their "creamy" look. In fact, it
doesn't really use XP widgets - it uses it's own widget set/skin which
looks more like an MP3 player than a db admin tool.
Incidentally, their database admin tool, called Navicat, looks awfully
familiar... It's basically just
Are the other servers all using the same kernel version (2.4.4)?
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> m] On Behalf Of Arndt Jenssen
> Sent: Wednesday, December 12, 2001 2:27 PM
> To: [EMAIL PROTECTED]
> Subject: High load problem with 3.23.45
>
>
See:
DATE_ADD(date,INTERVAL expr type)
DATE_SUB(date,INTERVAL expr type)
ADDDATE(date,INTERVAL expr type)
SUBDATE(date,INTERVAL expr type)
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> m] On Behalf Of [EMAIL PROTECTED]
> Sent: Wednesday, November 28, 2
You probably want to start with datetime rather than timestamp, as
timestamp comes with some additional magic to auto-set it for you and
you may not want this. A good source for this type of information is,
incidentally, the MySQL reference, at www.mysql.com.
> -Original Message-
> From:
You typically wouldn't want to renumber a key field, as that would break
any relations you have with other tables, unless you renumber all of
those as well. As MySQL doesn't expressly support foreign keys, and has
no idea about the relations between your tables, there is no way for
MySQL to renu
Update table set days_left = days_left- 1 where days_left > 0 [and other
conditions].
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> m] On Behalf Of Gil G.
> Sent: Tuesday, November 13, 2001 11:23 AM
> To: [EMAIL PROTECTED]
> Subject: How to decrement int f
REPLACE is different than UPDATE - replace deletes the row and then inserts
a new one. Update updates the values in the existing row. Big difference
if you aren't updating all columns...
- Original Message -
From: "Rene Tegel" <[EMAIL PROTECTED]>
To: "Torgil Zechel" <[EMAIL PROTECTED]>
Without more information this appears to be a very simple question -
serialize the object insert it into the blob field.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> m] On Behalf Of Saeed Saleem
> Sent: Wednesday, June 20, 2001 11:28 AM
> To: [EMAIL PROT
Perl's Spreadsheet::ParseExcel and Spreadsheet::WriteExcel are great for
this purpose. Find them on a CPAN site near you.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> m] On Behalf Of Don Read
> Sent: Thursday, June 14, 2001 3:43 PM
> To: Terminal Velocity
If I understand you correctly, you probably want to look into "left
joins". I.e.
select a.field, b.field from table1 a left join table2 b on
a.id=b.tbl1.id
vs
select a.field, b.field from table1a, table2 b where
a.id=b.tbl1.id
The first will show matching rows from table1 even
>From the manual:
"The default database page size in InnoDB is 16 kB. By recompiling the
code one can set it from 8 kB to 64 kB. The maximun row length is
slightly less than a half of a database page, the row length also
includes BLOB and TEXT type columns. The restriction on the size of BLOB
an
Good catch :)
> -Original Message-
> From: Don Read [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 6:44 AM
> To: Alok K. Dhir
> Cc: [EMAIL PROTECTED]; Chih-Lii Chen/Trans-EZ/TW
> Subject: RE: recursive select
>
>
>
> On 13-Jun-01 Alok K
Ah recursion. Nothing like it to get your mind tied up in knots... :)
Try this - untested, but this is the basic idea, and it or something
like it should work. Call the function with the node you want to start
from and the array you want the results to land in... Like so:
> -Original M
20 matches
Mail list logo
