A widely-used open-source operating that is particularly popular on servers.
2
votes
1answer
34 views
How can I automate copying DB2 table data between remote Servers?
I have two IBM DB2 servers at separate remote locations.
I need to copy data from several tables on one database on the first server to another database in the second server.
Previously I've used ...
3
votes
0answers
41 views
What happen when Postgresql tablespace is null?
I'm facing a DWH on postgresql with no DBA (I'm not one) so I turn to you with hope to figure this issue/s.
Long story short, when I check the disk usage per tablespace, I get different distribution ...
1
vote
1answer
23 views
Moving postgresql data directory
I moved postgresql's data directory by following the following steps:
Stop postgres
cp -a source_data_directory destination_data_directory
export PGDATA=destination_data_directory
Changing data ...
1
vote
0answers
26 views
How to Change location of postgres cluster and database within the same machine? [duplicate]
I have my present database cluster of postgres at /mnt/my_hard_drive which I want to change to /home/myfolder. I also want to move all my databases present in the present cluster to /home/myfolder. Is ...
0
votes
0answers
24 views
change data directory postgres with database cluster [duplicate]
I have my present database cluster of postgres at /mnt/my_hard_drive which I want to change to /home/myfolder. I also want to move all my databases present in the present cluster to /home/myfolder. Is ...
0
votes
1answer
75 views
Converting dbo file from windows to linux
I have a .dbo file which is created from windows. This file is succesfully reloaded into the mysql database in windows. I need to reload the dbo file into the mysql/mariadb database in linux. How I ...
5
votes
6answers
3k views
What tools are there for data masking? (MySQL, Linux)
I'm looking for (ideally free, open-source) data masking tools. Do any such exist?
Note: this related question deals with tools for generating test data, but in this question I'm more interested in ...
0
votes
0answers
38 views
How much RAM for a large database on a dedicated MySQL InnoDB server?
Hereunder my hardware config:
CPU: 1x Intel Xeon X3470 Quad core @ 2.93GHz
RAM: 4x 8GB DDR3
Disks: 2 x SATA 320GB for the system & 4 x SAS 300GB for the DB
I've upgraded from 12Gb to 32Gb and ...
0
votes
1answer
81 views
mysqldump: Got error: 1017: Can't find file: 'drupal_install_test' (errno: 2) when using LOCK TABLES
I'm trying to backup a drupal site database but I'm having some issues. When I ran the following command:
mysqldump -uroot -p drupaSite > drupaSite.sql
I get the following error:
mysqldump: Got ...
0
votes
1answer
67 views
createdb: could not connect to database postgres: FATAL: could not write init file
RedHat Enterprise Server 3.0 32 Bits
psql (PostgreSQL) 8.2.3
user: postgres
server is running:
/soft/postgres/8.2.3/bin/pg_ctl start
pg_ctl: another server may be running; trying to start server ...
1
vote
0answers
31 views
mysqld dead but subsys locked
I'm executing the following command in a shell script and I'm executing this on an RHEL-6 server and MySQL version 5.1.47-
mysqld_safe --defaults-extra-file=/custom/path/of/my.cnf
The path of ...
1
vote
1answer
145 views
Limit memory used for mongoDb
Is there any way to limit using RAM for mongodb on Debian? I'm looking for a solution fo about 8 hours, but have no results.
1
vote
2answers
57 views
How to avoid lagging when enabling log-slave-updates?
Master:
48GB RAM
16-core
my.cnf: https://clbin.com/hlkUo
Slave:
64GB RAM
24-core
my.cnf: https://clbin.com/viLm0
Both are running 5.5.28.
For the incremental backup purpose, I need to enable ...
0
votes
2answers
48 views
Can I find out what version of MySQL from the data files?
I have a very odd situation going on here. I had a linux box running ubuntu 8.10 and MySQL server with a Wordpress installation on it hosting an internal blog for our company. The machine that this ...
0
votes
1answer
61 views
Database creation on Linux with dbca: “command not found”
I have installed an Oracle on my machine. When I open a session with VNCServer and type dbca, either as root or as oracle, I get these errors:
-bash : -dbca : Command Not found
Xlib: connection to ...
0
votes
1answer
142 views
Proper procedure for migrating a MySQL database to another Debian machine?
I have one server running an older Debian version with MySQL 5.x and a newer Debian server, also running MySQL.
I've created a backup of all databases on the first server like so:
mysqldump -uuser ...
0
votes
1answer
133 views
consequences of using “innodb_flush_method = O_DIRECT” without having a battery backed write cache? or on a KVM guest?
Mysql 5.5.29 Innodb- 128GB Ram - 32 cores - Raid 10 SSD.
Our server which is a dedicated KVM guest on a 'baremetal' is hosting our heavy read-write DB server.
Everything is file-per-table. ...
5
votes
5answers
3k views
MySQL said “InnoDB: Initializing buffer pool, size = 128.0M”, does it mean it is using 128MB RAM?
I am just using a very few InnoDB tables (e.g. less than 1MB), but during MySQL startup, it said
InnoDB: Initializing buffer pool, size = 128.0M
Does it mean even I am using in such a small size, ...
0
votes
1answer
276 views
MySQL slave stuck in “Reading event from the relay log”?
5.5.28-log MySQL Community Server (GPL) by Remi
binlog-format=MIXED
My problem is similar to this question.
*************************** 2. row ***************************
Id: 973415
User: ...
4
votes
5answers
340 views
Improving SQL Server performance on VMware under Linux
I have a Linux server in a small company (3 users) acting as a domain server and running two VMs under VMware: one has SQL Server 2000 on it and one has SQL Server 2005, in each case running on ...
0
votes
2answers
44 views
which process has created a load spike on my server last week?
O.S.:Linux
MYSQL server
we got a load spike last week.
how can I find the process that has created the load spike on my server last week.
1
vote
1answer
111 views
MySQL my.cnf won't take any effect
Update 7
As DerekDowney suggested, I tried to use
[mysqld]
init_connect=SET NAMES 'utf8'
But I could not get the desired result. My client side java programme still says both session and global ...
2
votes
2answers
2k views
MySQL Replication Troubleshooting
Here's what I did. On the master, change /etc/my.cnf:
[mysqld]
server-id=1
log-bin=mysql-bin
innodb_flush_log_at_trx_commit=1
sync_binlog=1
Save and restart mysql, then log in.
>GRANT ...
1
vote
1answer
47 views
clusterdb stopped working for PostgreSQL database in Ubuntu 12.04 server
After a fresh PostgreSQL install (version 9.2) on my Ubuntu server 12.04, clusterdb utility stopped working. I used the same config files as I used with version 9.1.
Below is the actual command:
...
1
vote
1answer
30 views
How to implement security model?
I have installed Oracle 11g on fedora 14. I connected with SQL*Plus as 'SYS' and
created some tables, then created a user named "account" and a role, "payroll"
with the following privileges. I ...
6
votes
4answers
3k views
Why using innodb_file_per_table?
There are many articles exaggerating (IMHO of course) the need for innodb_file_per_table. I understand that with innodb_file_per_table, there should be a better control over the individual tables; ...
1
vote
2answers
149 views
Mysql synchronization databases on one machine
I have MySQL databases. Database A and Database B. Running on Mysql 5.5 and Ubuntu 12.04.
Into Database A i am doing INSERTs, UPDATEs every minute (cron) (The whole database has over 15 millions ...
1
vote
5answers
264 views
How to properly kill MySQL?
I have CentOS 64bit with CPanel installed and I use
service mysql stop
However, it keeps doing ..... for minutes and it never stops. It used to be instant. Any idea why it does that and how to fix? ...
15
votes
3answers
15k views
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 ...
0
votes
0answers
54 views
How to properly kill MySQL? [duplicate]
I have CentOS 64bit with CPanel installed and I use
service mysql stop
However, it keeps doing ..... for minutes and it never stops. It used to be instant. Any idea why it does that and how to fix? ...
0
votes
1answer
165 views
How to copy MySQL Database from Linux to Windows?
I would like to copy a MySQL database form Linux to Windows, from a little research I found this url http://www.cyberciti.biz/tips/howto-copy-mysql-database-remote-server.html where the author says we ...
1
vote
0answers
37 views
How open oracle DB Linux (After installation)
I have just installed Oracle 11gR2 on my Linux Mint Distro (xfce). All worked fine, and I was able to acces to
https://localhost:1158/em [Erreur 102 (net::ERR_CONNECTION_REFUSED) ]
I rebooted my ...
2
votes
1answer
258 views
How to write a shell script to check the mysql database backup status.
I have mysql production databases running in main server(Linux) and from this server every night the backup is taken into local server.
Now i want to find a shell script to check if all the databases ...
1
vote
1answer
82 views
Is it okay to have different lower_case_table_names value on master and slave?
I have a OSX MySQL master with lower_case_table_names set to 2. I have just setup a Linux MySQL slave with lower_case_table_names=1.
I haven't started replication on the slave, but everything looks ...
0
votes
0answers
66 views
Migrating database from OSX to Linux
I followed the setup in below link, to setup mysql. Basically, I am have a master on OS X server and want to setup a linux slave.
Create a mysql slave database from master database
After I copied ...
2
votes
1answer
172 views
issues with encoding and pg_dump/restore between windows and linux
I have a dmp file I have created using pg_dump encoded in WIN1252. What I would like to do is import it using pg_restore to a database on a Linux machine. The problem is that on the windows machine ...
0
votes
2answers
186 views
Postgresql - Segmentation fault (core dumped)
I'm working on postgresql code (server side).
I installed a version from source code following the official tutorial:
http://www.postgresql.org/docs/8.4/interactive/install-short.html
I did same ...
0
votes
0answers
64 views
how to install zabbix agent in agent host which we are adding from server to monitor
following this site i have intsalled zabbix server and agent in centos 6.0
zabbix version :1.8.5
http://www.youtube.com/watch?v=sKfYm-3thRM
but i am unable to add agent that is how to add other ...
3
votes
2answers
115 views
Choosing between MyISAM & InnoDB - two servers with related tables
I don't want to make a mistake.
I am about to put my website online and I admit I haven't thought about which MySQL engine to choose: MyISAM or InnoDB.
I read here and there that InnoDB should be ...
0
votes
2answers
324 views
Open source alternative to SQLMaestro for PostgreSQL
I'm looking for oen source alternative to SQLMaestro for PostgreSQL because it has visual database designer which not avaliable in pgAdmin which make database desinging so easy.
PS I'm not sure if ...
0
votes
2answers
841 views
Linux Error: 29: Illegal seek in LSNRCTL for Linux Version 11.2
I'm trying to get Oracle Database 11g Express set up on my server so that it is accessible from the outside. I can talk to the DB locally using SQLPlus, so the database is definitely running. I ...
1
vote
1answer
230 views
MySQL Tables crashing randomly
This is one of the many random Tables that get corrupted. Any ideas why and what would be causing this?
How do I keep MySQL tables from crashing and MySQL from crashing?
Repairing USR_wp537
...
0
votes
1answer
82 views
Does a standby slow down Oracle imp?
I have Oracle 10gR2 installed on Redhat Linux 5.4 on two servers (primary and physical standby).
When I import data into the primary server while the standby is started it takes too long to complete ...
0
votes
1answer
174 views
MongoDB Master and Slave Replication - Windows or Linux
I have recently moved my MS SQL Server Database to MongoDB (2.0) on Windows Server 2008. Its containing 2 databases with following stats. (both databases get around 100 reads/writes per second). These ...
0
votes
0answers
207 views
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)! in Fedora16
I installed MariaDB server in linux using tar file(mariadb-5.5.28a-linux-i686.tar.gz) followed by the instructions from this link : https://kb.askmonty.org/en/installing-mariadb-binary-tarballs/.
...
2
votes
1answer
236 views
mysql statement based replication - unsafe statements
I have recently set up statement based replication and my error logs are filling up with this error
121231 21:10:55 [Warning] Unsafe statement written to the binary log
using statement format ...
3
votes
2answers
808 views
Tool for Reverse Engineering of PostgreSQL Database on Linux (Ubuntu)
Please suggest a tool to reverse engineer a PostgreSQL DB into an entity-relationship-diagram (ERD) or equivalent ??
Ideally, I'm looking for a simple ERD or UML class diagram in a format that is ...
1
vote
2answers
211 views
Freeware GUI tool for DB2 , usable in Ubuntu Linux
Are there any freeware user interface tools for DB2 to be used in Linux (Ubuntu 11.04)? RazorSQL is pretty good, but it's not freeware.
-4
votes
1answer
48 views
how do I create a database and user? getting started with Oracle 10g xe [closed]
I keep getting database not open error whenever I try committing anything with the user \ as sysdba
how do I get started, create a table, create a tablespace and a user?
1
vote
1answer
151 views
Set up replication and migrate to InnoDB with low downtime
Current situation is this:
I have a large legacy DB using only MyISAM tables, the size of whole
DB is 4GiB, one of the tables contains over 10 million rows, so it is
pretty large.
The database is ...
