103 reputation
5
bio website
location Palm Coast, FL
age 54
visits member for 1 year, 8 months
seen Apr 22 '13 at 23:27

Retired airline pilot, learning code to give the work of repetitive tasks to a processor & program and help others receive the benefit of this.

Develop, design & maintain a web based application using php, mysql & curl. Beginning the journey into object oriented programming with focus on iOS.

My hope is to put in answers as much as ask questions. Everyone has the opportunity to learn.

A good answer is one that helps the asker grow.


Sep
24
awarded  Autobiographer
May
27
awarded  Popular Question
Apr
18
comment Need ideas about OPTIMIZE TABLE
Regarding your last sentence, there IS work to be done with queries, indexes and cache. I'm NO expert. :)
Apr
18
comment Need ideas about OPTIMIZE TABLE
Do you see a problem with optimizing the tables monthly? (Thanks for the statistic tips.)
Apr
18
asked Need ideas about OPTIMIZE TABLE
Apr
2
awarded  Supporter
Feb
17
awarded  Scholar
Feb
17
accepted Problem with (not) Locking Tables during Restore
Feb
17
comment Problem with (not) Locking Tables during Restore
Wow. That was easy! Thank you for clarifying and for including the link about comments.
Feb
16
revised Problem with (not) Locking Tables during Restore
edited title
Feb
16
revised Problem with (not) Locking Tables during Restore
Cleanup question
Feb
16
comment Problem with (not) Locking Tables during Restore
@Andomar I too thought it should be User_test_import failed It is actually ERROR 1100 (HY000) at line 60: Table 'User' was not locked with LOCK TABLES I don't understand why the User table must be locked. ??
Feb
16
awarded  Editor
Feb
16
revised Problem with (not) Locking Tables during Restore
added 91 characters in body
Feb
16
comment Problem with (not) Locking Tables during Restore
@Andomar Right. I trust and I also want to run the restore without commenting LOCK TABLES. See edited question.
Feb
16
answered How to search whole MySQL database for a particular string
Feb
16
asked Problem with (not) Locking Tables during Restore