The tag has no wiki summary.

learn more… | top users | synonyms

3
votes
2answers
3k views

MySQL Table not repairing

Table info: Database name: user_motiva Table name: wp_options.frm wp_options.MYD wp_options.MYI wp_options.TMD when I do a mysqlcheck -r --all-databases it gets hung on that table even if you ...
0
votes
1answer
196 views

Which db managment software can copy from one sqlite3 table to another for fields which are common in both?

We are looking for db management software which can copy from one sqlite3 table to another for fields which are common to both tables. For example, if table A has column name and address. Table B has ...
0
votes
0answers
71 views

MySQL response times spiking at regular intervals

I recently set up a windows Hyper-V VPS with a bitnami django stack. I am monitering the website with newrelic. I noticed that my MySQL database response times spike about every 30 min. My first ...
2
votes
1answer
3k views

Unable to start SQL Server Instance 2008 R2 - DB file corrupt

I was not able to start the SQL Server 2008 R2 production DB instance. After reading the log file error message is " The log scan number passed to log scan in database ‘master’ is not valid. This ...
0
votes
1answer
122 views

How can I change the Postgres data_directory folder location?

I use Ubuntu 12.04, postgresql 9,1 postgis 1.5. I want to change database location. I use instruction http://www.whiteboardcoder.com/2012/04/change-postgres-datadirectory-folder.html The only ...
3
votes
4answers
514 views

Best practices for SQL Server audit trail

I'm facing a situation today where it would be very beneficial to me and my company if we knew who had logged into SQL and performed some deletions. We have a situation where at least 2 (sometimes 3) ...
0
votes
1answer
314 views

MySQL Creating a Database CentOS (6 - 64bit) Error 1064 (42000)

When ever I type in : GRANT ALL PRIVILEGES minecraft.* TO 'minecraftu'@'%' IDENTIFIED BY '********'; It gives me an error of : ERROR 1064 (42000): You have an error in your SQL syntax; check the ...
0
votes
1answer
45 views

Confusing MySql Error

I am trying to install an application on CentOS, and see this error in my apache log. If any can help me understand what exactly is the case, I can try to work on a solution for the error. This is ...
2
votes
2answers
302 views

How to disable 1 version of PostgreSQL server without uninstalling it

I have installed PostgreSQL 9.1 and 9.2 on my Ubuntu machine. The postgresql service starts both versions: $ sudo service postgresql start $ * Starting PostgreSQL 9.1 database server [ OK ] $ * ...
2
votes
0answers
198 views

SQL Azure Automated Backups doesn't work

I configured automated export of my SQL azure db, but backups are not created. Also, I'am resieved this mail. Automated SQL Export failed for [servername]:[dbname] at 25.09.2013 23:06:45. The ...
4
votes
4answers
3k views

How to shape size of SQL server resorces (RAM, CPU, and others)

It is standard story, there is fight between developers and administrators. One denunciation that database design and queries are bad while others says It is lack of hardware and amount of data. So ...
0
votes
1answer
84 views

Setting innodb_buffer_pool_size in for Mysql

We have a dedicated DB box with with 8 GB of RAM and running Redhat linux 64 bit OS. Our MySQL Data + Index size almost 7.8 GB. About setting innodb_buffer_pool_size, I have read 2 suggestions Set ...
0
votes
1answer
123 views

CouchDB administrator password reset

I have an install of couchDB, and somewhere along the line, a malformed request via CURL has my admin accound with a password that I don't know. Short of setting up another Couch server, then ...
0
votes
5answers
1k views

MySQL privileges - DROP tables, not databases

Can someone help me with privileges here. I need to create a user that can DROP tables within databases but cannot DROP the databases? From what I understand from MySQL docs you cannot simply do ...
0
votes
2answers
664 views

how to reset Joomla admin password from the shell?

any idea how I can reset/change Joomla admin password from the linux command line? I have root access to the box. I don't think I can do it phpMyAdmid way. I don't know where the Joomla db is ...
1
vote
1answer
1k views

SQLVDI error - attempt to release mutex not owned by caller

I've started getting some errors in the App event log of one of our database servers (Windows 2003 & SQL Server 2005). The nightly full database backups are completing successfully however ...
7
votes
2answers
6k views

Can't Login to phpPgAdmin

I'm trying to set up phpPgAdmin on my test machine so that I can interface with PostgreSQL without always having to use the psql CLI. I have PostgreSQL 9.1 installed via the RPM repository, while I ...
1
vote
2answers
1k views

Throttle or limit resources used by a user in a database?

I would like to know how databases (like MySQL) are able to manage per user resources (like Oracle Database Resource Manager does) to be able to have users that may only get resources only when the ...
0
votes
1answer
160 views

Why won't Postgres start after stopping it?

Postgres was running just fine (I have created a database using template0). Then, I used: $ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data stop --mode=smart to stop Postgres and it stopped ...
1
vote
0answers
21 views

My transactional overnight batch has spiked in duration

I have an overnight batch run which is transactional...picking up data doing some small calculations and putting it somewhere else and it was finishing around 3am every day for the last 2 months. Now ...
-1
votes
1answer
37 views

InnoDB Failure of some kind [closed]

I have MySQL 5.5 installed. I tried to install Joolma but it failed. I went into their sql and replace EGNINE=InnoDB with MyISAM and the install worked. InnoDB is listed under SHOW ENGINES; Any idea ...
1
vote
1answer
519 views

Is it possible to increase the max limit of 10 pc's to any number of times without making the user a domain admin?

Normally a domain user has a maximum limit for 10 computers to join to a domain. But what i want to know is, is it possible (by joining a account to a group) to do this any number of times without ...
0
votes
1answer
753 views

Get permissions in fixed or user-defined server roles in SQL Server 2012

I'd like to know how to get a list of permissions that belong to fixed and/or user-defined server roles in SQL Server 2012. In previous versions there was an sproc sp_srvrolepermission but this is ...
-2
votes
4answers
523 views

will a 100GB database with large tables on MSSQL 2008 server run on a 3GB RAM system? [duplicate]

This will be only for testing and developing. I have a 100 GB DB I am working on and need a sanbox envorinment. The only hardware I have is a desktop with 3GB and 32bit. I am able to install SQL 2008 ...
1
vote
5answers
1k views

Moving MySQL Data from 1 RDS server to another

How do I go about moving certain data (returned by a simple query) from one database in AWS' RDS to another? An interruption of up to 20 mins is acceptable, although not preferred. My current plan ...
0
votes
2answers
174 views

Postgresql performance enhancement

I have my setup like this: Two separate instances of the database on a clustered environment. Both instances are on dedicated servers each carries up to the standard configurations. Instance one ...
0
votes
2answers
513 views

MariaDB set maximum database size to 1 GB

I'm using MariaDB on my hosting. I would like to limit database size to 1 GB. How to do this properly in /etc/my.cnf ?
2
votes
5answers
21k views

How can I synchronize MS SQL Server databases?

How can I synchronize MS SQL Server databases? Is there any tool, preferably open source?
0
votes
2answers
260 views

PostgreSQL, automate REINDEX, Windows environment

I have a couple of PostgreSQL tables (9.1) which are inserted to / deleted from often. Over time they suffer from index bloating even though the autovacuum is configured and runs regularly. I'm ...
0
votes
1answer
132 views

Replicate from slaves to master and viceversa

I've a great dilema here and didn't know how to solve it. I need to replicate a few tables from MySQL DB (slaves) to MySQL DB (master). Take as an example this: MySQL DB (master) table1 table2 ...
3
votes
2answers
8k views

Changing host permissions for MySQL users

I have the following grants for a user/database mysql> SHOW GRANTS FOR 'username'@'localhost'; +---------------------------------------------------------------------------+ | Grants for ...
4
votes
1answer
5k views

How to calculate max_connections for PostgreSQL and default_pool_size for pgbouncer?

Is there a rule or something I can use to calculate a good number for max_connections, default_pool_size and max_client_conn? The defaults are odd. PostgreSQL defaults to max_connections=100 while ...
2
votes
8answers
2k views

What's a good free MySQL admin tool? [closed]

I'm looking at phpMyAdmin to manage users and create the database in the first place. Is it the best thing to go for, or are there other packages that are not web based that might be faster or better? ...
0
votes
1answer
115 views

How do I install a previous version of Postgresql in debian?

I am running debian squeeze. I want to install a previous version of postgresql. The current version in the postgres debian repository for 9.0 is 9.0.12. I specifically need to get 9.0.8. How can ...
0
votes
1answer
1k views

Native Postgresql 9.2 Streaming Replication

I'm trying to build up native postgresql 9.2 streaming replication in the Amazon cloud. According to documentation, I've set up everything correctly - but at the slave I get these logs: 2013-02-04 ...
-1
votes
1answer
281 views

MySQL Configuration on my.cnf [closed]

[mysqld] core-file default-storage-engine=MyISAM max_connections = 5000 max_user_connections = 5000 key_buffer = 1024MB myisam_sort_buffer_size = 512M join_buffer_size = 256M read_buffer_size = 256M ...
1
vote
1answer
58 views

dropping a MySQL table in a method complying to the Department of Defense Data Clearing and Sanitizing Standard

I need to delete a set of MySQL tables for a client in a manner that's compliant with the Department of Defense Data Clearing and Sanitizing Standard. I've a list of acceptable tools including wipe, ...
0
votes
1answer
131 views

Backup and bz2 large mysql datefile with innobackupex in the background

I'm using the following command to backup a large running mysql database (~500GB). innobackupex --user=user --password=***** --stream=tar ./db-backup | bzip2 - > backup.tar.bz2 Since the backup ...
0
votes
1answer
43 views

Installing MS SQL Server 2008 R2 Utilizing Data Array

Maybe I can't put together a query that finds what I am looking for on the Internet, but I want to make sure this is done right. I have a new server that has Windows Server 2008 R2 loaded onto a RAID ...
1
vote
2answers
648 views

SQL Server variable size and increase it

It is not clear to me how a varchar(max) is declared or used in an SQL Server e.g. 2005 Is a variable declared as varchar(300000) for example considered as a varchar(max)? E.g. I am seeing in a DB in ...
1
vote
2answers
459 views

Low priority batch processes on live Mongo database

We want to run MapReduces on our live Mongo database, mainly so that we can extract metrics. However, we've had some bad outages caused by these MRs bogging down the Mongo server (in particular 100% ...
2
votes
2answers
381 views

What tool generated this report of MySQL server performance?

I found this report on the performance of a MySQL server. I would like to be able to generate this report for my own server, but I don't know what tool they used. Does anybody recognise this report? ...
1
vote
0answers
31 views

Move one site in Wordpress Multisite setup

I have a Multisite Wordpress setup with a dev box and a live. Whenever my developers change a theme on one of the sites or add a page/post/any other content on the deb box, I have to take the whole db ...
0
votes
1answer
45 views

DB Migration switching from MySQL [closed]

I currently have a massive MySQL Data but would like to move over to Cassandra nosql. How hard of a move over would this be? I've not found any examples yet on this being done. It is possible right.
2
votes
1answer
324 views

Using mongodump with an auth enabled mongodb server

I'm trying to do a daily backup of my mongodb server (auth enabled) using the mongodump tool. mongodump provides two parameters to set the credentials: -u [ --username ] arg username -p [ ...
1
vote
1answer
128 views

Are there measurable benefits to running XFS on EC2

I am looking at creating a PostgreSQL database image (to run on Amazon EC2) and I have heard good things about XFS. However, since ultimately you are running in a VM, the gain of XFS on EC2 might ...
0
votes
1answer
124 views

All users can read SSAS all Cubes

I found that all my domainusers can read the cubes in my Microsoft Analasys Services. I have no roles specifying that. Neither the domain admins nor the local admins contain any group that would ...
5
votes
4answers
919 views

Testing MySQL Database Replication / Synchronization

I'm setting up a MySQL Master database which replicates to a few Slave databases. My question is what are the best practices to monitor and / or test that the slave databases are up-to-date, and that ...
3
votes
3answers
860 views

How to change default recovery for new databases?

How can i configure the database server on our development server so that when new databases are created that they are Simple recovery model by default? Currently if we remember, when creating a ...
1
vote
1answer
113 views

Table Space and Data Sized increased multiple times after power failure

We had a total power failure on our 2 node cluster using SQL Server 2008 (10.0.2531) Standard Edition. After recovery, everything is running fine. One issue I discovered is the Table Size and the Data ...