| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8
Comments:
<0> it won't let me checkin a file cuz one line is > 8000 bytees
<1> alphablue: using CVS?
<0> truechange
<2> Is there an easy way to move tables from one database to another?
<2> (on the same mysql server)
<3> I made all my application based in MySQL 5.1, but my datacenter use version 4.0. All the application works based in UTF8, any sugestion about what to do to avoid charset problems?
<4> convert to latin1?
<5> switch providers?
<6> Wow... SQL doesn't know about tags or tagging. :P
<6> Or tag either. Jeez.
<7> um, im using debian and i cant find mysql_config , any ideas how to get it ?
<3> shabbs,: AJAX doesn't handle Latin1, and I need AJAX on it
<6> shabbs: You might find this interesting, if you don't know much about tagging: http://www.businessweek.com/magazine/content/05_39/b3952408.htm
<8> of course SQL doesn't know about tagging
<4> Elazar: actually this was good help: http://en.wikipedia.org/wiki/Tags
<8> it doesn't know about stain removal either
<6> shabbs: Ah, nice. :P I searched Wikipedia for tagging, didn't find anything useful, and immediately gave up. Didn't think to try just tag.
<6> SQL still doesn't know anything about it, though. :(
<8> or how to bake brownies
<8> Tags are just data
<4> mmmm brownies
<8> really, really, simple data
<9> what is the command to change root p***word?
<9> lol this is a real noob question
<4> !m clarks reset root
<10> clarks: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<11> hey can someone take a look at this... http://pastebin.com/633310 ... maybe I'm blind, but I don't see a syntax error in there.
<4> quoting a literal might help
<4> though it shouldn't need it
<6> sjrussel: Yes, they are. What I'm most curious about is what the optimal way to implement them in a relational database is, though.
<11> hmm
<8> Elazar - depends on your requirements
<4> damn that's an ugly table
<6> sjrussel: Well, ***uming you've got a single entity that you want to be tag-able and you want to do stuff like tag clouds.
<8> wtf is that table for?
<4> tag clouds are simply 'weights' ***igned to tags based on popularity
<4> which really means the higher the count() the higher the popularity
<6> I'm ***uming for tag clouds you'd need a separate table for tags and a middle table to relate tags and the tag-able entity.
<8> do you need transactions? etc
<8> Elazar - you *always* need that
<8> at least, one with tags, people, and item
<6> sjrussel: Not necessarily. If you were only doing searching, full-text indexing might work better.
<6> sjrussel: Well, yeah, but people is a given.
<11> heh
<11> I guess I can't name columns AS and BY
<11> heh
<6> ironpig: Sure you can, if you use curly quotes when you reference them.
<6> i.e. `AS`, `BY`
<4> backticks :D
<6> Right, what shabbs said, sorry. :P
<6> Keep forgetting what the common term for them is.
<11> I should have said, I can not use AS and BY as column names without the curly quotes. :P
<11> backticks
<6> Ah, right. Yeah, you can't. :P
<11> I learn the hard way
<8> you should have said, wth am I creating this table?
<11> I already know the answer to that question... I shouldn't be, but its faster using BS name like AA and BB then it is to try and figure out what all this crap is.
<12> faster is seldom the best approach
<8> what are you trying to do?
<13> where can I find the documentation for setting up PRIMARY KEYs
<14> can i replicate from a 3.23.* mysql database to a 5.0.* server?
<14> im having some problems and wasnt sure if that may be my issue
<15> What are the problems?
<14> : Reconnecting after a failed master event read
<14> that is what 'show slave status' tells me
<15> Really should upgrade from 3.23 to atleast 4.0
<14> nothing on either side error log of much more value
<14> this is what the slave side error log says:
<14> 060331 16:51:42 [ERROR] Error reading packet from server: Could not open log fil
<14> e ( server_errno=2)
<14> but i have 3 other servers replicating off that master fine
<14> they are all 4.0 replicating from the 3.23
<15> 3.23 is OOOOOOOOOOOOOOOOOOLD
<15> They cut out a lot of old stuff from 5.0.
<15> But I have no idea.
<14> i am just needing to know if that is my problem or not....i realize the age.
<14> it works fine still for us.
<13> do I need to use InnoDB to have FOREIGN KEY constraints?
<15> Yes
<13> aight
<13> what's the diff between ISAM and Inno?
<13> just breifly... i read it once but forgot :P
<15> MyISAM or ISAM?
<15> !m r0xoR table type
<10> r0xoR: (CREATE TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html
<13> sweet
<15> Wrong page
<13> didn't know u hav a bot
<6> r0x0R: Inno doesn't support full-text indexing but does support transactions.
<13> oh and I'm looking for the page that documents PRIMARY KEY
<13> but the one i found trying to search mysql.com is just baloney
<13> Elazar, hrm... ok
<6> r0xoR: As far as I remember, that's the main difference.
<13> not sure if I need full text indexing... don't think so... not atm at least... but who knows
<13> i guess I'll use Inno
<13> how do I use the bot?
<13> i /msged it but it just says "get help on what"
<13> !help
<10> Get help on what?
<13> ...
<13> !list
<13> !commands
<10> Commands: bridges, channels, commands, conversation, conversations, country, dict, doc, e, fm, google, help, kick, lookup, m, man, mia, networks, owners, p, p***word, perror, php, plugins, pypi, query, rfc, rtfm, seen, source, spell, status, stfm, syncs, tell, time, toc, top,
<10> weather, who, whois, +ban, +bridge, +connect, +define, +disable, +disconnect, +enable, +forget, +garbage, +gbridge, +ignore, +ignores, +join, +kickban, +loglines, +logoff, +nick, +op, +part, +pkginfo, +prefix, +quiet, +rebuild, +reconnect, +respond, +say, +setpwd, +spill,
<10> +spill, +stfu, +sync, +top10, +top5, +topall, +unbridge, +unignore, *debug, *manhole, *owner, *regenerate, *resetpwd, *upgrade
<16> ummm, maybe try asking it for help on "something"?
<13> aight, k sorry, won't spam the bot anymore
<16> as in !help topic
<16> and !man topic is the most useful command
<13> !man primary key
<10> (CREATE TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html
<13> !m foreign key
<10> foreign: (SELECT Syntax) : http://dev.mysql.com/doc/mysql/en/SELECT.html
<13> !man foreign key
<10> (PRIMARY KEY and UNIQUE Index Constraints) : http://dev.mysql.com/doc/mysql/en/constraint_primary_key.html
<17> does anyone know how to lock an entire server for read-only?
<18> roo9 set it to readonly in the smb.conf
<17> soop: smb.conf ?
<13> iirc a TIMESTAMP column gets updated with every UPDATE SQL query... is that correct?
<13> i've got date_created and date_modified
<13> this is my understanding of timestamp and if that's true it seems a logical choice to use it for date_modified
<16> r0xoR: it can be used for both depending on how it the columns are specified. The behavior of timestamps changed in 4.1
<19> Hi all!
<19> I' m running a script with \. file.sql and I get:
<19> Query OK, 0 rows affected, 3 warnings (0.01 sec)
<19> how can I see the warnings
<16> !m StR show warnings
<10> StR: (SHOW WARNINGS Syntax) : http://dev.mysql.com/doc/mysql/en/SHOW_WARNINGS.html
<20> man what a bitch, set up a whole auction site to run on mysql 5 and now the host only supporst 4.0
<20> is there any way to get NOW() and CURRENT_TIME etc to work in mysql 4?
<21> TIME()?
<13> if i put not null on a character datatype what will it be?
<19> inviso: I cannot get the warnings because another query is executed after the one that reports de warning, and that one does not report any warning
<13> just the empty string?
<13> i mean what will the default value be?
<16> StR: then don't execute the second query?
<16> !m r0xoR timestamp 4.1
<10> r0xoR: (TIMESTAMP Properties as of MySQL 4.1) : http://dev.mysql.com/doc/mysql/en/TIMESTAMP_4.1.html
<19> inviso: it is a batch file... a lot of queries... and it is a very big file, so I don't want to test each query
<21> StR: So... test the query that gives you trouble?
<22> i have a rather annoying problem, i'm sure it's common, but it's annoying the hell out of me: the characters and get converted to ? when stored ... but i can't see an obvious character set conflict
<23> ok, I read this some where, that you can spcify a different location for .MYI file to be created but can't remember the correct method, any one know the command that does that?
<17> anyone know what the best way to do a copy of a large mysql database is, i'm copying a database from one partition to another on a server
<21> Quite possibly mysqlhotcopy
<17> doesn't work on InnoDB :(
<24> hi all
<24> anyone got time for a newb?
<15> no
<20> If you designed a site on a quote basis, and it really wasn't that worth it to you, but you finally finished the site - then it turns out the clients host is running old versions of PHP and MySQL and your site basically doesn't work (host refuses to upgrade).. what do you do?
<15> mugger, Kill them.
<15> mugger, Why won't it work?
Return to
#mysql
or
Go to some related
logs:
hot install mysql-devel package
#osdev
#php
#lisp
#perl
from network+install Ubuntu
#suse
r quoteed string
#php
verlihub for centos4
|
|