#mysql
30 October 2007
Total 22 pages. You are browsing page 3/22.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
01:35 <****> nm on the last thing
01:43 <****> ok
01:43 <****> so the documentation describes the effects of an index
01:43 <****> like it speeds up searches
01:43 <****> but doesn't explain how it does it
01:44 <****> so if I use mysqldump without --lock-tables.. whats the worst thats going to happen?
01:44 <****> AIDS
01:45 <****> Can you initiate external programs from stored procedures? I'm thinking something like shell in basic. What I want to do is get a file from another computer using ftp, then import the data to a table using mysql stored procedures.
01:46 <****> devicenull: I suppose if you've got relations, they may break
01:46 <****> is there like a check all tables thing?
01:47 <****> hm
01:47 <****>a will be broken
01:49 <****> How I do a query that result in the most registry with most quantity of # in a field?
01:50 <****> Tommy3: you can also run sql statements from the shell command line by using the 'msyql -e' switch.
01:51 <****> for example; SELECT * FROM informations WHERE field LIKE '%#%' ORDER BY 'most # quantity'
01:55 <****> ki77a77: Im hoping that I can keep all the code in stored procedures and trigger the stored procedure to run the ftp (all from inside mysql, or at least initiate from inside mysql like you normally would run a script from cron) I may be being fooled by navicat here. It has a scheduler built in. It may just be using cron)
01:57 <****> ok
01:57 <****> one of my innodb pages is corrupt
01:58 <****> the error message says to use CHECK TABLE
01:58 <****> but the DB crashes when I do that
01:58 <****> I'll just reload the data
02:06 <****> MySql wont startup because there is a conflicting socket in /tmp/mysql.sock how do I find out how to shut that socket down?
02:06 <****> lsof will tell you what's using it
02:07 <****> antum: are you sure the mysqld server is not already running?
02:07 <****> netstat -pan will tell you if something's connected to it
02:08 <****> thanks I'll run those and see what happens
02:10 <****> sensei the lsof gives a huge amount of output... anyway to cut it down? also netstat -pan doesn't seem to work on my osx system :(
02:11 <****> antum: lsof | grep mysql.sock
02:11 <****> sensei it's come back blank... does that mean its safe to move or delete?
02:12 <****> Supposedly
02:13 <****> hahaha
02:13 <****> http://www.john-hunt.com/mysql.txt < How can I alter this query so that the WHERE line doesn't limit the result set (i.e - it still returns users with no activities)? (btw, my boss helped me make the query in the first place, but he's unavailable atm)
02:13 <****> btw, I'm aware it's mysql 3.x format
02:17 <****> JohnRobert: remove the where and it returns all rows :)
02:18 <****> yes, but I want the where stuff, but I also want where they don't have any activities
02:18 <****> JohnRobert: user with no activities? what does that mean
02:19 <****> a is activities
02:19 <****> erm
02:19 <****> JohnRobert: oh, that, that is not in the WHERE, but in the FROM
02:19 <****> so do you suggest I put the activities join in a left join rather than in that from bit?
02:20 <****> left join
02:21 <****> typical
02:21 <****> my ssh session got stuck half way through pasting a query :/
02:23 <****> hmm
02:23 <****> still seems to limit it
02:23 <****> gah, I'm no good at complex queries :/
02:35 <****> how do I store a single value from a select statement inside a variable in a stored procedure?
02:44 <****> SELECT @VALUE = (SELECT foo FROM bar)
02:53 <****> trying to import an SQL file into an empty database.
02:54 <****> I couldn't do it, I keep getting an error with phpMySQL, now im trying with cocoa mysql, seems to be more successful but at the end I get a very long error and then when I check the site I can see that only some of the data is restored.
02:54 <****> mysql -u user -p database < file.sql
02:54 <****> ill try that... can I just place that file on the root of the server?
02:56 <****> wherever you can get to it. This assumes you have shell access
02:58 <****> I ssh in and then try what you said above and get ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
02:59 <****> I ran this command mysql -u shanek -psupport eredluin_smf1 < import.sql
03:00 <****> *temp user
03:00 <****> doesnt make any difference from root
03:00 <****> !perror 2
03:00 <****> System error: 2 = No such file or directory
03:01 <****> is this your own server or a hosting provider? That error usually means mysql isn't running...
03:01 <****> I can see the file though
03:01 <****> its the hosting provider
03:01 <****> is there any other way to do this?
03:01 <****> its shared hosting
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
03:02 <****> THIS CHANNEL IS TOO FILTHY! LET'S CLEAN IT UP WITH DIAL SOAP!
Total 22 pages. You are browsing page 3/22.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last