The database-administration tag has no wiki summary.
2
votes
1answer
1k views
How Do I Investigate a CPU Usage Spike Without Being Present?
I have a server that's mysteriously using up a lot of CPU late at night, when it shouldn't be under heavy load. This causes some database calls to time out, and I've set up some alerts in PerfMon to ...
2
votes
1answer
916 views
Grant MySQL user ability to create databases, and only allow them to access those databases
Is it possible to grant a MySQL user the privileges to CREATE new databases, such that they have full access to the databases they create (including the ability to DROP those databases). But other ...
2
votes
1answer
522 views
Access H2 Database from Outside of the App
I have an embedded H2 database running for a web-app that I am working on. The programmer who built the app has gone and I am faced with learning the system and figuring out a way to look into this ...
1
vote
3answers
627 views
What is default admin for SQLite?
Workbench is MySQL default. Correct me if I'm wrong. I dont believe SQLite has it own default admin. Is there any recommendation for the admin?
1
vote
4answers
133 views
Editing an SQL Database
I'm new to php, so I installed xampp for windows.
Is there a windows software for easy MySQL administration?
(creating/displaying/editing tables + data, creating relations ..)
i've managed to open ...
1
vote
1answer
473 views
Collaborative use of bibtex as an online database (JabRef)?
I am thinking about a collaborative effort, where several people would need to insert data; for different reasons, it would be most convenient that this data is in bibtex format (the references format ...
1
vote
1answer
265 views
How to migrate a database from MyISAM to InnoDB?
I am migrating a database with MyISAM tables to an InnoDB engine.
Some of the tables in MyISAM have full text indexes. If I have to retain the full text indexes in InnoDB engine, what are the things ...
1
vote
1answer
132 views
Change location of storing mysql database
Im running a linux server and I wondering if and how could I change the contents of Mysql server to be saved on an external hardrive instead of the place where it is being stored now.
1
vote
1answer
229 views
How can I modify tables and forms in a MS Access database using UA Business Software 7.0?
I need to make changes to table structures and forms on a MS Access database using UA Business Software 7.0
The problem is that UA hides everything and everything is locked.. It doesn't even look ...
0
votes
4answers
249 views
Sharing Excel sheet over network?
Is it possible to have a server PC running a Microsoft Excel sheet to which several Thin Clients, with Barcode Scanners, will be connected via TCP/IP? The scanners should dump their data in the Excel ...
0
votes
1answer
601 views
Restricting a user to access only his own tables in Oracle SQL Developer
I am confused in the permission, privileges in the SQL Oracle Developer. The user created can access all the schema/user 's tables. I want to restrict specific user in the database to access (ALTER, ...
0
votes
1answer
3k views
How to reset the postgres super user password on mac os x
I installed postgres on my mac running 10.6.8 and I would like to reset the password for the postgres user (I believe this is the super user password) and then restart it.
All the directions I found ...
0
votes
0answers
64 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 ...
0
votes
0answers
123 views
Just upgraded MySQL 5.6.10 on Mac OSX 10.8.2 - Where are my databases?
I can no longer see my databases after upgrading. Anyone have an idea how/where to find them and how to migrate them to the newest versions file locations?
0
votes
0answers
25 views
Configuring the mysql server
I have a mysql server installed in RHEL 6 system with 128 GB of Ram and 16 Cores. i am running 4 websites with quite heavy queries having big joins and sortings. Please suggest me a good configuration ...
0
votes
0answers
54 views
MongoDB Command Line Tool
Is it possible to enter arbitrary command in MongoVUE and get result? If there is not such feature do you know any other windows app that can be used as mongo front-end console?
How can I write ...
0
votes
0answers
216 views
Database design of a User validation, roles and rights module [closed]
I am trying to model a User Authentication module for a MS SQL Server database that will be the back end to a Delphi UI Application. Basically, I want to have user accounts where the user belongs to ...
0
votes
0answers
33 views
Installing Oracle11gr2 on redhat linux
I have basic question about installing applications on linux operating system. i am going to express my issue considering oracle db installation as a example. when installing oracle database , i ...
0
votes
1answer
452 views
Mysql not starting with changed datadir
I was looking for a way to store my mysql databases on a different partition than the default installation. I found this link and followed the steps.
However, after having changed the line datadir = ...
0
votes
1answer
78 views
Issue changing mysql password on Debian
I installed mysql on my Debian server. I couldn't get into the database because it kept saying I put in the wrong password so I looked on the internet and found that I could log onto mysql using the ...
0
votes
1answer
42 views
Database Tool with good Interface for Reusing user-created Queries
I am looking for a tool that would help me easily reuse queries.
What should it be like?
You type a query like Select * FROM person where name LIKE ${name}
And you would like to re-use this type of ...
-1
votes
0answers
21 views
what software can I use to show mapping of 2 database? [closed]
I have 2 database server main database A and other database B.
Database B is same as A but the name of tables and some of the field name are different, but data inside is almost the same.
Database B ...
