• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

MariaDB

How can I get Excel data into MySQL, or vice versa?

by admin

Excel and MySQL can read and write delimited text (CSV) files. To load a text file into MySQL, use the LOAD DATA INFILE statement. To create a text file from MySQL, use the SELECT INTO OUTFILE syntax, or the ability of the client to write or redirect to a file. For example: $ mysql -e […]

Filed Under: MariaDB, mysql

How to use mysqldump without CREATE TABLE statements

by admin

mysqldump is a utility program used for making a logical backup by generating a set of SQL statements that can be executed to reproduce the original database table data and object definition. It dumps one or more database for backup or may transfer to another SQL server. It can also generate data output in different […]

Filed Under: MariaDB, mysql

/var/tmp file system getting full due to Mariadb

by admin

By default MariaDB will create temporary table structure in /var/tmp and this fills up space of root file system(/). We can change default setting by assigning a custom temp directory in ‘[mysqld]‘ section in my.cnf file. MariaDB creates temporary table structure in tmpdir(/var/tmp) directory when there are huge/bulk inserts into table. By default, MariaDB will […]

Filed Under: MariaDB

How to install and configure MariaDB in CentOS / RHEL 7

by admin

MariaDB is the default implementation of MySQL in Red Hat Enterprise Linux 7. MariaDB is a community-developed fork of the MySQL database project, and provides a replacement for MySQL. Installing MariaDB 1. As the MariaDB Database Management System (DBMS) is not installed by default on RHEL/CentOS 7, we will start this recipe by installing the […]

Filed Under: CentOS/RHEL 7, Linux, MariaDB

Primary Sidebar

Recent Posts

  • nixos-rebuild Command Examples in Linux
  • nixos-option: Command Examples in Linux
  • nixos-container : Command Examples in Linux
  • nitrogen Command Examples in Linux

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright