Hi All,
I wanted to know the possible ways in which an xml document can be stored in
the mysql database. So the keys in an xml are the columns in the database
and the key values in xml go as the values for columns. I dont want to use
java if thats possible.
Thanks in advance,
Adhiraj Joshi.
How do I recover them, and do you think this is wise? At this point, I
still think it might be a better idea to do a complete reinstall /
restore / transaction log run.
There's no need to reinstall :-) It's not MS Windows, it's just InnoDB.
As others have said, I'd try to do a global LOCK
In MySQL 5.1.20 (the version we're actually testing=) a sql-statement longer
than 1024 byte is cut in the general_log.csv and in the old Logfile so it
seems to be incomplete. Execution and replication of the statement is working
right but I don't think it's a feature though it's really
Hi Baron,
If the database is huge, the restoring from mysqldump would take lot of
time.
Is there any other alternative.
egards
anandkl
On 9/26/07, Baron Schwartz [EMAIL PROTECTED] wrote:
How do I recover them, and do you think this is wise? At this point, I
still think it might be a better
I cannot think of any safe alternative. Trying to recover files that
are in memory strikes me as very unwise with InnoDB.
Ananda Kumar wrote:
Hi Baron,
If the database is huge, the restoring from mysqldump would take lot of
time.
Is there any other alternative.
egards
anandkl
On 9/26/07,
Hi Baron,
If the database is huge, the restoring from mysqldump would take lot of
time.
Is there any other alternative.
Well, not deleting the InnoDB files would be a good start.
The files were deleted, what do you expect?? Just continue running and
hoping no-one finds out?
Re-creating
Hi all,
I have a list of values I get from my application and I want to
generate a record set based on this list (for an INSERT INTO ...
SELECT).
Today I have sth like:
SELECT 54, item.item_id, mdv.valueInt
FROM item i, metadata_value mdv
WHERE mdv.item_id = 20202
AND mdv.field_id = 54
AND
I don't know Linux that well, but I know that HP-UX lets you do most
anything to an open file, including deleting it. The file will continue to
exist as long as it is open by at least one process. If I remember
correctly, this is all about the inode use count vs. the directory entry, or
something
Hi,
Manuel Vacelet wrote:
Hi all,
I have a list of values I get from my application and I want to
generate a record set based on this list (for an INSERT INTO ...
SELECT).
Today I have sth like:
SELECT 54, item.item_id, mdv.valueInt
FROM item i, metadata_value mdv
WHERE mdv.item_id = 20202
Hi All,
I'm trying to get Crystal Reports to connect to a MySQL server.
Windows 2003 Server R2 x64
Crystal Reports XI Professional
Disabled DEP for crw32.exe
mysql-connector-odbc-noinstall-3.51.20-winx64.zip
FreeBSD 6.2-RELEASE-p7 x64
mysql-client-5.0.45
mysql-scripts-5.0.45
Oracle provides a stored procedure called DBMS_OUTPUT which primarily is
used to write/print/display text string to StandardOut (a.k.a. the
terminal).
In V5 MYSQL is there a functional equivalent? If so, what is it called.
I am willing to RTFM if somebody provides me a clue as to which manual
Hi Adhiraj,
I am going to assume that the keys and values are not static. If they
are, then this is just a matter of parsing XML into key, value
combinations.
A simple, but often less than ideal way of solving a problem like this
is to use several tables:
# The entries table is the equivilant
Is this for debugging purposes?
Olaf
On 9/26/07 12:37 PM, sol beach [EMAIL PROTECTED] wrote:
Oracle provides a stored procedure called DBMS_OUTPUT which primarily is
used to write/print/display text string to StandardOut (a.k.a. the
terminal).
In V5 MYSQL is there a functional equivalent?
doy las gracias por todo
Atentamente,
Ing. Marcelo Rodriguez S.
Jefe de Mejoras Continuas
Costos
__ Información de NOD32, revisión 2551 (20070926) __
Este mensaje ha sido analizado con NOD32 antivirus system
http://www.nod32.com
--
MySQL General Mailing List
Oracle provides a stored procedure called DBMS_OUTPUT which primarily is
used to write/print/display text string to StandardOut (a.k.a. the
terminal).
In V5 MYSQL is there a functional equivalent? If so, what is it called.
No, there isn't.
I am willing to RTFM if somebody provides me a
On Wed, 2007-09-26 at 10:55 -0400, Jerry Schwartz wrote:
I don't know Linux that well, but I know that HP-UX lets you do most
anything to an open file, including deleting it. The file will continue to
exist as long as it is open by at least one process. If I remember
correctly, this is all
Brent,
I tried this and it definitely boosted performance. On a test query
that would take 2+ seconds to run with 20 id's - it ran in 0.002
seconds.
Thanks everyone for your help and comments.
Erik
On Sep 21, 2007, at 2:01 PM, Brent Baisley wrote:
As others have mentioned, mysql
Everyone,
So I have never seen this before. I set up a database yesterday. I added a user
today in the normal manner..
ie
grant usage on *.* to 'username'@'%' identified by 'password';
Here is the thing. You exit the console and try to log in with mysql -u
username -ppassword and it
18 matches
Mail list logo