#mysql - Tue 27 Mar 2007 between 00:52 and 01:06

NY Lost Funds



jcrawfordnice my ex's family is in Eugene
loved it there, spent 2 weeks out there
Melt_Downdrfreeze stop mysql and copy the directory to the current mysql dir and restart mysql
aivukSome idea to my problema anyone? Melt_down tha link was to me?
drfreezeMelt_Down: thx. will try
jcrawfordwent to some town called "sisters" or something wacky like that lol
a volcano etc.
_syphilis_drfreeze: if its innodb without a seperate tabespace (.ibd file) the data directory isn't enough
jcrawfordthen went to bend
_syphilis_drfreeze: (for myisam it's fine)
agoreare you famous Joseph crawford
Melt_Downdrfreeze then dump the sql and import it again unless you know the data is without errors and from the same mysql version on the same os
aivuk no the link was for someone else
i hoped seekwill would take a look at it ;)
aivukOk sorry Melt_down, thanks
can this be a bug in MySQL? I don't see a reason to the slowness when I increased in 100 entries in my table...
seth1246What permissions should I give a user for mysqldump?
aivukread tables
drfreezeMelt_Down: the db shows up but not the tables
Melt_Downaivuk try a join instead of a subselect
and use explain
drfreeze are you using phpmyadmin?
drfreezenope
_syphilis_drfreeze: do you have a frm, myd and myi file for every table? are they readable by the mysql user?
aivukI tried that Melt_Down, without success...
drfreezemysql administration OS X
aivukthe same slowness...
agore#sql-**********.frm #sql-*******.MYI #sql-*******.MYD files in my data directory for one of my myisam db's
can I delete them
just seem to be junk from old ALTER table commands I aborted
drfreeze_syphilis_: the db I'm trying now has .frm and .opt flies
*files
agorein fact the date on those files hasn't changed since I aborted the ALTEr tables
so can I just delete them ?
_syphilis_drfreeze: issue SHOW CREATE TABLE xxx; on the original server; what does it show for ENGINE?
seekwillOh hey _syphilis_ did you get my reply??? :)
_syphilis_seekwill: yeah, i was going to read about mysql's cursor support, but i got distracted :)
seekwill_syphilis_: Ok cool. I had to bug Therion! :)
Melt_Downanyone can help me?
seekwill!wench learn SYN is ACK

Page: 1 8 15 22 29 36 43 50 57 64 71 

IrcArchive

NY Lost Funds