| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> does anyone know where to get worm trace files
<1> next I drop all my database, and I am trying to recover one of this whit mysql -u root -p < database
<1> Mysql say: ERROR at line 11604: Unknown command '\"'
<1> In line 11604 the script try to insert a portion of an HTML document
<2> j0n0: i think your db data contains special characters... there's a flag for that
<1> what flag? I'm reading mysql command's man page but I don't see it
<3> Is it possible to turn on the mysql slow query logging without restarting the server?
<2> j0n0: me neither :/ i thought i remembered something about that, but I can't find it atm... have you checked the online manual?
<1> I'm searching on the online manual... but nothing atm
<4> hey folks, is it possible to format text for mysql in a native query? we have a java file that has values with apostrophes
<5> java file?
<2> j0n0: you could try running the dumpfile through sed to replace '\"' with '"' (keep the original dumpfile tho ;) )
<4> yes, we are using java and want to insert to a mysql db, but some of the values have apostrophes and characters
<5> \
<5> I think you want here
<4> is there anything native to mysql that does text formating?
<5> \
<5> sorray
<5> meant "\'" there
<4> right, but i have a value
<1> klync: I try
<4> INSERT INTO table (field) values (value);
<4> is there a way to format value in mysql
<6> you can't format it before you put it in?
<5> depends what you mean with format...
<4> i dont know how to do it in java
<5> :P
<5> so learn
<4> i am asking if its possible in mysql
<5> possibly, but no point
<6> your mysql api/connector should provide something to escape
<2> Noel4DMB: you need to p*** a valid query statement to mysql
<7> Noel4DMB: define 'format'
<5> SET col=FOO('value')
<5> but that's silly
<4> I have a value that is full of apostrophes and characters that break mysql
<7> aha
<5> look for something called escaping in your mysql docs
<5> *mysql interface
<4> Right, but i want to know if the query can escape a value, rather than me physically escaping each apostropher in the program
<6> you need to do the escaping in java, not mysql
<6> I'm sure you could but that would be kidna retarded
<8> Hi, im trying to preform a transaction. Insert into 2 tables. There is a constraint (update cascade delete cascade) between the tables. I insert the PK table first, then the FK table and i get a "Cannot add or update a child row: a foreign key constraint fails" error. Is this because of the transaction , any way to go around it?
<5> LOAD DATA INFILE :P
<5> just make your BD cl*** write the stuff to a file, and then load that in
<8> actually its not :-S
<5> i.e. a wtf++
<8> how do you delete a constraint form a table?
<8> anyh one know?
<9> bigfoot-: heheheh indeed.. (and again, over 1 hour later with the response ;))) )
<7> darkdrgn3k: you can just SET FOREIGN_KEY_CHECKS = 0; before you do the inserts and bakc to 1 after
<8> shabbs: yeh but i realized i screwed up a constraint. i wanna remove it from the table's def
<7> darkdrgn3k: alter table ... drop foreign key ...
<8> aaaa
<8> any way to reset a innodb table's autoincrement to 0?
<7> darkdrgn3k: alter table ... auto_increment = 1
<8> learn somethin new every day
<8> tahnx
<10> how do I drop all tables from a database ? DROP TABLE doesn't seem to want wildcards
<8> list tables?
<1> klync: no, sed doesn't work for me
<11> rudenstam: drop database
<8> LOL drop database would work :-P
<10> but I can't recreate it can I ? as I have limited rights
<11> rudenstam: then script it
<1> klync but the error now is ERROR 2005 at line 11604: Unknown MySQL Server Host '<tr>\r\n' (1)
<10> so it's not doable with just sql ? I need something to grab the tables and then feed the drop table with the tables appended ?
<7> rudenstam: chances are if you have drop database privs you also have create database privs
<8> rudenstam: coudlnt you like drop table `show tables`;
<8> or something liek that
<7> rudenstam: in 5.0 it's possible with stored procedures and the information_schema table
<12> is there any way to backup a table in a query
<10> I'm on 4.1 I belive
<7> then no, not that I'm aware of
<12> in 4.1
<12> liek for example
<12> i want to do a m*** update on a specific field
<12> but i want to be able to undo it if needbe
<7> Twister: use transactions and a transaction capable table engine
<12> myiasm?
<7> innodb
<12> the problem is the table is already created
<1> Can someone help me? ERROR at line 11604: Unknown command '\"'.
<12> and i dont have access to it
<8> there is adump dommand
<12> ah
<13> "update table set x = ? , y = ? where z = ?" or "update table set x = ? and y = ? where z = ?" ??
<8> i jsut dont knwo what it is cause im using mysqladmin :-P
<7> Twister: select * into outfile will send the output of the select to an external file
<13> or you can use 'mysqldump'
<7> daMaestro: first one
<13> thanks
<7> though mysqldump is commandline, but if you can dump to a local file then you should also be able to use mysqldump
<13> mysqldump -u root -p dataBase > database.sql
<13> for example.
<12> well what im trying to do is write a php script to update the database so if anyone in the user_points field has > 275 it will put them back to 275 but if something bad happens or whatever, i want the option of restoring the last data
<14> hello all! I have a table into which I would like to insert all the rows of a couple other tables into. My predicament is that the primary key of the new table is the primary key of the old tables plus a specific value. (i.e. old tables have primary key id whereas new table has primary key w_id,p_id where p_id of new table equal id of old tables). is there an easy way to do this?
<12> through the script
<12> because heres no access to the command line by me
<7> Twister: do you have create table privs?
<12> yes
<12> i think i see where your going with this :)
<7> Twister: then create table backuptable select * from origtable;
<7> it'll create a copy of origtable
<12> yep :!
<12> :)
<12> thanks!
<15> hello sirs
<15> can anyone tell me
<15> if its possible to LOG every mysql command
<15> that the server gets
<15> to a text file?
<16> sure - can't see why not
<7> !m falso general query log
<17> falso: (The General Query Log) : http://dev.mysql.com/doc/mysql/en/Query_log.html
<15> thanks shabbs
<18> does anyone know the mysql version in which STR_TO_DATE('2005-02-24 13:00:00', '%Y-%m-%d %H:%i:%s') started to work?
<18> I mean, the version that introduced this feature
<0> does anyone have the worm source code
<0> for sql
<0> or know where to get it
<19> The what?
<11> vi: what? If you're asking what I think you are, quietly turn and walk away
<16> lol
<16> what a question to ask :P
<12> lmao
<16> anyhow, i thought the only mysql worm out there hit windows machines only
<20> how do i make the mysql query browser execute more that one query like "call p1 (@a); select @a;" i can only make it execute one of the commands not both
<21> you need to use mysqli
<21> and multi-query
<20> mysqli?
<21> sorry, a client api that supports it
<21> mysqli == php library that does
<16> or pdo_mysql
<21> but variables last for a connection
<20> ah but it is not in php, it's with mysqls query browser
<21> you can probably just execute the queries in order
<22> I have a select query here that works under the mysql commandline client, but fails with an SQL error when submitted from the MySQL JDBC driver!
<20> nope it executes only one command per connection
<21> bah, that's too bad
<22> how is such a stupid thing even possible? :-(
<23> Anything is possible!
<24> multi_io: depends on the query.
<24> The MySQL client does some "preprocessing" of things, the JDBC driver doesn't.
<21> multi_io - probably, PEBSAK
<22> great
<14> hello all! I have a table into which I would like to insert all the rows of a couple other tables into. My predicament is that the primary key of the new table is the primary key of the old tables plus a specific value. (i.e. old tables have primary key id whereas new table has primary key w_id,p_id where p_id of new table equal id of old tables). is there an easy way to do this without writing a script?
<24> Most likely your query would fail if you used ODBC or libmysql itself.
<21> what's the query?
<22> ok thanks
Return to
#mysql
or
Go to some related
logs:
#css
glxgears param fps
gtkterm package in XUBUNTU
wtf easyspeedy
postfix/smtp problem talking to service rewrite
#ubuntu
#debian
glibc detected double free or corruption FC5 Knoppix
fedora livna ati X200
emerge-delta-webrsync eix-sync
|
|