Hi Arjan,
> Any plans to port Database Workbench to linux?
No, there will be no native Linux Database Workbench. From what I've
heard, it works fine under Wine though.
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
htt
Hi All,
Can you please suggest any good third party software for backup and restore
of mysql db.
Right now i am looking at ZMANDA. Has any one worked on this, and used for
their production db, please let me know how it is and can we use the same
for our production 24/7 mysql db.
regards
anandkl
Hi and thanks for the answers.
As I understand from what I've read in the comments here:
http://www.xaprb.com/blog/2006/07/16/how-we-enabled-threading-in-mysql/
This might be normal behaviour.
Apparently the different types of threading used on the boxes (LinuxThreads
vs NPTL) can result, for the
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 th
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: 07060
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
Mik
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
-Messag
[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
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 status
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 ca
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
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 ques
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 futu
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
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 operatin
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 in
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 have
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 flushe
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 app
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
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.
C
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 th
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 a
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 plain-te
24 matches
Mail list logo
