Questions tagged [database-administration]
296 questions
0
votes
4 answers
How to create empty database from existing one (Mysql)
I have a mysql db with many tables.
I'm starting a new farm which should contain empty versions of the same database tables.
How can I efficiently create empty database based on existing one?
Niro
- 1,401
- 4
- 20
- 36
0
votes
2 answers
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 located and how I can connect to it.
Update
I found…
Radek
- 1,153
- 4
- 26
- 39
0
votes
1 answer
Make a copy of database with SQL Server Management Studio Express 2005
I have a database in MS SQL Sever 2005 Express. I need to make a duplicate of it to test some upgrade scripts. I've tried to backup and restore to a new database, and it fails because it can tell the databases are different. I don't see a way to…
drye
- 101
- 1
- 3
0
votes
2 answers
Options to handle corrupt msdb ldf file
Specs: We're using SQL Server 2005 with transactional replication.
Our MSDB .LDF file has recently become corrupted, causing the MSDB db to be marked as 'suspect'. We read a bunch of stuff online and learned that to fix this you either have to…
user48662
0
votes
1 answer
Connect to and reindex Postgres database with system table errors
I've got a Postgres database that crashed (as well as the disk) and suffered some data errors (per After DB disk failure, now "cache lookup failed for index").
The initial problem seems to be the system tables, as the answer in that question…
bennylope
- 103
- 1
- 6
0
votes
2 answers
db2 tablespace size and performance impact
Originally when we began moving to db2 LUW we ran into some issues where our tables were too big to fit into the default 4K table space. As a result of "pressure" to get it done we just went with a 32K default table space and put ALL of our tables…
telstone
- 159
- 10
0
votes
2 answers
Enterprise level control of ClickOnce product on corporate network with group policy?
Hi there I'm a developer looking at introducing ClickOnce deployment for an internal .NET Winforms application that will be distributed via the corporate network.
Currently the product roll out and updates are handled by Group Policy however I would…
MrEdmundo
- 291
- 6
- 14
0
votes
1 answer
Reccomendation for tuning 100's of SQL Databases
I'm running several SQL servers, each running a few hundred multi-gig databases for customers. They are all setup homogeneously as far as the schemas are concerned, however customer usages of the data differ quite a lot from database to…
wayne
0
votes
1 answer
Column locking in innodb?
I know this sounds weird, but apparently one of my columns is locked.
select * from table where type_id = 1 and updated_at < '2010-03-14' limit 1;
select * from table where type_id = 3 and updated_at < '2010-03-14' limit 10;
the first one would…
mingyeow
0
votes
1 answer
How can i see what is locking up a table?
Possible Duplicate:
“Delete query” not able to be completed
I am trying to delete a single row from the db, but it is not completing,even in 20 minutes.There is no other queries locking up the db. I suspect it is some "leftover" lock from…
mingyeow
0
votes
1 answer
Maintenance Plan Reporting - Append To File - Clean Up?
Background: (SQL Server 2005, Standard Ed.) I have a maintenance plan running backups, taking a full backup 1/day, and t-log every 15 minutes. I have it set to create a text file report of each run, but that creates A LOT of files on the file…
Adam J.R. Erickson
- 147
- 2
- 6
0
votes
1 answer
how to delete a database manually in oracle?
How do i delete database manually. Is tehre any commands for deleting a database? I usually connect through VNC but its better if there is any command line tool.
raj
- 371
- 1
- 4
- 9
0
votes
2 answers
How should I copy the "mysql" database to my new server using PHPMyAdmin
My new webhosting company has set up a MySQL database for me and it has the tables MySQL and Information_schema already there. I want to copy my existing database from another server (a) to the new one (b). I assume I need to overwrite the 'mysql'…
undefined
- 654
- 2
- 8
- 18
0
votes
0 answers
How to handle scaling upto 3k concurrent connections
So here's our use case:
We have firmware that connects to server (simple php file - that takes post request) and add the data (350-500 bytes per request) to database.
Now here's a issue we have 3k units in the market and non-technical manager wants…
0
votes
0 answers
pt-query-digest on large slowlog files runs slow - only singlethread
I have large slowlogfiles generated by percona 5.7 packed by zstd. Its for test, logging all queries, query time is set to 0s
I need it process quickly than in 12 hrs :) The pt-query-digest is probably only singlethread app in default setting and in…
Petr Schönmann
- 11
- 4