|
I have at least one database file that is too big to backup on my server.
I want to make sure when I uninstall a botched upgrade to SQL Server 2008 that it won't delete any of my .mdf files that I've created myself under SQL Server 2005.
I'm pretty sure...
Started by Simon on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
To be on safer side detach database and back it up..
It's correct.
|
|
I'm using PHP and MySQL. I need to do a query:
DELETE FROM db1.players WHERE acc NOT IN (SELECT id FROM db2.accounts)
The problem is, that db1 and db2 are located on different servers. What is the fastest solution for such problem?
To be precise: I'm ...
Started by Thinker on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Have you tried the following?
DELETE and the two databases are not on the same server? Have a look here: http://www.dottedidesign.com_CONCAT(id) FROM accounts"); query($db2, "DELETE....
Not sure about this.
Directly on the MySQL server.
|
|
I need to delete databases whose name start with "In"...
I Tried "Like" but it is throwing syntax errors...
I tried following command but throwing syntax errors for "name"
SELECT 'DROP DATABASE ' + name + ';' from sys.databases where name like 'In%'
Answer Snippets (Read the full thread at stackoverflow):
So if you had two databases....
You can create a CURSOR that loops over
SELECT name have any databases to drop to test this ;)
You could create a SQL statement to generate a script that script.
The names of the databases from sys.databases.
|
Ask your Facebook Friends
|
Is there any commands to look up databases that has no any activity in a month or so?
Just take SQL dumps for a month and run diff and if there's no differences delete that DB?
Started by raspi on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
If it doesn't, mtime should use the MySQL replication logs to see if there's been any write activity against those databases it up with a bit of work to log all....
Not know if mysql continually touches the databases that it has open or not.
|
|
Like phpMyAdmin has to be installed as a web application to work with MySQL databases, is there a downloadable program that can connect to a remote MySQL server to create, read, update and delete databases, tables, columns and rows?
Started by Jeremy Rudd on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
My favourite is HeidiSQL , a fork of....
Here They are doing an EOL but rolling them into a new product .
Download them in one package from:
MySQL GUI Tools
MySQL GUI tools are great .
For Windows, you can use MySQL Query Browser and MySQL Administrator .
|
|
I've read that although SQL is meant to be standardised, it is implemented different etc with different databases. I have only ever used MySQL for databases.
What I would like to know is what other databases share the same syntax? I am using PDO now, ...
Started by alex on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Writing cross.
In practice:
Not all databases support the full set of SQL-92 .
Everything you've mentioned: SELECT , INSERT , UPDATE , DROP , DELETE , as long as you don't use complex clauses with them.
|
|
Hi, Is there any way to create triggers on different databases? my requirement is like:- database: a1.db consist table: t1 database:a2.db consist table: t2
now i have to use trigger on t1 (whenever any delete and update operation) happens on t1 a value...
Started by Abhimanyu on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
What are the other databases you are using besides mysql? If Oracle is one of them, then you can create dblinks from Oracle to the other databases, and your trigger (running on Oracle) could use those dblinks to update the tables in the ....
|
|
I find it tedious to have to backup databases every week. And I also think weekly backups should be turned into daily backups. If I had to do that, I don't want to do it manually. What's the best way to automate the backing-up of PostgreSQL databases ...
Started by Randell on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
List of databases in system , exclude the tempate dbs DBS=$($PSQL -l -t | egrep -v 'template[01 data from postgres databases to plain text $PGDUMP -C -c -s $database | gzip -9 > $SCHEMA # dump data $PGDUMP -a $database ....
|
|
I'm looking for a solution to backup our websites and MySQL databases on a Windows Server 2008. Our current host does a full weekly and daily differential backups, but I would like to maintain my own set of backups as an extra precaution.
We do have MySQL...
Started by Eddie on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
Then include the dump files into the rest of what you compress .
Of the databases, or even each separate table.
|
|
What is the database concept equivalent to "when deleting the user, delete all his posts"? And is this a good thing?
Another example: if your website is a programming forum, you need to find and delete comments related to that topic before deleting the...
Started by ahmed on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Soft" deletion - flag the rows in the databases as being deleted, which will prevent them from being deleting a user's posts when you delete their user account may not be the best behaviour in all cases that will execute....
|
