• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
sharadchhetri.com

sharadchhetri.com

Linux,Cloud Computing And DevOps

  • Home
  • Linux
  • CloudComputing
    • Introduction Cloud Computing
    • Amazon AWS
  • Free E-Books
  • About Me

mysql

How to rename table in mysql using command line

November 12, 2013 by Sharad Chhetri Leave a Comment

In this post we will know how to rename table in mysql using command line. It is basic and important command for MySQL database administration. We are doing this practical in MySQL server version 5.5.29. Syntax: Replace the table_name and NEW_TABLE_NAME as per your requirement. ALTER TABLE table_name RENAME NEW_TABLE_NAME Example: See the below given […]

Filed Under: mysql Tagged With: mysql

How to copy existing table in mysql

November 12, 2013 by Sharad Chhetri Leave a Comment

In this post we will learn about how to copy the existing table in mysql. The newly copied table does not have data means it will be blank but it has similar rows information from its parent table. After copying the table you have to insert the data by using INSERT command. Follow the given […]

Filed Under: mysql Tagged With: mysql

Install MySQL workbench in Ubuntu

August 14, 2013 by Sharad Chhetri 1 Comment

MySQL Workbench is a integrated tool for MySQL. The MySQL workbench gives a graphical interface to user through which user can easily manage many MySQL Administration task.The tool can be install in Windows,MacOSX and Linux. As well as its source code is also available. The MySQL Workbench is easy to install in Windows,MacOSX and Linux […]

Filed Under: Linux, mysql Tagged With: mysql

See mysql command output vertically

August 10, 2013 by Sharad Chhetri Leave a Comment

When you work on mysql server and hit some command in mysql prompt,you get the output in horizontal way. For eg. I hit the command, select emailid from linuxtable where user = ‘sharad’; and this table has lots of fields . In that case the output looks weird. Rather than seeing the output Horizontally in […]

Filed Under: Linux, mysql Tagged With: mysql

How to set default storage engine to MyISAM to InnoDB vice versa

August 10, 2013 by Sharad Chhetri Leave a Comment

In this tutorial we will learn about how to set default storage engine to MyISAM to InnoDB or vice versa. Since the change in MySQL default storage engine as InnoDB there are many Database Servers which are still running in MyISAM. The change in Default storage engine come after MySQL 5.0 and later versions. In […]

Filed Under: Linux, mysql Tagged With: mysql

How to check default storage engine in MySQL server

August 9, 2013 by Sharad Chhetri Leave a Comment

MySQL server comes with many engines,earlier MyISAM was default storage engine but from MySQL version 5.5 and later InnoDB now become a default storage engine. Yet,you should know what is the default storage engine running in mysql server. It might be possible any database admin has changed to MyISAM or INNODB as default storage engine […]

Filed Under: Linux, mysql Tagged With: mysql

  • « Go to Previous Page
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to page 4
  • Go to Next Page »

Primary Sidebar

Follow Us

  • Facebook
  • Twitter
  • GitHub
  • YouTube

Recent Posts

  • How to install Java (OpenJDK) on Ubuntu Linux
  • How to install Groovy on Ubuntu 20.04 LTS
  • How to Disable selinux in Red Hat or CentOS
  • How to remove date from WordPress Post URL
  • How to install Mariadb 10.4 server on CentOS 8 / RHEL 8

Top Posts & Pages

  • How to delete mail queue in Postfix
  • How to fix read only USB pen drive in Ubuntu
  • How to set hostname and FQDN on CentOS 7 and RHEL 7
  • How to start / stop / restart / reload iptables on CentOS 7 / RHEL 7
  • How to install MySQL Server 5.6 on CentOS 7 / RHEL 7
  • 4 different commands to check the load average in linux
  • How to find absolute path of command on Linux / Unix : which command
  • How to create Jenkins user by command line and GUI
  • How to setup Jenkins Credentials for Git repo access
  • make command not found in linux CentOS Red Hat ubuntu Debian

DevOps Posts

  • vagrant cloud flow

    Install Vagrant on Ubuntu and create first VM

  • git jenkins credential github

    How to setup Jenkins Credentials for Git repo access

  • terraform

    how to install terraform in Linux : CentOS-Ubuntu

  • docker image

    How to create Ubuntu docker base image

  • Install Ansible on Ubuntu / CentOS / RHEL

Footer

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Sharad Chhetri is an experienced Linux - Cloud Engineer & freelancer. Working on Open Source Technology since RHEL 4.0 (Red Hat Enterprise Linux). He loves sharing the knowledge which earned from real scenarios. Don't be surprised if you find him in technology seminars and meetup groups. You can contact him on email for freelance projects at admin@sharadchhetri.com. Read More…

Tags

Amazon AWS apache automation awk bash script CentOS centos 7 debian devops docker freebsd ftp ghost git grep hostname jenkins kvm linux linux command linux commands MariaDB Server mysql Nagios nginx Octopress owncloud Owncloud 6 php postfix postgres python Red Hat rpm sed selinux ssh swap ubuntu user management vagrant varnish virtualbox vsftp wordpress

Recent Comments

  • Ali on How to delete mail queue in Postfix
  • Mehar on How to install Java (OpenJDK) on Ubuntu Linux
  • Ramone Burrell on How to fix read only USB pen drive in Ubuntu
  • Pera on How to fix read only USB pen drive in Ubuntu
  • Ubuntu on How to fix read only USB pen drive in Ubuntu
  • Nitin Sharma on Install and configure rsyslog Centralized logging server in CentOS 6.5
  • Sharad Chhetri on Install and configure rsyslog Centralized logging server in CentOS 6.5
  • nitin on Install and configure rsyslog Centralized logging server in CentOS 6.5

Copyright © 2009 - 2021 · All Rights Reserved sharadchhetri.com · · Privacy Policy ·
· sitemap.xml · ·The content is copyrighted to sharadchhetri.com and may not be reproduced on other websites without our permission. ·

Copyright © 2021 · Genesis Sample on Genesis Framework · WordPress · Log in