#mysql
09 October 2007
Total 22 pages. You are browsing page 5/22.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last
04:55 <****> how do i tell mysqld to use a diff config file?
05:02 <****> hi how does someone "cut off" an earlier part of a table to archive, so that the current database can be faster?
05:04 <****> good evening, I'm looking for an irc channel for ms-sql-server2005
05:04 <****> anyone know one off the top o their head?
05:15 <****> #microsoftsux ?
05:17 <****> hello guys! Any idea howto import a 1.5 Gb mysqldump file?
05:18 <****> mysql -u user -p databasename < dumpfile.sql
05:19 <****> not working
05:19 <****> What! not working? Really! did you look in the error log?
05:20 <****> doesn't work
05:20 <****> Doesn't work is not a helpful statement. Was there an error? Unexpected results? Does it sit on the couch all day eating all your cheetos and ignoring the classifieds? Be specific!
05:21 <****> http://rafb.net/p/pWc28L92.html
05:22 <****> sorry to repeat: how does one "cut off" an earlier part of a table to archive, so that the current database can be faster?
05:23 <****> !perror 2013
05:23 <****> hmm
05:23 <****> well it looks like mysql is crashing... what do the mysql logs say?
05:24 <****> anyone care to speculate what could happen if I killed a process that is adding an index to an innodb table?
05:24 <****> i got no error message
05:26 <****> gone away
05:26 * ToeBee looks at the_wench
05:26 <****> any idea why id be getting this error?
05:26 <****> 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY thedate DESC'
05:26 <****> thought she had a factoid about that
05:27 <****> am i screwing something really simple up?
05:27 <****> any ideas how a table just disappeared? The MYI/MYD/frm files are missing on the filesystem...
05:27 <****> http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
05:28 <****> when importing I got error in log: /usr/local/libexec/mysqld: Out of memory (Needed 113040384 bytes)
05:28 <****> aha
05:28 <****> (log was disabled before)
05:28 <****> is there something that makes mysql unhappy about accepting connections from an ssh tunnel? Or some way to turn up the log level to see why its unhappy?
05:29 <****> scott0: presumably you have an error in your SQL syntax...
05:30 <****> angler_: someone issued a drop table query?
05:31 <****> is there a quick way to purge an entire database and resetting all indexes?
05:31 <****> without deleting it
05:32 <****> I'm trying to connect over an ssh tunnel. I have bind-address =127.0.0.1 and I'm getting the connection to the server, and mysql is immediately dropping it. any ideas?
05:33 <****> ToeBee, well that would mean someone got access to the server. mysql server is still running and lsof doesn't list the table as open at all.
05:33 <****> bah. cursed software!
05:38 <****> Why does following the official manual example SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = `mytable`; return an error #1054 - Unknown column 'mytable' in 'where clause'
05:38 <****> because of the quotes
05:38 <****> use '
05:38 <****> cuz there is no 'mytable' in your db?
05:47 <****> hi guys, there is a limit to how many bytes a UNIQUE key can be....what is a good method for dealing with columns that must be unique, which are longer than 300 bytes
05:48 <****> shoot your db designer in the head?
05:49 <****> is the implication that one should never need unique columns with more than 300 bytes?
05:53 <****> how to insert if record not exists ?
05:56 <****> RENAME TABLE #__weblinks TO jos_weblinks;
05:56 <****> and I'm getting an error about sql syntax
05:58 <****> Atlantiz: define "an error"
05:58 <****> ERROR 1064 (42000): You have an error in your SQL syntax;
05:59 <****> !m e1z0 insert
05:59 <****> e1z0 see http://dev.mysql.com/doc/refman/5.0/en/insert.html
05:59 <****> i read it already
05:59 <****> but not understand
05:59 <****> Atlantiz: try putting the table names in `
05:59 <****> I suspect the # may be messing things up
06:00 <****> note, ` not '
06:00 <****> I'll give it a try
06:00 <****> success!
06:01 <****> thank you
06:01 <****> yay
06:02 <****> so any suggestions for unique entries which are greater than 300 bytes?
06:03 <****> its more like 1000 bytes
06:04 <****> but since utf8 currently can take up to 3 bytes per character, the character count can be lower
06:04 <****> a3as3as3: you know you can create the index on a prefix, right?
06:05 <****> jbalint: but then i might still have rows with the same column data right?
06:05 <****> i am trying to store matrices....of arbitrary dimension
06:05 <****> and i need to store only unique matrices
06:05 <****> perhaps my entire approach is flawed
06:06 <****> i was going to store the entire matrix as a string
06:06 <****> is there a better way
06:06 <****> are you using utf8?
06:06 <****> yeah
06:06 <****> if it can be ascii, than you can get almost 100 bytes unique
06:07 <****> er... 1000
06:07 <****> not 100
06:26 <****> how do I zerofill numbers that I return in a select statement (without changing the column types of the table that I am selecting from )?
06:27 <****> how do I zerofill numbers that I return in a select statement (without changing the column types of the table that I am selecting from )?
06:27 <****> sorry for that..
06:43 <****> spiral_shell: select statements won't modify table columns, or do you mean the data type returned by the select?
06:45 <****> elaborate on "zerofill numbers", show what you're getting and what you would like
06:56 <****> It sounds to me like he's asking how to SELECT a value PADDING it with zeros.
06:57 <****> ie if the value is 8, he wants it to be selected as 00008
07:03 <****> ok...let try this again from a different perspective.....how do people check for uniqueness of binary data?
07:03 <****> EoN is right
07:04 <****> I am looking for a mysql professional to help me with my schema.
07:05 <****> So Zero filling would have this effect : 13 would be 013, 2 would be 002 and 231 would be 231
07:07 <****> Where would I be able to find a mysql pro to help me with my database?
07:09 <****> I am willing to paypal you money today to help me
07:10 <****> Holy cow, someone talk
07:16 <****> Sugardaddy32: you can get paid help via the mysql site no?
07:30 <****> if I have an sql command that uses something like '... WHERE id IN (3, 67, 2, .....)' is there a way to order my query by the values inside the 'IN ( .... )' ?
07:30 <****> i want them to appear in the order that they are printed in that IN comparison.
07:31 <****> possibly not
07:32 <****> if I have an array of id's and i want to do another query on another table, and i need the query to produce the ids in order, is there a way to do that without doing individual queries for each array item?
07:32 <****> im just trying to avoid doing queries for each item in my array.
07:33 <****> isn't the initial items in some specific order?
07:33 <****> yah
07:33 <****> they are in the order I want.
07:33 <****> is it in an order dependant on the data?
07:33 <****> but not in any logical order where I can just do a ORDER BY id DESC or ASC ...
Total 22 pages. You are browsing page 5/22.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last