Copy a table to another database

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

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

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)

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

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


Follow

Get every new post delivered to your Inbox.