Copy a table to another database
Posted: 13.05.2009 Filed under: Long Story Short | Tags: copy, database, db, mysql, table Leave a comment »In mysql copy a table into/from another database
DB1.oldTable -> DB2.newTable
CREATE TABLE DB2.newTable LIKE DB2.oldTable;
ALTER TABLE DB2.newTable DISABLE KEYS;
INSERT INTO DB2.newTable SELECT * FROM DB2.oldTable;
ALTER TABLE DB2.newTable ENABLE KEYS;
[1] http://www.edmondscommerce.co.uk/blog/mysql/mysql-copy-table-from-one-database-to-another/
[2] http://forums.mysql.com/read.php?108,93119,93987#msg-93987
Photo Recovery
Posted: 26.12.2008 Filed under: Long Story Short Leave a comment »I have surely tested lots of photo recovery tools (such as photo recovery). However, most accurate and successful tool was Klix (1.0.2). I have recovered photos from USB hard drive, which seemed to be corrupted or deleted.
Autorun infection
Posted: 18.12.2008 Filed under: Long Story Short, Microsoft 1 Comment »For Windows…
Since I can not remember name of the infection causing, I had once removed manually from my computer. However, as I remember results, I was unable to enter drivers from my computer. Double click but nothing…
Anyway, I see that now I cant enable “show hidden files” from explorer. So I came up with this [1] from Experts-Exchange which is a great source.
I ran the script for registry (double-click):
hebele.reg file content:
—————————–
Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\Advanced\Folder\Hidden] "Text"="@shell32.dll,-30499" "Type"="group" "Bitmap"=hex(2):25,00,53,00,79,00,73,00,74,00,65,00,6d,00,52,00,6f,00,6f,00,74,\ 00,25,00,5c,00,73,00,79,00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,53,00,\ 48,00,45,00,4c,00,4c,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,2c,00,34,00,00,\ 00 "HelpID"="shell.hlp#51131" [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\Advanced\Folder\Hidden\NOHIDDEN] "RegPath"="Software\\Microsoft\\Windows\\CurrentVersion\\Explorer\\Advanced" "Text"="@shell32.dll,-30501" "Type"="radio" "CheckedValue"=dword:00000002 "ValueName"="Hidden" "DefaultValue"=dword:00000002 "HKeyRoot"=dword:80000001 "HelpID"="shell.hlp#51104" [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\Advanced\Folder\Hidden\SHOWALL] "RegPath"="Software\\Microsoft\\Windows\\CurrentVersion\\Explorer\\Advanced" "Text"="@shell32.dll,-30500" "Type"="radio" "CheckedValue"=dword:00000001 "ValueName"="Hidden" "DefaultValue"=dword:00000002 "HKeyRoot"=dword:80000001 "HelpID"="shell.hlp#51105"
Now everything seems okay. I can enable showing hidden files.
[1] http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Q_23886408.html
Flex VerifyError: Error #1107 solved (mine)
Posted: 07.12.2008 Filed under: Code, Long Story Short | Tags: 1107, error, flex, solved, verifyerror Leave a comment »I am getting this error “VerifyError: Error #1107″ when I try to instantiate a new object I have implemented as a ActionScript class file .as in other file.
Problem seems to be so redicolous when I observe that I can not even create a new object that does nothing operational, say:
package {
public class DenemeClass extends Class {
public function DenemeClass() {}
}
}
That’s it… And I even was not able to create a new instance of this. And getting this error trace:
[SWF] C:\Documents and Settings\user\My Documents\Flex Builder 3\Denemeler\bin-debug\Denemeler.swf – 555,437 bytes after decompression
Trace: Inside #1
verify global$init()
stack:
scope:
locals: global
0:getlocal0
stack: global
scope:
locals: global
1:pushscope
stack:
scope: global
locals: global
2:debugfile “C:\Documents and Settings\user\My Documents\Flex Builder 3\Denemeler\src;RBIs;RBITree.as”
stack:
scope: global
locals: global
5:debugline 3
stack:
scope: global
locals: global
7:findpropstrict {RBIs}::RBITree
stack: global
scope: global
locals: global
10:getlex 13
stack: global Object$?
scope: global
locals: global
12:pushscope
stack: global
scope: global Object$
locals: global
13:getlex 50
stack: global Class$?
scope: global Object$
locals: global
15:pushscope
stack: global
scope: global Object$ Class$
locals: global
16:getlex 50
stack: global Class$?
scope: global Object$ Class$
locals: global
18:newclass RBIs::RBITree$cinit()
VerifyError: Error #1107: ABC verileri bozuk, s?n?r d??? okuma giri?imi.at global$init()
at RBIs::DenemeClass()[C:\Documents and Settings\user\My Documents\Flex Builder 3\Denemeler\src\RBIs\DenemeClass.as:7]
at Denemeler$/runDeneme()[C:\Documents and Settings\user\My Documents\Flex Builder 3\Denemeler\src\Denemeler.mxml:8]
at Denemeler/___Denemeler_Button1_click()[C:\Documents and Settings\user\My Documents\Flex Builder 3\Denemeler\src\Denemeler.mxml:12]
I have just recognized that expression “extends Class” which was automatically added to my class definition by Flex was causing this. I think there is something wrong with Class constructor itself or I am unsufficient to satisfy Class constructor needs, since I am newbie.
Anyway, solved…
About this issue; same error with different circumstances described at:
[1] http://bugs.adobe.com/jira/browse/SDK-14054
Adobe Flex 3 – Serial Problem
Posted: 05.12.2008 Filed under: Long Story Short Leave a comment »I have just installed Adobe Flex 3 and after running for the first time, have a box saying trial has expired. However, in fact, I had just installed it. Then I found this,
You edit FlexBuilder.ini in the installation path and add these lines in the end:
-Duser.language=en
-Duser.location=us
There you let Java run the Flex application in US locale which is not your default Windows locale -as in mine.
Thanks to: http://www.mmistanbul.com/soru-cevap/action/detail/question/flex-3-serial-problemi