List all databases using Innodb storage engine

While working on a server migration,  I need  to found all databases running on Innodb engine to migrate  them over to  a new server.

So, thought of  sharing  the command to get the list of all innodb databases, if in case anyone requires it. 🙂

 

Below is the command ::

 

[email protected][#] mysql -N mysql -e "SELECT table_schema, table_name FROM INFORMATION_SCHEMA.TABLES WHERE engine = 'innodb';" | awk '{print $1}' | sort | uniq

That’s all, easy isn’t it.

 

 

PureFTPd not working with CallUploadScript

Many times it so happens that the pure-ftpd service doesn’t work with CallUploadScript set to yes in the /etc/pure-ftpd.conf file.

That is because the pure-uploadscript service  is not getting started while restarting the pure-ftpd service and hence you will have to manually restart pure-uploadscript for the FTP to work.

You can  apply the below simple fix for it ::

 

Firstly restart the pure-ftpd service

/etc/init.d/pure-ftpd restart

then

 /usr/sbin/pure-uploadscript -B -r /etc/pure-ftpd.conf

Now telnet IP 21 works fine and so does pure-ftpd service.

 That’s all.

How to remove ^M characters from a file

Many time it happens that when you open a file  in vi editor  you see  a ^M character  at some places in  a file and a  ^M  character is nothing but a carriage return character in Linux.

You normally found those characters when you transfer a file from  a windows machine to a Linux box.

The   ^M character [Carriage Return] can easily be removed by following  one of the below method  ::
Continue reading How to remove ^M characters from a file