How to Backup MYSQL Databases

REM Export all databases names to file
mysql -h your-server-ip -u user-name -ppassword information_schema --skip-column-names --execute="SHOW DATABASES;" > databases.tmp
echo "Start!"
REM Look over database names

REM Outter loop to get table names

for /F %%A in (databases.tmp) do (
   echo "Exporting table Names for %%A"
   mysql -h your-server-ip -u user-name -ppassword %%A --skip-column-names --execute="SHOW TABLES;" >"%%A_tables.tmp"

   mkdir %%A


#### nested loop to create table name files per table
   for /F %%B in (%%A_tables.tmp) do (
   echo "Exporting data for %%B of %%A"
   mysqldump -h your-server-ip -u user-name -ppassword %%A %%B> "%%A\%%A_%%B.sql"
   )
)

del *.tmp

 

How to fix CLSID {00024500-0000-0000-C000-000000000046} error when using excel component in background code?

We have  a windows Service application which uses Excel Application Object. It used to work on some machines but not all, the error which I am getting is:

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.

After some struggling I found a solution and it works, solution is:

Solution 1:

  • Create directory C:\Windows\SysWOW64\config\systemprofile\Desktop (for 64 bit Windows) or C:\Windows\System32\config\systemprofile\Desktop (for 32 bit Windows) and give full permission
  • Run program “dcomcnfg” Go to “Console Root/Component Services/Computer/My Computer/DCOM Config/” Look up Microsoft Excel and choose properties.
  • Go to Security and Launch and activation permissions->customize->add network, network service, administrator, interactive, system and everyone and give full access
  • Now go to “Identity” and select “The interactive user”.
  • Now go to “Console Root/Component Services/Computer/My Computer”,  right click Properties of “My Computer”, give full access permission to all users.
  • Solution 2:
    <system.web>
    <identity impersonate=”true” userName=”domain\jack” password=”********” />
    </system.web>

 

Only Office Error: Server connection lost. The document cannot be edited right now

After hosting of Only Office some time users can get the error “Server connection lost. The document cannot be edited right now“.? To resolve this error we can remove 2 values from the web.config key of the Document Server setup.

By default values:
<add key=”editor.settings.coauthoring.url” value=”/coauthoring” />
<add key=”editor.settings.spellchecker.url” value=”/spellchecker” />

Remove values like that:
<add key=”editor.settings.coauthoring.url” value=”” />
<add key=”editor.settings.spellchecker.url” value=”” />

and reset the IIS.

How to access your machine in browser using VNC?

Steps to access windows machine remotely using browser:

  • Download and install TightVNC , while installation provide password for access. all other info must be default.
  • Install Cygwin with Python? to C:\CYGBIN
  • Download Kanaka noVNC and extract it.
  • Copy Kanaka Folder to C:\CYGBIN\Kanaka
  • Now run the Cygwin.bat using “Run as Admisistrator”
  • Go to root using “cd ..”
  • Now go to Kanaka folder using cd.
  • Type “./utils/launch.sh –vnc localhost:5900”
  • After this command CYGWIN will display some configration with below URL.http://localhost:6080/vnc.html?host=localhost&port=6080
  • Type the URL in browser.. You will see a authentication popup. Provide password which you had setup in step #1.
  • Let’s Enjoy.