|
I have a database server running several instances of database. I am having issues while accessing a particular database and want to restart the same but without restarting the entire db server as it will effect other databases in the instance or other...
Started by viky on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
DATABASE MyDatabase SET OFFLINE WITH ROLLBACK IMMEDIATE go ALTER DATABASE MyDatabase SET ONLINE go
What are the issues that you're seeing when accessing that particular database? If it's database corruption, restarting the....
|
|
I have backups of my postgres database - the entire database instance in a single nightly backup. Is it possible to restore just one of the database from within that backup? Or if I want to access individual databases (for migration or restoring), do ...
Started by cnk on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Terminology here - you refer to a DB cluster as "entire database instance"; in the explanation you ask I restore just one database from a pg_dumpall of the entire database cluster?"
about "database" but in the....
|
|
I'm being given a data source weekly that I'm going to parse and put into a database. The data will not change much from week to week, but I should be updating the database on a regular basis. Besides this weekly update, the data is static.
For now rebuilding...
Started by Daniel Lew on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
Normally, your transaction would lock your
But it requires SQL Server, so if you... .
Which database server are you using? SQL 2005 and above provides a locking method called "Snapshot of the database continue to view the pre-transaction data.
|
Ask your Facebook Friends
|
I'm in a situation where I would to generate a script for a database that I could run on another server and get a database identical to the original one, but without any of the data. In essence, I want to end up with a big create script that captures ...
Started by Michael Lang on
, 12 posts
by 10 people.
Answer Snippets (Read the full thread at stackoverflow):
Any domain tables you have, you need to remember to turn on the identity insertRun Sql Server Management Studio, right click on the database and select Script Database as > Create to > file
That....
Your entire database.
|
|
My webapp that I am developing will incorporate a forum (phpbb3 or smf), a wiki (doku wiki flat file storage), and my main web app.
All of these will share a User table. The forum I expect to see moderate usage (roughly 200 posts a day) to begin with ...
Started by WarmWaffles on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
If there is any two databases has some advantage....
It depends.
Changing which database a table is stored in shouldn't require a huge amount of code.
You can always upgrade your site later.
With, then it's fine to have a single database.
|
|
I just got a lovely access database, so the first thing I want to do is to move it over to a normal database management system (sqlexpress), but the only solutions I've found sounds like craziness.
Isn't there a " export database to .sql " button somewhere...
Started by marcgg on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
In Access....
A quick-and-dirty way to upsize Jet/ACE tables to any ODBC-accessible database engine:
create an ODBC DSN for your database.
Source for your Import Data operation? (Database->Tasks->Import, Microsoft Access as data.
|
|
Hi,
I would like to delete a complete database created by my application.
Do you know any adb command, or android sentence to do it?
Thanks in advance. Best regards. Jose.
Started by Josemalive on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
I think you need to start up your emulator with the command: -wipe-data
You can run the command:
adb -s emulator-5554 shell (or whatever port you use) cd /data/data/<packagename>/databases/
By typing ls, you will see the databases....
|
|
I am working on a MySQL database that is huge (about 120 tables). I am trying to make some sense of it and it will help a great deal if I can search all 120 tables + columns for a string I am looking for.
Is that possible to do on a MySQL DB?
Started by Omnipresent on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
It would remove the need for time consuming search queries, and... .
If you dumped the table into a file(mysqldump) with the data, then you would be able to grep any information you wanted out of it .
There is one solution, which might not be what you want .
|
|
Hi guys,
I'm trying to find out if this is possible, but so far I haven't found out any good solutions. What I would like to achieve is write a stored procedure that can clone a database but without the stored data. That means all tables, views, constraints...
Started by hancock on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Check out this link:
http://www....
It's possible - not very nice and easy.
Are in the database, determine their potential dependencies, and then create a single or a collection of SQL scripts which re-create the database, and execute those.
|
|
Ok, say you have two dbs. one you use as a master template which goes through various revisions, let’s say we’re now on revision 3. but the second db is a copy of the template as it was at revision 1.
because db 2 is in use, you don’t want to drop any...
Started by scrumpyjack on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
This must.
Import, the best approach is to be able to create the whole database with some data from scripts.
You can try MySQL workbench ; it allows you to
Create schema from a MySQL database.
|
