Dear Readers, In this article, we will discuss Tools for Administering the MySQL Database Please Fill below Google Form (If we missed any Products, Tools, and Utilities that you use in achieving your goals as a Cassandra Administrator.) 👇🏻👇🏻👇🏻👇🏻👇🏻 https://forms.gle/mysql MySQL Flavours Oracle Mysql MariaDB… Read More
Dear Readers. In this article ,we will see MySQL Migration from SUSE (M & S) to RHEL (M & S) through Cascading Slaves. Environment : Mysql version : 5.7.13-enterprise-commercial awsserver1: Suse Master awsserver2: Suse Slave Replication exists between awsserver1 and awsserver2, and is the current… Read More
Hi Readers, In this article,we will see Migrating Table data from MySQL to Oracle Using SQL* LOADER. Step 1 : Connect to Mysql DB and create a table
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 |
[root@ip-172-31-46-32 ~]# mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 16 Server version: 5.7.28-log MySQL Community Server (GPL) Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | oggdb1 | | performance_schema | | sys | +--------------------+ 5 rows in set (0.00 sec) mysql> use oggdb1; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> mysql> CREATE TABLE `C_EMP` ( -> `sid` bigint(20) NOT NULL, -> `C_ID` bigint(20) NOT NULL, -> `text` varchar(255) DEFAULT NULL, -> `A_N_S_M` int(11) NOT NULL DEFAULT '0', -> `D_R_I_K` int(11) NOT NULL DEFAULT '0', -> `crd` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, -> `mdd` timestamp NULL DEFAULT NULL -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1; Query OK, 0 rows affected (0.01 sec) |
Insert data into a table
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 |
mysql> insert into C_EMP values(1,1,'ABCD',10,10,NOW(),NOW()); Query OK, 1 row affected (0.00 sec) mysql> insert into C_EMP values(1,1,'ABCD',10,10,NOW(),NOW()); Query OK, 1 row affected (0.00 sec) mysql> insert into C_EMP values(1,1,'ABCD',10,10,NOW(),NOW()); Query OK, 1 row affected (0.01 sec) mysql> insert into C_EMP values(1,1,'ABCD',10,10,NOW(),NOW()); Query OK, 1 row affected (0.00 sec) mysql> insert into C_EMP values(1,1,'ABCD',10,10,NOW(),NOW()); Query OK, 1 row affected (0.00 sec) mysql> insert into C_EMP values(1,1,'ABCD',10,10,NOW(),NOW()); Query OK, 1 row affected (0.00 sec) mysql> insert into C_EMP values(1,1,'ABCD',10,10,NOW(),NOW()); Query OK, 1 row affected (0.01 sec) mysql> insert into C_EMP values(1,1,'ABCD',10,10,NOW(),NOW()); Query OK, 1 row affected (0.00 sec) mysql> insert into C_EMP values(1,1,'ABCD',10,10,NOW(),NOW()); Query OK, 1 row affected (0.00 sec) mysql> insert into C_EMP values(1,1,'ABCD',10,10,NOW(),NOW()); Query OK, 1 row affected (0.00 sec) |
Crosscheck the data in C_EMP TABLE
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
mysql> select * from C_EMP; +-----+------+------+---------+---------+---------------------+---------------------+ | sid | C_ID | text | A_N_S_M | D_R_I_K | crd | mdd | +-----+------+------+---------+---------+---------------------+---------------------+ | 1 | 1 | ABCD | 10 | 10 | 2020-05-01 13:08:53 | 2020-05-01 13:08:53 | | 1 | 1 | ABCD | 10 | 10 | 2020-05-01 13:08:55 | 2020-05-01 13:08:55 | | 1 | 1 | ABCD | 10 | 10 | 2020-05-01 13:08:56 | 2020-05-01 13:08:56 | | 1 | 1 | ABCD | 10 | 10 | 2020-05-01 13:08:57 | 2020-05-01 13:08:57 | | 1 | 1 | ABCD | 10 | 10 | 2020-05-01 13:08:58 | 2020-05-01 13:08:58 | | 1 | 1 | ABCD | 10 | 10 | 2020-05-01 13:08:59 | 2020-05-01 13:08:59 | | 1 | 1 | ABCD | 10 | 10 | 2020-05-01 13:09:00 | 2020-05-01 13:09:00 | | 1 | 1 | ABCD | 10 | 10 | 2020-05-01 13:09:04 | 2020-05-01 13:09:04 | | 1 | 1 | ABCD | 10 | 10 | 2020-05-01 13:09:05 | 2020-05-01 13:09:05 | | 1 | 1 | ABCD | 10 | 10 | 2020-05-01 13:09:06 | 2020-05-01 13:09:06 | +-----+------+------+---------+---------+---------------------+---------------------+ 10 rows in set (0.00 sec) |
Step 2 : … Read More
Dear Readers, in this article , we will see, Connecting to MySQL without entering the password using mysql_config_editor The mysql_config_editor utility enables you to store authentication credentials in an obfuscated login path file named.mylogin.cnf. The file location is the %APPDATA%\MySQL directory on Windows and the… Read More
MySQL to Oracle Heterogeneous Unidirectional Replication using Slave Server Bin log In this article we will see MySQL to Oracle Heterogeneous Unidirectional Replication using Slave Server Bin log First setup Master -slave replication between two mysql servers. Use below link to setup Master-slave Replication MySQL… Read More
MYSQL TO ORACLE DATABASE LINK CREATION USING HETEROGENEOUS SERVICES A database link is a pointer that defines a one-way communication path from an Oracle Database server to another database server. The remote database can be same oracle or it can be non-oracle database. To access… Read More
Physical Backups in MySQL (Article -20). In this article we can cover Physical backups in MySQL. Physical backups consist of raw copies of the directories and files that store database contents. This type of backup is suitable for large, important databases that need to be… Read More
MAKING RAW MyISAM BACKUP IN MySQL (Article -19). MyISAM was the default storage engine for the MySQL relational database management system versions prior to 5.5 released in December 2009. it is based on the older ISAM code. Filesystem Each MyISAM table is stored on disk in three files (if it is not partitioned).… Read More
MySQL Clients Learning Objectives : List the available clients for administrative tasks and their basic purposes. Invoke mysql clients and common command line options. Invoke and us the MySQL command line client MySQL. Use the mysqladmin for administrative clients APIs (Drivers and Connectors). Overview… Read More
LOG FILES IN MySQL. Before going to look on logfiles we need to know what is the use of my.cnf file. By default my.cnf file will be in /etc/my.cnf location, when ever you try to restart MySQL server look for my.cnf in /etc/ location.
|
1 2 |
[root@ip-172-31-39-223 ec2-user]# ll /etc/my.cnf -rw-r--r--. 1 root root 1066 Sep 10 10:32 /etc/my.cnf |
