#mysql - Sat 10 Mar 2007 between 02:00 and 23:28

NY Lost Funds



fatpelthas anyone used the init_connect system variable ?
chadmaynardrxKaffee: tias
actionfatpelt is wondering if the requirement of SUPER in an sql applies to the init_connect
fatpeltis wondering if the requirement of SUPER in an sql applies to the init_connect
chadmaynardmycpuisneutralnet: ALTER TABLE `locations` ADD CONSTRAINT `fkey_locations_on_weather_feed_id` FOREIGN KEY (`weather_feed_id`) REFERENCES `weather_feeds` (`id`) ON UPDATE CASCADE ON DELETE SET NULL; is the query?
mycpuisneuralnetchadmaynard: yes
vice-versaDrstroker: SHOW COLUMNS FROM tablename
cyziei have open firewall for my mysql to allow access from LAN. do i need to restart mysql to allow connection using tcp/ip ?
XgcDrstroker: or see information_schema
Drstrokeri just exported the table and data and used the line from the insert
;)
cyziei have open firewall for my mysql to allow access from LAN. do i need to restart mysql to allow connection using tcp/ip ?
xscfgnope.
rtanhi
fholmes_laptopWhy am I getting permission denied LOCK TABLE errors when I am trying to use mysqldump?
Is it a permissions issue with my user account?
backup database
backup
mysql backup
database back
database backup
actionToeBee looks at fholmes_laptop
ToeBeelooks at fholmes_laptop
vice-versalol
fholmes_laptopsorry. trying to get the bot to give me some websites
wwalkermysqldump
the_wenchmysqldump -> http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
ToeBeewell all mysqldump does is do a select * from your tables
it may try to lock the tables beofre it does that though
fholmes_laptopthat doesn't help me. It is not allowing me to backup.
ToeBeeI think you might be able to tell it not to do that
wwalkerfholmes_laptop: try adding --skip-lock-tables
not sure if that is the right ont
fholmes1tonight is just a terrible night.
I am sure i just missed what you said. Hopefully you can repeat it for me. My connection keeps dropping for some reason.
a brand new 10mb connection and it just keeps dropping me off. I am getting really frustrated with that as well. Keep having to relogin to my ssh sessions.
Do you think it could have anything to do with needing to flush my tables?
vice-versawwalker -> fholmes_laptop: try adding --skip-lock-tables
Dr_LinkIs this a valid MySQL query: SELECT * FROM news ORDER BY id DESC LIMIT 0, 3
actionDr_Link hangs head in guilt
Dr_Linkhangs head in guilt
Ooops
I meant SELECT * FROM news ORDER BY id DESC LIMIT 3

Page: 2 9 16 23 30 37 44 

IrcArchive

NY Lost Funds