Hello
I am looking for the tools that I would use to be able to do
administrative duties and to be able to create and update databases (tables,
indexes and so forth). I would rather do this than do it via a command line.
I would appreciate any links available.
If you're on Windows, you
Hi !
paulizaz wrote:
What do you mean by same output ?
I have too much data to go through and check if all the data is the same.
This is my problem. Sampling would speed this up, but I need something more
accurate.
All data is important.
In Unix / Linux, you would generate similar
I think you're missing the concept of a transaction in the database sense.
The idea behind a transaction is that you can perform multiple steps and if
you don't complete all steps, any changes are reversed. The reversal process
is handled by the database.
A good example is moving money from bank
On 6/5/07, Brent Baisley [EMAIL PROTECTED] wrote:
I think you're missing the concept of a transaction in the database sense.
The idea behind a transaction is that you can perform multiple steps and if
you don't complete all steps, any changes are reversed. The reversal process
is handled by the
David T. Ashley wrote:
There is no concept that I'm missing. I understand what a transaction is.
But I just don't want to bothered. My application is simple enough that
bogarting the database until all necessary modifications have been made and
the tables are again consistent is good enough.
On 6/5/07, Baron Schwartz [EMAIL PROTECTED] wrote:
David T. Ashley wrote:
There is no concept that I'm missing. I understand what a transaction
is.
But I just don't want to bothered. My application is simple enough that
bogarting the database until all necessary modifications have been
I'm getting what appears to be a java reference back from values I return
from a UDF. The values appear find using php, and in the mysql client.
The result looks something like:
[EMAIL PROTECTED]
The result should be a string (some representing floats, others as integers).
Any help will be
At 09:59 PM 6/4/2007, you wrote:
If mysql has been shut down, and given enough time for the tables to
be flushed to disk, then backing up the data dir using tar is fine. You
can tar the data dir without shutting down, providing all transactions
have been stopped and the tables have been
mos wrote:
At 09:59 PM 6/4/2007, you wrote:
If mysql has been shut down, and given enough time for the tables to
be flushed to disk, then backing up the data dir using tar is fine. You
can tar the data dir without shutting down, providing all transactions
have been stopped and the tables
Hi,
I am running an application that interfaces with MySQL from c++. When
I try to run the application, I get a segmentation fault at the line
where I call mysql_init. Here is part of the output from gdb
#0 0x081a0e78 in elf_machine_rel.0 () at ../sysdeps/i386/dl-machine.h:333
#1 0x081a113a
On 6/5/07, S Nassar [EMAIL PROTECTED] wrote:
I didn't build libmysql.so myself. This was installed with mysql. The
application code that calls mysql_init is built statically. I see this
error when building on one machine and trying to use the code on a
different machine.
Knowing the operating
Hi David,
On Jun 5, 2007, at 3:55 PM, David T. Ashley wrote:
My only concern with GET_LOCK() is that lock is server-global
rather than
database-global. This makes attacks possible in a shared setting
(some bad
person could disable your database code by going after your lock).
My solution
This:
070605 15:07:27 InnoDB: Error: page 170144 log sequence number 71 2823728422
InnoDB: is in the future! Current system log sequence number 71 452597657.
InnoDB: Your database may be corrupt.
070605 15:07:28 InnoDB: Error: page 61253 log sequence number 71 910331446
InnoDB: is in the
Thanks for the reply. I tracked the problem down. Simple problem really,
I was using an old mysql-connector-java jar. I updated that to the
correct version for my database and it all worked.
What version of of the JDBC driver are you using?
Good question to ask. I asked myself that very
I have resolved the issue. As Heikki said in another posting, basically
injecting a large amount of data will cause it to catch up. I made a new DB on
the server and am importing a 4 GB table into it. At some point during the
process the error quit getting logged. After it is done importing I
Keith,
When you copied the database, you need recreate de logfiles and the
sequences. Then, startup the database.
1) clean your actually log files ( backup to another side)
2) When the database startup automatically recreate the log files and
sequence.
Send feedback about it.
Regards,
Juan
On
I am sure that this has been asked - but in searching through google and
lists for about an hour - hopefully someone will indulge me a repeat
question here.
I have a query that selects a list of results, ordering them by the status
field. However, I want to further sort that by the type of
[snip]
I have a query that selects a list of results, ordering them by the
status
field. However, I want to further sort that by the type of status, that
is:
Undefined
Ready for Review
Top Priority
Priority
Completed
Etc...
Every sort that I try, of course, sorts alphabetically. Is there a way
Hi,
You could use a case statement to implicitly convert your column to
everything you want:
select status,
case when status = 'undefined' then 4
when status = 'Top Priority' then 1
...
End as ord_status
from development
order by ord_status
Bye
Geoffroy
Mike
I have a query that selects a list of results, ordering them by the status
field. However, I want to further sort that by the type of status, that is:
Undefined
Ready for Review
Top Priority
Priority
Completed
ORDER BY FIELD( columnname, 'Undefined', 'Ready for Review', ... )
PB
Hi,
Is there any configuration to be setup to get each query of a stored
procedure, called by a client, in the mysql-slow.log or mysql.log? For
the moment, I just have the stored procedure call in the log file, but I
need to trace every SQL statement of this stored procedure.
# Time:
Hi Martijn,
Any plans to port Database Workbench to linux?
Regards,
Arjan.
Martijn Tonies wrote:
Hello
I am looking for the tools that I would use to be able to do
administrative duties and to be able to create and update databases (tables,
indexes and so forth). I would rather do
22 matches
Mail list logo