MariaDB MariaDB is a community-developed fork of the MySQL relational database management system, the impetus being the community maintenance of its free status under the GNU GPL. Being a fork of a leading open source software system, it is notable…
To view procedure code in mysql, you must be the owner of the routine or have SELECT access to the “mysql.proc” table and you can use any of the following statements. SHOW PROCEDURE CODE proc_name; SHOW CREATE PROCEDURE proc_name; SELECT…
[ root @ dbversity : /tmp ] rpm -ivh unixODBC-2.2.14-14.el6.x86_64.rpm warning: unixODBC-2.2.14-14.el6.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY Preparing… ########################################### [100%] 1:unixODBC ########################################### [100%] [ root @ dbversity : /tmp ] [ root @ dbversity : /tmp ]…
While testing the connectivity with MySQL JDBC Connector for MemSQL, I’m receiving below errors. My code works fine with MySQL Database but fails with MemSQL Database. Assuming this might be the issue because MemSQL doesn’t have init_connect global variable. Please…
Q) When using mongoimport to import a CSV, the field “00234” will get imported as the number 234, is there any way to specify field type of each field or is there any other solution for the same so that…
[ root @ dbversity : /var/lib/mysql ] tar -zxvf mysql-connector-java-5.1.36.tar.gz mysql-connector-java-5.1.36/ mysql-connector-java-5.1.36/docs/ –blah blah —– mysql-connector-java-5.1.36/src/testsuite/ssl-test-certs/server-cert.pem mysql-connector-java-5.1.36/src/testsuite/ssl-test-certs/server-key.pem mysql-connector-java-5.1.36/src/testsuite/ssl-test-certs/server-req.pem mysql-connector-java-5.1.36/src/testsuite/ssl-test-certs/test-cert-store [ root @ dbversity : /var/lib/mysql ] [ root @ dbversity : /var/lib/mysql ] [ root @ dbversity : /var/lib/mysql ]…
Please check your OS version and bit type and download the required ODBC Driver for MySQL from http://dev.mysql.com/downloads/connector/odbc/ [ root @ myhostname : ~ ] cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.6 (Santiago) [ root @…
You can download MariaDB Galera Linux package from the link https://downloads.mariadb.org/mariadb-galera/10.0.20/#os_group=linux_generic [ root @ maria-galera : /mariadb ] ll -lhtr total 142M -rw-r–r– 1 root root 142M Aug 11 08:18 mariadb-galera-10.0.20-linux-x86_64.tar.gz [ root @ maria-galera : /mariadb ] […
You can download mariadb package from https://downloads.mariadb.org/ and copy to your linux box [ root @ vm-16af-8253 : /mariadb ] ll -lhtr total 296M -rw-r–r– 1 sm70768 mongod 296M Aug 11 01:38 mariadb-10.0.21-linux-x86_64.tar.gz [ root @ myhostname : /mariadb ]…
We can restrict table level replication with below parameters in MySQL Solutions for column level are … 1) Custom script • Export data with required fields to a csv from Master server ( with SELECT INTO OUTFILE syntax) • Create…