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…
Postgresql is open source object-relational database system and it is also widely use likewise mysql database system. If you are familiar with mysql you must be aware that in single line you can pass the password of mysql user for eg. mysql -u root -p password. But in postgresql it is not like that. Solution:…
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…
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…
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…
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…
Today we will learn about 4 basic commands in mysql server which are related to manage the database.These 4 commands are important for any Mysql Database administrator.The post is mainly written for beginners of MySQL database administration. All the data are saved in some database. These Databases have some name hence the basic thing is,we…
send email after mysql backup through bash script in simple way In Facebook group one of the user asked this question “how to send email after mysql backup through bash script”. If you know bash scripting a bit it is just a one liner. It can be write in more advanced form but here I…
How to change mysql data directory in Ubuntu In this tutorial we will learn how to change the default path of mysql data directory. The mysql server bydefault keep the data in /var/lib/mysql . If you want to change its path follow the given below steps. Lets have an overview for changing mysql data directory…
In this post we will learn about,how to install mysql server in RedHat and CentOS. MySQL is a relational database management system (RDBMS), and ships with no GUI tools to administer MySQL databases or manage data contained within the databases.Read More About MySQL Server Default Port Number of MySQL : 3306 (TCP) Install the MySQL…