#mysql - Sat 3 Mar 2007 between 00:21 and 02:07

NY Lost Funds



CareBear\toanducit : Do you mean drop tables?
toanducityeah
CareBear\toanducit : Or delete rows?
fowlduckXgc: I just found out that the product already included such a diagram, argh!!!!
toanducitdrop tables
fowlduckwasted time...
CareBear\toanducit : Did you read "DROP TABLE Syntax" in the manual? I just looked it up and it is very simple.
toanducit : dro ptable name1, name2, name3 etc.
No, bedtime, need to get up again in oh two hours. :\
Take care!
StuBoAny body know what repair with keycache means for a mysql process state
emp_mit appears that nested sets are the best way to deal with hierarchal data in sql, is this correct?
StuBohelp....my db is taking hours doing a repair with keycache :(
vice-versaStuBo: how many records?
StuBovice-versa: a few million
from what Im reading on the web it could be doing it for many hours
about 26 million I think
all I did was add a new field to that table.....
the new filed isnt an index but some of the other fields do
vice-versayeah, it could even be days :(
StuBowould it bugger my db or table up if I killed the process
bugger it...im just going to kill it....I can't wait for days
vice-versadunno, but I've read references of others stopping the process to use myisamchk and or change to change myisam_max_sort_file_size and myisam_max_extra_sort_file_size
StuBoyeah....incressing their size might make it do a repair filesort as appose to repair keycache
vice-versaworth a try imo
lkthomasguys
does anyone wrote some batch record adding script ?
heelpphello
if im in my shell linux box what do i have to type to perform this command?
i need to create a script so that i can automatically input the commands in my script file and to manipulate my mysql
i forgot the syntax of mysql in shell scripting in linux
preactionmysql -e"run this command"
toanducitI have two table: aaaa_test1, bbbb_test 1. How do I drop 2 table in one statement?
help me
preactiondrop aaaa_test1; drop bbbb_test 1;
or! start transaction; drop; drop; commit;
though i doubt drop can be transactioned
toanducitDo you have other solution?
preactionwhy? this sounds like an xy problem
_syphilis_how do i change a view's definer?

Page: 4 11 18 25 32 

IrcArchive

NY Lost Funds