Mysql: How to clone a table removing duplicate entries

If you have a table in MySql having duplicate entries an you want to remove these duplicate entries you can do that by cloning the table. In MySQL this can be obtained by the following one liner:

CREATE TABLE new table (  `ID` int(11) NOT NULL AUTO_INCREMENT, `col1` int(11) NOT NULL, `col2` varchar(1000) NOT NULL,`col3` varchar(255) NOT NULL,`col4` varchar(30000) NOT NULL, PRIMARY KEY (`ID`)) SELECT DISTINCT * FROM oldtable;

The column definitions are just for demonstration purpose and have to be identical with the original table. By the SELECT DISTINCT query you obtain a copy of the table without duplicate entries.

What to do if you get a bash: /usr/bin/rm: Argument list too long error.

If you have directories which you contain millions of files you might get in trouble when you want to apply an operation on a bunch of files. For example rm *.jpg will not work in that case due to memory limits.

An easy way is you to use find for the job you want to do:

If you want to move all files in a directory which have the extension jpg.gif to gif only  you can use the following command:

> find -name “*.gif.jpg”  -exec mv ‘{}’ jpg \;

Another useful application is to easily remove all files with the extension .jpg

This can be done with the following command:

> find -name “*.json”  -exec rm ‘{}’ \;

In principle you can apply find to any other job you want to perform.

Howto Dump the Structure of a Msql Table

If you need to transfer a MySQL table to another Server it may be very useful to dump a create statement and then simply execute it on the new server. Like that you can easily clone you MySQL table. One can dump the structure with a simple command.

> show create table _tabellenname_

Thats it!

Howto add a Login with Facbook/Google Plus Botton to a Website

Many sites offer Login with Facebook or Google+ features in order to make it easier for new users to connect to members-only features: To get this for your project too you just have to follow some simple steps

Howto get the Facebook Login:

Go to and create a new application by clicking “Create New App”. Fill out any required fields such as the application name and description. Put your website domain in the Site Url field. Once you have registered, copy and past the created application credentials (App ID and Secret) into the HybridAuth config file.

Howto get the Google+ Login:

Go to and create a new project. Go to API Access under API Project. After that click on Create an OAuth 2.0 client ID to create a new application. A pop-up named “Create Client ID” will appear, fill out any required fields such as the application name and description. Click on Next. On the popup set Application type to Web application and switch to advanced settings by clicking on (more options). Provide this URL as the Callback URL for your application: Once you have registered, copy and past the created application credentials (Client ID and Secret) into the HybridAuth config file.

How to read login from a Remote Server

In case you have a remote server which booted in rescue mode and you need to obtain the login history of the original server you just can use the last command after mounting the disc which is carrying the OS from the original server.

last -f changes the default location of the last log to another directory

last -f /mnt/sda1_server/var/log/wtmp

Mysql: Allow Access from an IP Address

In order to enable access from a remote client to a mysql server just perform the following steps:

$ mysql -u root -p
Enter password:

mysql> use mysql

mysql> GRANT ALL ON *.* to root@’′ IDENTIFIED BY ‘root-pw';


use ” ‘ ” in all four cases above.

Afterwards the remote client should be allowed to communicate the MySQL server you updated the privileges. This receipt usually solves the ERROR:

“Host is not allowed to connect to this MySQL server”

Tipps and Tricks creating a SSL Certificate

In order to create a SSL Certificate one needs a CSR request for the server first. Under Linux it is very easy to create such an request:

openssl req -new -newkey rsa:2048 -nodes -keyout domain.key -out domain.csr

will do the job. Afterwards you have a csr file and a private key in the directory where you executed the command.

If your private key is protected by a password you can remove the password by:

> openssl rsa -in old.key -out new.key

During this process it is necessary to give the password once. The new key will not be protected by a password any more.

Scientillion, the Best Way to Search for Physics and Science Articles

The Internet is a beautiful place. A simple search in Google or any other search engine will yield thousands of results within seconds. Even though major search engines have powerful features, they are designed for general searches. Scientists and researchers who are looking for physics and science articles are often left on their own to find what they are searching for.

There are lots of academic search engines online, but most of them focus on a single field of expertise. There are also search engines that provide citations from multiple fields. But the downside is that some search engines are subscription based. There are only a couple of search engines that are available for free. Researchers, who can’t find what they are looking for with the use of free search engines, will use computers in a college or university that are subscribed to academic search engines of their discipline. School libraries often have a list of the academic search engines they are subscribed to in their websites.

The good news is that there is a search engine that has been designed for the needs of the scientists. And the best thing about it is that it is free to use. Scientillion makes it possible for users to make searches based on formulas or any other scientific term. This is useful for researchers who are required to do a lot of physics and science searches online. The search engine can look through thousands of e-prints of scientific papers from all fields of science that include astronomy, computer science, biology mathematics, and physics, just to name a few. In order to have a successful science project, the researcher needs to read a lot of scientific literature that are relevant to their study. And in order to find the scientific articles, they can use Scientillion.

The search engine maintains an online formula database to make it easier for users who are looking for specific formulas. While Google and other search engines allow users to search for formulas, they are not able to render the mathematical syntax properly. Scientillion utilises a technology that allows the rendering of both code and text in the search results. The scientific search engine also provides interfaces to top scientific publications, such as Scientillion also allows real time search of the text within the scientific publications.
Scientillion is a great tool for scientists and researchers. It saves them a lot of time on their research. Even in its Alpha Version, Scientillion is a powerful tool to learn about the publications that are pertinent for your study. It strives to be the go-to source for scientific queries on the Internet. It provides a great service to students, researchers, and the scientific community in general.

The site is available under the following address: Scientillion – The ArXiv and Physics Search Engine<

BOINC: How to Turn your Laptop into a Research Lab

The Berkeley Open Infrastructure for Network Computing, known for short as the BOINC project, is an open source system that focuses on volunteer and grid computing. It was originally created to support the SETI@home project, but has become a useful platform for many other projects as well.

How it works is that people from around the world will volunteer their computers to provide processing power to these projects in order to help them continue running. These projects are quite expansive, and any donation of a computer’s processor will help the project to function better. Many of these projects are based in the sciences, such as mathematics, climatology, astrophysics and environmental science. They require the collection of a lot of data and need a lot of processing power in order to make sense of this collected data.

It was developed by a team based at the Space Sciences Laboratory at the University of Berkeley when they started the SETI@home project. Since its creation, the BOINC project has amassed over one million active computers all over the world, with over 400, 00 active participants. This is because the BOINC projects are all based on open source software, so just about anyone can contribute the processing power of their computer just by downloading a program for the project of their choice. This allows users with Windows, Mac OS, Android, Linux and FreeBSD operating systems to participate.

What makes the BOINC projects even more enticing is that volunteers can earn credits for the number of work units they’ve contributed to the project of their choice. People can work separately as individuals, or they can pool together as groups in order to earn more credits. The ranking of these credits is maintained, providing a means of friendly competition between users all over the world to try and beat each other in credit numbers. Some users have even invested more of their own money to purchase more processors, just to increase their credits.

One of the pioneering BOINC projects is SETI@home, which stands for Search for Extraterrestrial Intelligence. This is a scientific experiment that collects and analyses telescope data in order to find narrow-bandwidth radio signals from space. Since they don’t naturally occur in space, any detection of them would provide evidence of alien technology.

Another project is Asteroids@home, which seeks to discover the presence of as many asteroids in space as is possible for the computer to process, as well as analysing them, since very little is known about them. A third project is, where climate models are run on the computers of volunteers in order to answer the questions on how climate change affects the current state of the world, as well as in the future.

Make a Difference and Switch to Green Webhosting

The Internet itself is a very large place, and it can be quite difficult to determine just how much power is being used to keep it going. With the state of green house gas emissions as they are, it’s about time someone started taking the initiative combining the Internet with greener sources of energy.

According to The New York Times, there are at least 30 billion watts of electricity that are used, just to power the Internet. That’s a lot of fossil fuels that are being used. One would think that with the forward thinking of those who use the Internet, there would be more sources of green energy available. Sadly, that doesn’t seem to be the case. In fact, the energy consumption is actually increasing, with more and more people gaining access to the Internet from their homes as well as taking it with them on the go on their smartphones and mobile devices. This is a steadily growing problem that needs to be taken care of.

The earth photographed from the cassini space craft. Such a fragile jewel in the big void of the universe. Take care of it. (Foto: NASA)
Climate change is a serious concern that has been slowly altering the normal temperatures of the planet throughout the year. The greenhouse effect is making summers a lot hotter and winters a lot colder, which further increases the use of fossil fuels. Consumers are likely to turn the settings of their HVAC systems up even higher, which uses even more energy. Coupled with the increased use of the Internet during these times when people want to stay inside, it ends up being a circular problem with no end in sight.

That’s why we need to start reducing the energy consumption of the Internet by seeking alternative sources. There are several web hosting service providers who have started to use sources of green energy for just this reason. They are capable of still providing the same quality service while still saving the environment in the process. If you want to see changes being made, consider switching to and supporting green hosting in any way you can. It could soon become the standard by which we use the Internet and save the environment even further.

Web hosting services offering green hosting:

Some of the web hosting services out there that use green energy include Ecological Hosting, Green Geeks, and Hetzner. Ecological Hosting has been in the business of web hosting since 1999, and have made it their mission to provide services that interfere with the environment as little as possible. They rely on solar energy and other renewable resources in the services that they provide to the world. Green Geeks has been in the business for over forty years and has always made it their goal to have a positive energy footprint on the environment, through the use of wind power. Hetzner Online has provided many web hosting services through their choice of green energy, allowing more users to feel better about not harming the environment further.