Hi,
> Good evening people.
>
> I'm trying to create a simple table via MySQl Navigator.
> The table il structured in this way
>
> dt_amt Date Not Null Primary Key
> oper INT Not Null Primary Key
> amount Decimal(3,3) Null ---
>
> but when I choose "fire" it shows me a "multiple primary key define
Thomas,
It would be more secure if you has the DB on another server that was locked
down and only allowed access to the web server on the MySql port, (plus
probably ssh access for admin).
If you're going to the expense of audits, this must be fairly important, so
the cost of the other server woul
anybody knows when row_format=compressed will work?
and what means row_format=default? . that it´s not compressed?
thanks
__
WEB.DE FreeMail wird 5 Jahre jung! Feiern Sie mit uns und
nutzen Sie die neuen Funktionen htt
>>>- Someone copies the DB files to another box, starts a mysql
>>>instance, loads the DB and presto - views the 'private' data !!!
>>>
PD> Sure. That's why you establish filesystem level access privileges so that
PD> only the mysql user can copy them in the first place.
Some DBMSs allow to setu
Hi!
On Nov 27, DeBug wrote:
> >>>- Someone copies the DB files to another box, starts a mysql
> >>>instance, loads the DB and presto - views the 'private' data !!!
> >>>
>
> PD> Sure. That's why you establish filesystem level access privileges so that
> PD> only the mysql user can copy them in t
Hi
I'm working on a project developed in C which is being developed under
windows but which is to be ported to an embedded platform (VXWorks OS) at
some point in the next few months. Part of the project comprises a database
and the initial plan has been to develop the database update code using t
We are using Mysql with one master and several slaves.
In some INSERT and UPDATE queries we use Mysql functions like CURDATE() and
RAND() .
The problem that now occurs is that if a slave is reading the queries from
the binary log, the resulting data is different from that on the master,
because o
On Wed, Nov 26, 2003 at 06:44:57PM -0600, Matt W wrote:
> Hi Chris,
>
> It doesn't take MySQL any more or less time to update a unique index
> than a non-unique one. :-)
Ah, a nice simple answer to a long drawn out question :) Thanks Matt,
just the reassurance I was after, I didn't want inserts t
Hello,
i'm writing a program which automatically makes a backup of some tables
(with "backup table foo1, foo2, ... to '/tmp/backupdir'")
and after that if some errors occur, the program tries to execute "restore
table foo1, foo2, ... from '/tmp/backupdir'".
The table which is returned contains SOM
>Description:
The included sql test script (output of mysqldump 10.2 (create table statement and
insertion of 250 records into this table) with added check for table integrity)
results in corrupted table and error message 'Found key at page 36864 that points to
record outside datafile'
Janusz Krzysztofik wrote:
> ...
> I am trying to optimize MySQL (3.23.49 from Debian stable) setup for
> ASPseek application. I decided to try InnoDB in order to be able
> to update tables while performing time consuming selects.
> After converting all tables to InnoDB I noticed a big difference
>
Executing this SQL, takes ~5 sec.
select artists.name , cds.title , tracks.title from artists, tracks,
cds
where artists.artistid = tracks.artistid and cds.cdid = tracks.cdid
and MATCH (artists.name) AGAINST ('madonna')
and MATCH (cds.title) AGAINST ('music')
and MATCH (cds.title) AGAINST ('
I need to insert hundreds of milions of records to a table and make
several indicies on it. Now, is it faster to make tables with indicies
and then fill tables or fill tables first, then make indicies? Any
experiancies?
regards,
mirza
--
MySQL General Mailing List
For list archives: http://
hi all.,
i tried to compile mysql-3.23.58 source
distribution for windows using VisualStudio 6 and
found that MySqlManager.rc file missing and hence the
compilation failed , The MySqlManeger.rc file is not
available in the MySqlManager folder downloaded from
mysql home site.
plz help me out in
Hi,
we have a mysql-3.23.5x database (Linux) that contains a lot of German
umlauts. We have to support Asian charters (UTF-8) and how can I convert the
database to UTF-8?
Zsolt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
Hi,
we use mysql-3.23.5x? under Linux and cannot upgrade to 4.x. Our java
applications can store and fetch UTF-8 characters we have problem only with
sorting.
Any ideas how I can fix the problem?
Zsolt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
On Nov 27, 2003, at 10:32 AM, Mirza wrote:
I need to insert hundreds of milions of records to a table and make
several indicies on it. Now, is it faster to make tables with indicies
and then fill tables or fill tables first, then make indicies? Any
experiancies?
Insert the records first, then
how can I backup the table but not with BACKUP TABLE
because it Backups the .frm and another files. I want
that it backups in SQL with data. How can i do it?
Thanks
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
MySQL General Ma
Hello,
Most of the time, MySQL 4.0.16 runs absolutely fine on my FreeBSD 4.9
system. However, today, unexplicably, it's run into the same problem 3
times now; a couple of the threads suddenly start eating 100% CPU for
no good reason while doing a SELECT. They'll sit there until I kill
them, which
Zsolt,
> we use mysql-3.23.5x? under Linux and cannot upgrade to 4.x. Our java
> applications can store and fetch UTF-8 characters we have problem only with
> sorting.
> Any ideas how I can fix the problem?
I'd advise you to upgrade to MySQL 4. MySQL 4.1.1 would be best, as it
has extensive supp
MySQL version: 3.23.49
OS: Debian3
Scripting Language: PHP
I'm working on a trouble ticket system. There are several tables involved, but for
this query only two tables are involved: tickets and comments. They are related by the
ticketnumber field. This client cannot afford a high end database,
Zenzo <[EMAIL PROTECTED]> wrote:
> how can I backup the table but not with BACKUP TABLE
> because it Backups the .frm and another files. I want
> that it backups in SQL with data. How can i do it?
>
Take a look at mysqldump program:
http://www.mysql.com/doc/en/mysqldump.html
--
For tec
The problem is that I wnt to use this remotely on
another server. Is there a SQL command for doing this
(exporting the table with data into a SQL script)?
--- Victoria Reznichenko
<[EMAIL PROTECTED]> wrote:
> Zenzo <[EMAIL PROTECTED]> wrote:
> > how can I backup the table but not with BACKUP
> TA
"Arnoud Witt (Marktplaats)" <[EMAIL PROTECTED]> wrote:
> We are using Mysql with one master and several slaves.
>
> In some INSERT and UPDATE queries we use Mysql functions like CURDATE() =
> and
> RAND() .
>
> The problem that now occurs is that if a slave is reading the queries =
> from
> the b
Zenzo <[EMAIL PROTECTED]> wrote:
> The problem is that I wnt to use this remotely on
> another server.
You can use --host option of mysqldump.
> Is there a SQL command for doing this
> (exporting the table with data into a SQL script)?
No.
>
>
> --- Victoria Reznichenko
> <[EMAIL PROTECTED]>
Mirza,
Definitely, index after insert.
Andy
> -Original Message-
> From: Mirza [mailto:[EMAIL PROTECTED]
> Sent: 27 November 2003 15:33
> To: [EMAIL PROTECTED]
> Subject: Index before or after inserts?
>
>
> I need to insert hundreds of milions of records to a table and make
> several
I think mysqldump does that. It creates a script that contains SQL
statements to create the table and then the data to populate the table.
Mysqldump has command line parameters, but I don't know which ones you would
need to use.
Bob
-Original Message-
From: Zenzo [mailto:[EMAIL PROTECTED
At 03:19 PM 11/27/2003, you wrote:
Mirza,
Definitely, index after insert.
Andy
Maybe not. I know this is the common sense approach that works with
many databases, but I'm not sure it is faster with MySQL.
MySQL Manual on "Alter Table "
>>Note that if you use any other option to ALTER TABLE tha
Hi,
Create the indexes right away and then use
ALTER TABLE table DISABLE KEYS;
Load your data and then
ALTER TABLE table ENABLE KEYS;
This will not make a tmp copy of the data file, but will simply start
rebuilding the index.
However, DISABLE KEYS doesn't disable unique indexes, so these stil
Hi,
For the query that you would need, see this page in the manual:
http://www.mysql.com/doc/en/example-Maximum-column-group-row.html
Also see the comment from March 16, 2003 about the LEFT JOIN trick.
However, in your case, why don't you just add another column in the
tickets table? last_respon
Hi,
- Original Message -
From: "Chuck Gadd"
Sent: Wednesday, November 26, 2003 2:29 PM
Subject: Re: Disorder result with ORDER BY with ENUM, INT
> Kriengkrai J. wrote:
>
> > -- System: MySQL 4.0.13, 4.0.16 on Linux x86
> > -- Table type: MyISAM, InnoDB
> > -- Description / How-To-Repe
In the last episode (Nov 27), Chris Elsworth said:
> Most of the time, MySQL 4.0.16 runs absolutely fine on my FreeBSD 4.9
> system. However, today, unexplicably, it's run into the same problem
> 3 times now; a couple of the threads suddenly start eating 100% CPU
> for no good reason while doing a
On Thu, Nov 27, 2003 at 06:25:38PM -0600, Dan Nelson wrote:
> In the last episode (Nov 27), Chris Elsworth said:
> > Most of the time, MySQL 4.0.16 runs absolutely fine on my FreeBSD 4.9
> > system. However, today, unexplicably, it's run into the same problem
> > 3 times now; a couple of the thread
Greetings!
Im new to this MySQL..please help me identifying the different parts of the screen and
its purpose.
God Bless and thank you
Alvi
-
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
I have a table "members" in the MySQL database. I am
going to supply a String "editor" and search the
"members" table. All those who are "editor" will be
picked up and their name will enter the array I want
to create.
How do I code it and return this array?
Here is a sketch of my code. I do n
35 matches
Mail list logo
