| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13
Comments:
<0> !tell us about random
<1> shabbs asked me to tell you this: For information on selecting random values see http://jan.kneschke.de/projects/mysql/order-by-rand/
<0> aha!
<2> does anyone know how to set up mysql for remote access?
<3> profounded: Check the ISO SQL specification. The term is [derived table] or [derived column].
<4> mgbaron2 edit/remove from my.cnf skip-networking and bind-address
<5> is there a way to do a select from one table and insert the results into another
<4> !m albo insert select
<1> albo: (INSERT ... SELECT Syntax) : http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html
<2> archivist, thanks what do you mean by edit/remove them
<6> I dumped my tables on one server using mysqldump and then tried importing it on another server using mysqlimport but I get an error about and ibd file of the same name as each table, but I can't find .ibd files on the original server
<2> oh i think is see... the bind-address 127.0.0.1
<4> bind-address may be 127.0.0.1 stopping external and skipnetworking is self evident
<2> should i set the bind address to the ip of the server?
<0> either that or comment it out completely
<2> thanks, ill try it
<2> now any database user from any ip will be able to access (once i remove the bind address)?
<4> if granted
<2> do i have to grant the ips individually?
<0> !m mgbaron2 grant syntax
<1> mgbaron2: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<2> thanks, once again
<7> Hi! Can somebody help me with this line: $query = "SELECT * FROM Table WHERE '$datemin>Date>'$datemax'. Is this the correct way of writing it? No rows are coming out....
<6> How do I backup idb files?
<4> only past the real sql not php
<4> only paste the real sql not php
<8> please only correct one word, not re-paste the whole line
<8> Thaiger: you either back up the entire data directory, or (better) use mysqldump to dump the database
<8> !m Thaiger mysqldump
<1> Thaiger: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<6> Darien: I used mysql dump to back up a table then used LOAD DATA to load it in, but then it says it can't find table.idb
<6> and I looked on the original server and there are no idb files
<6> let alone a table.idb
<8> does the dump have a 'create table' statement?
<6> Darien: yes
<8> can you pastebin the actual error you get?
<6> Where do I do that?
<8> see topic
<6> mysql> LOAD DATA INFILE '/root/ACL' REPLACE INTO TABLE ACL;
<6> ERROR 1016 (HY000): Can't open file: 'ACL.ibd' (errno: 1)
<6> oops
<6> too many clipboards
<6> http://hashmysql.org/paste/index.php#
<6> http://hashmysql.org/paste/1377
<9> how can i set multiple bind_adresses?
<9> bind-address = 212.227.123.123, 127.0.0.1 does not work :(
<2> i just learned that if you remove it, it will allow anything
<10> are bind addresses what restricts who can connect to mysql?
<9> mgbaron2: cool thanks
<11> Thaiger: which options did you use for your mysqldump ?
<9> profounded: the address mysqld will listen on
<10> thx spiekey
<6> zeitoun: um... I just did a mysqldump database table > table
<11> Thaiger: then you cannot import like your are trying. Load data infile is meant to import tabular data, not sql dump
<11> Thaiger: try mysql -u youruser -p yourdatabase < yourdump.sql
<6> zeitoun: Ohh, ok thanks, I'll try that, I tried mysqlimport and it did that too
<6> zeitoun: Cool thanks! It worked!
<11> np.
<12> hi... is there a script that sets all collations in databases, tables and fields to a certain collation ??
<13> when i use full text will that have a huge impact on insertion?
<5> can i join with a subquery
<14> does mysql log unsuccessful connection attempts?
<14> i cant find where, if it does..
<15> I dont think it does
<15> but
<5> FzZzT: i dont know 100%, what i do know is if theres too many connections it does not
<15> I definatly could be wrong
<16> I have two columns, A and B. I want to return one value if A is >= 75% of A+B, return another value if B is >=75% of A+B, elsewise return a third value. Is this easily done without a lot of IF statements of redundant subqueries?
<10> quick, im on the phone with support: what setting do i need to change so i can access mysql from my home ip address and not just local host?
<10> heh thanks in advance
<15> somePriest, I would just get the two values from the db
<15> then do one ternary
<16> slid3r : Can it be done with one query? Our silly mailer system requires that I give it a single query, which it runs to get people to e-mail. Trouble is, I'm need more and more complex queries.
<15> grant all perms to you@'%'
<15> well dude
<15> ****
<15> what lang we talin
<15> talkin
<15> cuz a ternary is the easy answer here
<15> dude?
<15> what language is this
<16> slid3r : I just give the mailer an SQL query. I didn't write or maintain it. But its in PHP, Perl.
<15> you cant do any coding it HAS to be one query?
<15> in php
<15> thats easy
<16> slid3r : The mailer is a cl*** interface which I cannot alter.
<15> ewll
<15> well
<15> cant you query it for the two answers
<16> slid3r : Its a generic implementation which handles sending mail to users returned by a user-provided SQL query.
<15> then do some manipulation?
<11> somePriest: with a CASE statement in mysql it's very easy as well, and a little ***ier thant a bunch of IF
<16> zeitoun : I didn't know MySQL had CASE statements.
<15> lol
<15> me either
<10> bbtw slid3r, thanks for that, they granted me permissions :)
<11> !m somePriest control flow functions
<1> somePriest: (Control Flow Functions) : http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html
<16> zeitoun : I'm stuck on MySQL 4.0.*
<16> WHich is something else I'd alter if I was able.
<11> 5.0 is the default manual.... but case exist for a long time
<16> Ok.
<11> somePriest: http://dev.mysql.com/doc/refman/4.1/en/control-flow-functions.html => "CASE was added in MySQL 3.23.3"
<16> Cool.
<16> Just reading the syntax now.
<16> And I ***ume the case statement can refer to previously SUM'ed fields when a GROUP BY is used?
<17> [RainMkr], you around bud?
<18> So I have data already modelled and functioning, but there's one nasty hack in the database which I want to replace, and every time I try to ask about it people tell me I shouldn't be using a database, which is driving me nuts
<18> I have a series of rows which I need to be able to reorder fairly arbitrarily
<18> Right now, I'm sorting on a column of floats, and when I want to move row A inbetween rows X and Y, I bisect the range of the sort column for X and Y and update A's sort field to that bisection point
<18> That answer strikes me as exceptionally ugly, and has long-term potential problems when I hit epsilon
<18> Is there a more elegant answer?
<19> how to delete a user?
<9> deluser
<17> anyone know much about mysqladmin processlist I
<17> '
<17> m wondering why a process is sleeping
<3> StoneCypher: Yes and no. You could use a linked list approach, where each node has an ***igned id, plus a next column, populated with the id of the next node.
<18> xgc: i'm a little too much of an SQL novice to see a way to implement that wherein I could still order queries on said sort
<18> xgc: though I'm using mysql, a portable answer is highly desirable, fwiw
<18> which is one of the few advantages of the sort-on-float concept
<3> StoneCypher: The problem is as you state. There has been much analysis done in this area. Many of them require you to re***ign values of more than the inserted node.
<20> hello
<18> so, there just isn't a well known better answer?
<18> god, i wish i had come here first
<20> i recieve broken pipe when i try "mysqlaccess u-allix mowers.mdb "
<3> StoneCypher: You might get some hint/ideas from the following set of links:
<18> i just spent 45 minutes in petty bickering with people who thought i wanted to change the way numeric sorting in databases work, and getting banned for admitting what database backend i used
<3> http://troels.arvin.dk/db/rdbms/links/
<3> It covers issues in "Hierarchical models and traversal"
<18> wow.
<18> this is exactly what i needed.
<18> xgc, you're the (wo)man.
<3> StoneCypher: People often react that way when they don't have a clue. Don't listen to them.
<18> xgc: well
<18> it was just exceptionally bad today
<18> believe me, I'm from #winprog on efnet, I know about irc ***holes :)
<13> anyone knows how to optimise inserts in full text searches ?
<13> *full text tables
<18> xgc: on brief read, it looks like farey fractions are what I want. Do you recommend any alternatives from this list, or shall I just go ahead and implement this?
<11> TomH-: turn off indexing, insert your bunch of data, then turn on indexing again
<13> but doesnt it just need to create an index after i turned it on?
<3> StoneCypher: That's probably fine. But you might want to skim at least one article from each major area. On a side note, the linked list approach (while not one of the better approaches) is actually orderable in most any standard database.
<21> what type of field should something like 'gid or uid' be?
<21> int?
<11> TomH-: it will but it is faster than doing it for every row inserted
<13> ok
<11> TomH-: if you have a lot of inserts of course.
<13> well i have frequent inserts
Return to
#mysql
or
Go to some related
logs:
php mysqlclient.so.14
+sub recurse( +perl -rpm
ubuntu phpmysqladmin install
synaptic package manager mirrors dapper
#linux
kubuntu riserfs
#osdev
meaning of chupa meu pau
setarch ubuntu
image sniffer
|
|