| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> what error are you getting?
<1> well thats the problem
<1> I'm not getting an error
<1> it runs fine
<0> how are you running it?
<1> command line
<1> but it messes up the dataa
<1> data
<1> the reason I believe its a different bit of code
<1> is that on the first test it took a LONG time to run against the db and reduced records in a very small set per run
<0> maybe you should turn it into a select and see what output it's producing
<1> but on this occasion its flying through the records and altering say 100 rows per run
<2> http://pastebin.com/586676
<1> I hate that
<1> I think its really rude to just post pastebin url's
<2> what's the problem with my query ?
<2> ikonia, there's a query that triggers an error, and the error
<0> HowardTheCoward: maybe you have your table name and your AS aliases the wrong way round
<2> osfameron, explain what you mean please
<1> osfameron, seeing as I don't fully understand the sql written by bobcat properly, it would probably be better wait for him to come in and attempt to work it through
<1> rather than ask a 3rd party to try to pick it up from scratch
<0> where you have FROM pt AS phpbb_posts_text, perhaps you mean FROM phpbb_posts_text AS pt
<2> osfameron, right that must be it, thanks
<0> ikonia: indeed, well good luck :-)
<1> osfameron, thanks for the input
<2> osfameron, you were right, I think I can participate to "the silliest sql query" contest
<3> Is there anyway to print a sql schema so it prints hwo to create the existing tables, so it prints out: CREATE TABLE.... etc..
<4> SHOW CREATE TABLE tablename;
<4> or mysqldump with --no-data
<3> great, thanks
<1> or you could dump it
<5> Does anyone know why I am getting an access denied error from mySQL when I try to connect through an SSH tunnel?
<6> is it binding to localhost?
<3> I have my backup stuff with data in a file called sql
<3> I'm trying to get it back into the database: like so:
<3> $shell: mysql < sql
<3> It errors saying access denied for user.... So I put -u user -pp***word on there, but it errors saying on db selected
<3> Do I have to restart mysql without user logins required
<4> mysql -u root -pp*** dbnamehere < sql
<7> hi all
<6> depends gary, if the backup doesn't create the database you neewd to specify it.
<7> what is mysql?
<6> linuxboyfriend: I don't know.
<7> Rhizome: :)
<3> hmm
<3> it is erroring saying mysql syntax is wrong
<3> I didn't touch the file
<7> can anyone tell me that what is mysql?
<6> does it say anything more than that?
<3> problem wit hthese two lines: `menu_text` varchar(30) default NULL, `link` varchar(50) default NULL,
<6> linuxboyfriend: it's a swedish trout.
<3> :{
<7> Rhizome: yumee
<3> linuxboyfriend: www.mysql.com
<6> noo gary, don't reveal our secrets :/
<7> Rhizome, gary: are they provising this yummee fish ?)
<3> depends how good you are linuxboyfriend
<7> gary: i am always afraid of fish bones, they are very sharp
<6> gary: I suggest you just go through your backup manually and copy paste it into mysql.
<8> hrm, Is there some difference or special syntax one must use when creating stored procedures using an external file and slurping them in with < foo.sql, rather than entering them directly into the client?
<8> http://hashmysql.org/paste/viewentry.php?id=1537
<8> aside from the delimiter issue, there still seems to be another issue at hand. it is saying that I have a syntax error when reading from a file, but pasting the IDENTICAL text into the client (after setting the delimiter), it saves the procedure just fine.
<4> well it *is* a delimiter issue
<4> set the delimiter in the file as well
<8> aha!
<8> I suppose that makes sense :) thanks.
<9> Can anyone offer likely no more than 2 mins of help to me, with a small mysql + Vb2005 problem?
<10> Epica: But I don't have 2 minutes!!! :(
<9> damn haha :p
<10> Maybe other people do :D
<4> archivist: WB 1.0.5 beta is out
<11> ok will try when i get a chance
<11> have not seen anything about that bug though
<9> I'll type it out anyhow, maybe someone will care... trying to connect to a mysql database on my own computer here... using the mysql connector and imports mysql.data etc etc, and im getting the exception: A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call) no address was supplied
<9> when I open the connection
<9> any ideas??
<9> sorry, this is in vb 2005 too.. though I said that earlier anyways
<9> Dim conn As New MySqlConnection
<9> Dim SQL As String
<9> SQL = "SERVER=localhost;DATABASE=employees"
<9> conn.ConnectionString = SQL
<9> conn.Open()
<9> TextBox1.Text = conn.State.ToString()
<9> conn.Close()
<9> sorry for flooding guys
<9> hah
<0> the string you call SQL doesn't contain SQL
<0> can you connect to the database from mysql client with the same connection details?
<1> is bobcat a regular in here?
<0> http://www.connectionstrings.com/ suggests the format: "Data Source=server;Database=mydb;User ID=username;P***word=pwd;Command Logging=false"
<0> ikonia: 11:05 [freenode] -!- bobcat [n=bobcat@200.121.127.75]
<0> 11:05 [freenode] -!- was : Jonathan Debian
<0> 11:05 [freenode] -!- server : irc.freenode.net [Mon Mar 6 06:56:38 2006]
<1> I don't think thats the same guy
<1> I think I've got the spelling of his nick wrong
<9> Data source hey? hrmm.. instead of server, ill try that.. i have my root account and username set up too, but just left it out of that string when I pasted it for security, not that it matters
<4> archivist: neither have I honestly, but we'll see how this one gets along - let me know
<11> I must poke shabbs as hes waiting to try the new workbench as well
<9> got an exception that the keyword data server isnt supported, so I ***ume just "server" was correct
<9> osfameron when i connect through tthe client, i get this.. i ***ume im doing it right
<9> C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql.exe -u root -h localhost -p em
<9> ployees
<9> Enter p***word: ********
<9> Welcome to the MySQL monitor. Commands end with ; or \g.
<9> Your MySQL connection id is 27 to server version: 5.0.18-nt
<9> (throught the prompt)
<9> -p is really -D hah
<12> does anyone know what the decay function does in a unix scheduler
<1> give me an example
<12> i dont have one right now
<12> but do you know what it does
<12> not sure
<1> well, I actually don't know what your talking about
<1> what do you mean by sheduler
<1> and define function
<1> function within the source code, or an application function
<12> im talking about operating systesms
<12> e.g. rr scheduler
<12> i read that a clasic unix scheduler invovles both a decay function and a usage measure
<12> but i dont know what these terms mean
<1> the schduler controls things like cpu request queing
<1> as an easy example
<8> wow, prepared statements + stored procedures = happy infi
<12> Every user has a usage, which is a decayed measure of the work that the user has done. The decay rate is defined by an administrative decision which determines how long a user's history of resource consumption affects their response.
<1> irgendwas, interesting summary
<8> I have +5 balloon-resistant underwear. You can't hurt me.
<13> I need some help with altering a database from latin1_swedish_ci to utf8_swedish_ci
<13> Any one who could ***ist me..
<13> I'm using phpmyadmin, dont have that much experience in console mode
<14> xLnT: how many column to change
<10> infi: My balloon is +10 piercing.
<13> lokus well.. i really dont know..
<13> Is there a way to check=
<13> ?
<13> in phpmyadmin?
<14> xLnT: is the data in latin1 or in utf8 now?
<8> but my saving throw die is a d100.
<13> hehe i really dont know that either... but it says latin1 on collation
<10> infi: My balloon is far superior, I don't care :P
<14> xLnT: if everything don;t know, i don;t know how to ***ist too :) sorry
<13> lokus: tell me where to look.. but i believe the database is latin1
<14> it depends to what data yuo have now, otherwise it could corrupt rahter than convert
<14> !m character set
<15> character: (The SET Type) : http://dev.mysql.com/doc/mysql/en/SET.html
<14> !m xLnT character set
<15> xLnT: (Character String Literal Character Set and Collation) : http://dev.mysql.com/doc/mysql/en/Charset-literal.html
<13> lokus: it doesnt matter if we corrupt it.. we have backup
Return to
#mysql
or
Go to some related
logs:
BCM4318 freebsd
it8212 ubuntu
F5D7050 v3000 problem
#lisp
#web
#linux
#gentoo
how does update-static-leases work
svn connection denied
genpaches error
|
|