| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
Comments:
<0> insert values in a subselect that is dependent on t1, i mean, rather than looping through every t1 just to insert the stuff.
<1> hansbrix, describe your tables and your question in a pastebin
<0> the tables are too complicated, this is basically just a theory question
<1> insert into a join b on condition set a.f1 = b.f1 #something like that?
<2> All I did was get the dependencies and mysql-server by doing 'sudo apt-get install mysql-server' it then at the end of the install process trried to start the mysql server. it failed and gave me an error when i tried to run it through the instructions in that link I get this erro - http://pastebin.ca/49407
<0> there are many t2's for each t1.a
<3> well then we should probably start with that first error message, huh ?
<3> bobfield: any idea anyway ?
<1> Do you have binlogs enabled?
<3> i dont know - where can i check that ?
<1> do you have a --log-bin in your config?
<1> or just plain log-bin rather
<4> ugh
<4> I accidentally took my vicodin instead of my diabetes meds
<4> whoops
<5> hehehe
<5> Braden` when life gives you vicodin, drink beer :P
<4> r0xoR: Heh, I think thats the last thing I want to be drinking after taking that medication =P
<5> i had a friend once who ate 11 vicodin and drank 3 beers
<3> bobfield: log-bin is commented out
<3> and isnt invokey by the rcmysql script also.
<5> 'course he died in a puddle of his own vomit... so... go figure
<3> so it should be turned off.
<2> funky: That first error message is the same as the 2nd 3rd 4th and 5th
<2> Almost all the errors I've gotten are in this - http://pastebin.ca/49407
<1> word, you sure you don't have a server running already? try ps ax | fgrep mysql
<4> r0xoR: 3-5 vicodin is enough to send even a healthy person into a siezure, so I am not surprised.
<3> word: oh well.. you want to change path/to/mysql to what your actual path to mysql is
<2> output of ps ax | fgrep mysql - 9760 pts/1 R+ 0:00 grep -F mysql
<3> bobfield: how would binlogging be of any help ?
<2> how do I find out what the actual path of mysql is? is there a file in the path I can search for?
<1> it wouldn't, I was just thinking of something that might cause extra files to be open
<3> gotcha.
<3> so any other ideas ? ;)
<1> what does SHOW PROCESSLIST tell you?
<4> word: type --> "type mysqld_safe"
<3> 10 processes running
<3> (i have powered up my apache again)
<2> starts and stops right away Braden`
<4> word: No, I said type the word "type"
<4> as in: user@host# type mysqld_safe
<6> a a ai use which
<2> oh o.O
<6> which mysqld_safe
<6> tells you which file you are gonna run
<2> mysqld_safe is hashed (/usr/bin/mysqld_safe)
<4> hashed!?
<4> What distro are you running?
<2> Braden`: That's what it said o.O Linux Kubuntu Breezy
<4> I have no clue why they would hash that
<2> Um, me neither? lol
<3> bobfield: backup strategy would you recommend ?
<1> well I just use mysqldump personally
<3> while the database is running ?
<3> do you lock the tables manually ?
<1> I do my backups offline
<3> i c.
<3> hmm
<1> I see you're looking at a hot backup solution
<3> yes
<1> so is that what's failing?
<3> exactly
<4> You could use phpmyadmin and use the export function
<3> i need to run that by cron job - as i dont want to get up each night at about 3 o'clock ;-)
<3> supposed to be a reliable regular backup
<3> !m funky hot backup
<7> funky: Nothing found
<3> SQL: what a pity ;)
<1> !m funky mysqlhotcopy
<7> funky: (The mysqlhotcopy Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqlhotcopy.html
<1> that one?
<1> so mysqldump doesn't work?
<1> I thought it should work only slower
<3> the problem of mysqldump is that you cant be sure that the database dump you get is still synchronized.
<3> so you might end up having parts backed up before, others after a transaction - and there you go with a dump you can dump into the bin ;)
<3> mysqlhotcopy locks tables before dumping them.
<1> Have you checked out the --lock-all-tables option?
<1> or even just --lock-tables ?
<3> then they are locked - but they aren't flushed
<3> so it might still be an intermediary state that makes problems if you want to recover from it.
<1> there's a --flush-logs option too
<3> which only flushes the logs but not the tables... see the FLUSH Syntax
<3> well, i think I just found a workaround...
<3> If i tweak my regexp's selecting the databases to update a little I can reduce the number that is handled at once.
<3> this might work out fine.
<2> so uh guys any idea what's wrong with mine?
<1> sounds maybe like it's running but someone's looking in the wrong spot for the socket file
<2> how do I point that someone to the right spot?
<1> well first of all did you find the socket file somewhere else, like /tmp ?
<2> I'll do a search for .socket...
<1> look for mysqld.sock
<2> ok searching.
<1> my.cnf should give you some clues about where this file is supposed to be
<2> ok
<2> couldn't it be looking in the wrong spot too though? o.O
<1> my.cnf has two places, one that tells mysqld where to put it, and another to tell clients where to look. They should be the same.
<2> ok
<2> find files and folders didn't find mysqld.socket
<2> anywhere
<1> it's mysqld.sock
<2> I'm having it search for just mysqld now
<1> have you looked at my.cnf?
<2> socket= /var/run/mysqld/mysqld.sock - that's what i found there
<1> in both [client] and [mysqld] ?
<2> yup
<2> it's not there
<1> what command did you use to start mysql?
<2> I'm not so sure it is started I tried shutting it down and it made an error
<1> "ps ax | fgrep mysqld" doesn't show anything?
<2> 9946 pts/1 R+ 0:00 /bin/sh /bin/fgrep mysqld
<1> okay so it's not running
<1> hence no socket files
<2> How do I get it running? I've tried :-/
<1> mysqld_safe&
<2> says started then - STOPPING server from pid file /var/run/mysqld/mysqld.pid then stopped
<1> okay, find the .err file and look at it
<3> bobfield: are you keen on regexps ?
<1> I know very little in that department
<3> ;) do you happen to know how to specify what you do _not_ want the string to match ?
<3> like i have several dbs that are called sth like usr_webxy_z with x, y, z being numbers
<3> and of course the normal dbs like mysql etc
<1> !m funky regexp
<7> funky: (MySQL Regular Expressions) : http://dev.mysql.com/doc/mysql/en/Regexp.html
<1> ^Best I can offer you
<8> hey how can i use the mysqldump utility to make Inserts for each table record?
<3> :) thx
<8> trying to look through the --help
<1> !m MGrim mysqldump
<7> MGrim: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<8> yeah im there
<8> i can dump a database
<8> but my insert queries are M***IVE
<8> i remember mysql 3.x made an insert query for every table record
<8> thats what i need to do
<2> bobfield: Where would the .err file be?
<1> in the directory with your databases
<9> LIST
<2> I have no idea where that is.
<2> datadir?
<1> in the data directory, yes
<2> There aren't any .err files in that directory or anything under it.
<1> somewhere there is a file <yourcomputename>.err
<2> what would it be named? I can't search for the extension .err
<1> your computer's host name + .err
<9> does anyone here have a doc about views in mysql 5.0.1
<2> um so if in Konsole it it's word@TJCOMP my host name would be tjcomp?
<1> !m juanca7777 views
<7> juanca7777: (Views) : http://dev.mysql.com/doc/mysql/en/ANSI_diff_Views.html
<1> word, sounds right
<1> so tjcomp.err
Return to
#mysql
or
Go to some related
logs:
mod_php _SESSION session_start()
debian vfs: file-max limit 8192 reached
#linux
#math
ubuntu sqwebmail breezy
#ubuntu
dapper theme + firefox
audit2allow howto
nvidia-xconfig gentoo portage
ubuntu install php5 can't open
|
|