Search In
Searching files in Ubuntu : Ubuntu is free open source operating system. Ubuntu has both the Graphical User Inerface (GUI) and the command line interface (CLI). In this article we are going to tell you how you can search for files and directories on
Sometimes we need to add a column with comment. We can do this easily by using COMMENT attribute in alter command.
Ex- Find the below alter command which will add "address" column to "user" table after "country" column.
ALTER TABLE `user` ADD COLUM
Sometimes we need to add a column after a particular column. We can do this easily by using ALTER command with AFTER attribute.
Example: in the below command I'm adding "latitude" column after "address" column where "address" column already exists i
Sometimes we need to change default Character set of Schema. We can do this easily by using ALTER command.
Command:
ALTER SCHEMA database-name DEFAULT CHARACTER SET utf8 ;
Example:
ALTER SCHEMA `jeeyoh` DEFAULT CHARACTER SET utf8 ;
by running
Yo can login to MySQL using following command:
mysql -h hostname -u <UserName> -p <password>
Suppose you are login with hostname as 'localhost ', Username as 'root' and password as 'root'. Then the command will be as follows:
mysql -h
How to add Cron Jobs in Ubuntu?
I was facing issue for adding cron jobs in dedicated hosting (in Ubuntu). In order to add cron jobs in Ubuntu go to the terminal and type:
$ sudo crontab -e
this will open your personal crontab (cron configuration
Use below code line in .py file if you want to debug file in odoo
import ipdb; ipdb.set_trace();
And then restart server use this command in terminal and then restart your openerp- server with the —debug option.
# openerp-server –debug
If user want to change role of password in pgadmin
Run these commands in Terminal
1- sudo -u postgres psql
2- sudo -u postgres psql template1
3- ALTER ROLE postgres WITH PASSWORD 'openpgpwd';
One of the frequent task that we do with the increasing data on our linux boxes is to compress the files and folders and to do so there is a command tar that we can use to achieve the same.
Below are the examples of how to compress files in a folde
In Ubuntu system, first check for the PHP. For checking open the terminal, using command
**Ctrl +Alt +T**
and type whereis php
If PHP present in system, above command display the path of PHP
Make a PHP file from where you can access it:
&
