Question : I need to move 20 Gb MySQL database from on Debian server to another. The problem is that […]
Tag: linux
Deleting hundreds milion of rows in single MySQL query
Question : we have a project with a huge MySQL table (MySQL version 5.7.35-0 on Ubuntu 18.04.1 using InnoDB) table. […]
mongodb not working after install
Question : I followed these steps at http://www.liquidweb.com/kb/how-to-install-mongodb-on-ubuntu-14-04/ as I usually do, since everyone on ubuntu knows the mongo docs […]
Unable to create replica set for MongoDB in Linux
Question : When I run the following command: rs.initiate(), I get the following error: “info2” : “no configuration explicitly specified […]
I’m trying to run an oracle database in virtual box under oracle linux
Question : I’m trying to run a oracle DB in VirtualBox and access it from my host mac OSX , […]
Import big CSV on Oracle
Question : I have big CSV files and placed it on Linux (Amazon AMI). I have installed instant client on […]
Postgres: Why is my delete query using up all available disk space?
Question : I have a postgres table set up like so: Table “public.facts” Column | Type | Collation | Nullable […]
How to lock a MSSQL (2017 Linux) account after N unsuccessful login attempts
Question : I have to configure account lock after N unsuccessful login attempts on MSSQL 2017 Linux. That is standalone […]
Is it possible to change the SQL Server errorlog file number on Linux?
Question : Everything is in the title. We can change the number of errorlog files using the registry on Windows, […]
SQL Server Linux Disable Remote Connections
Question : What is the best way to disable remote connections on a SQL Server Install on Linux (CentOS 7)? […]