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 […]
MariaDB
How to use mysqldump without CREATE TABLE statements
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 […]
/var/tmp file system getting full due to Mariadb
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 […]
How to install and configure MariaDB in CentOS / RHEL 7
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 […]