Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [linux]

A widely-used open-source operating system that is particularly popular on servers.

Linux (or more correctly GNU/Linux) is an open-source operating system released under the GPL that is especially popular on servers. Originally written by Linus Torvalds in 1991, Linux is the name of the kernel component of the system.

GNU/Linux distributions include the GNU user-space tools produced by the free software foundation, plus a range of other software written by third parties. A number of highly customised variants are also produced, of which the best known is Google's Android.

Many database management systems will run on Linux, although Microsoft's is a notable exception.

Major vendors of bundled GNU/Linux distributions include Redhat (RHEL, Fedora), Canonical (Ubuntu), Novell (SuSE), and a number of non-profit organisations such as Debian.

1013 questions
111
votes
6 answers

Safest way to perform mysqldump on a live system with active reads and writes?

I'm not sure if this is true but I remember reading if you run the following command in linux mysqldump -u username -p database_name > backup_db.sql while reads and writes are being made to a database then the dump may contain errors. Are there…
user784637
  • 1,245
  • 2
  • 9
  • 7
85
votes
4 answers

PostgreSQL: Remove password requirement for user postgres

I understand that, upon installation, PostgreSQL has no password for its db root user (postgres): postgres=# select usename, passwd is null from pg_shadow; usename | ?column? ----------+---------- postgres | t (1 row) ... and one is advised to…
Marcus Junius Brutus
  • 3,409
  • 7
  • 30
  • 44
51
votes
3 answers

How to make MySQL table name case insensitive in Ubuntu?

I am using Ubuntu 13.10 and MySQL 5.6 and I know database name and table name are case sensitive in Ubuntu (and some other *nix environments) by default. Now, I want to make MySQL work as case insensitive in Ubuntu. Is it possible? If yes, how can I…
java baba
33
votes
5 answers

How to properly kill MySQL?

I have CentOS 64bit with CPanel installed and I use: service mysql stop It just keeps ticking periods and never seems like it stops. In the logs it just posts a lot of: 130303 17:42:38 [Warning] /usr/sbin/mysqld: Forcing close of thread In the…
Tiffany Walker
32
votes
7 answers

Does innodb_file_per_table affect mysql performance?

There are many articles exaggerating (IMHO) the need for innodb_file_per_table. I understand that with innodb_file_per_table there should be better control over individual tables, like being able to back up each table separately. However, the claims…
Googlebot
  • 4,551
  • 26
  • 70
  • 96
31
votes
10 answers

How do I access Postgres when I get an error about "/var/run/postgresql/.s.PGSQL.5432"?

I am running Ubuntu 16. I have installed Postgresql. Postgresql used to work, but then I rebooted. nmap commands show port 5432 is open. Postgres seems to be working correctly: service postgresql status postgresql.service - PostgreSQL RDBMS …
Victor
  • 413
  • 1
  • 4
  • 5
28
votes
3 answers

Mongo Create a user as admin for any database raise an error

I am trying to create a simple user with the rights permission to access to any database and can do any actions. When I trying to execute the createUser command I got this error: db.createUser({ user: "mongoadmin" , pwd: "mongoadmin", roles:…
Robert
  • 705
  • 3
  • 12
  • 20
25
votes
3 answers

How to reinitialise /var/lib/mysql files?

Due to a mishap I deleted the entire /var/lib/mysql directory. Since the database did not contain anything important, I do not want to go through the hassle of restoring it from an old backup, but instead create the directory structure from scratch.…
Konrad Gajewski
  • 353
  • 1
  • 4
  • 10
24
votes
1 answer

What limits the number of connections?

As per https://devcenter.heroku.com/articles/heroku-postgres-legacy-plans the connection limit is 500 As per https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server "Generally, PostgreSQL on good hardware can support a few hundred…
Neil McGuigan
  • 8,653
  • 5
  • 42
  • 57
24
votes
4 answers

Test MySQL credentials from Linux command line?

How do you test MySQL credentials from the command line on a Linux server?
Jake Wilson
  • 2,487
  • 8
  • 22
  • 23
21
votes
4 answers

Can I change the SID of an Oracle database?

The Server is Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Is there an easy & quick way to change the SIDs of the test databases on the server? Dropping & recreating of the database is an option for me. But I'm looking for…
bernd_k
  • 12,369
  • 24
  • 79
  • 111
21
votes
3 answers

How to connect to SQL Server using sqlcmd on Linux?

I have set up the Microsoft ODBC Driver 13 for SQL Server on an Ubuntu 16.04 machine. I am now trying to test a database connection, that includes both the server name and an instance name. The following both work fine from a Windows…
geographika
  • 533
  • 2
  • 4
  • 15
20
votes
2 answers

best way to run sql server management studio on linux

I'm using ubuntu 18.04.2 on my desktop and running sql server 2017 from docker. I want to use sql server management studio to manage the server. SO far now, I have a windows 7 enterprise with with ssms 17.9.1 and it works ok It's really annoying…
opensas
  • 387
  • 1
  • 3
  • 10
19
votes
5 answers

Cannot open table mysql/innodb_index_stats

After a fresh install of XAMPP and import from my linux live db that is working to the windows Dev-stage, I started encountering problems with INSERT. Everything else seems to work well. The errors I get in the mysql_error.log are: 2013-08-15…
Mike
  • 315
  • 1
  • 2
  • 7
19
votes
4 answers

Taking MySQL dump from another machine

I have a MySQL db on Machine A and I want to access the mysqldump from machine B. Both machines are running on Linux and I also have the credentials of both, but I can't access the mysqldump. What can I try?
Selvakumar P
  • 337
  • 2
  • 4
  • 9
1
2 3
…
67 68