| Chris8494 | PaulWay[w] - this is an intermittent problem, or constant? |
| PaulWay[w] | constant. |
| SyL | wow. I think I screwed up mysql... nice... |
| Chris8494 | can you try putting mysql.sock where it wants it, just for testing? |
| SyL | I can login as root without a password, but I can't see any accounts. it complains I'm not root awsome. |
| Chris8494 | heh |
| PaulWay[w] | The specific error I'm getting is ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/mysql.sock' (2) |
| SyL | so how would one go about just destorying the database and starting over? there's nothing really special I want in it |
| Chris8494 | SyL - on Windows, just uninstall MySQL, delete all of the files, and start over with a new install |
| SyL | core 6 fedora? |
| Chris8494 | right well, sorry, don't know that one ;-) |
| SyL | heh |
| PaulWay[w] | Fantastic - HY000 is "General driver-defined error". |
| Chris8494 | PaulWay[w] - /var/lib/mysql/mysql.sock rather than /opt/mysql/mysql.sock - just to clarify, /opt... is where it actually exists, right? or is it the other way 'round? |
| SyL | PaulWay[w]: are you sure it's in /opt/ at all? |
| PaulWay[w] | /opt/mysql/mysql.sock is where it exists. SyL: Yep, definitely there. And definitely not in /var/lib/mysql |
| SyL | PaulWay[w]: what distro? |
| PaulWay[w] | /etc/my.cnf has datadir=/opt/mysql/ and socket=/opt/mysql/mysql.sock |
| SyL | PaulWay[w]: what is the mysql db file called? maybe I can just delete it? |
| PaulWay[w] | SyL: Normally it'll be in /var/lib/mysql/* So I'd remove the package, remove /var/lib/mysql, remove /etc/my.cnf, and reinstall the package. |
| SyL | PaulWay[w]:: thanks... |
| PaulWay[w] | !problem. |
| SyL | PaulWay[w]: what is your issue you are trying to figure out? |
| PaulWay[w] | I've adjusted my configuration to point to a different directory for my data files and socket. And now for some reason the mysql client insists on looking for the socket in a place where it doesn't exist. And is not specified anywhere AFAICS. |
| SyL | how many my.* files are in your /etc/ dir? |
| PaulWay[w] | SyL: /etc/my.cnf and /etc/my.cnf.old (which is just stripped down to the datadir and socket lines). |
| roler | can I copy a table entry to a duplicate table entry using a new id of course? |
| PaulWay[w] | Create a copy of an existing table, giving it a new name, yes? |
| roler | actually just one row not the whole table |
| PaulWay[w] | Yep, sure you can. |
| roler | how do I do that :) |
| PaulWay[w] | create table <newname> as select * from <oldtable> where <condition> |