Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > SELECT * FROM Questions WHERE Type = 'Stupid'
 
  • Post
  • Reply
Tayter Swift
Nov 18, 2002

Pillbug

Twlight posted:

Hi everyone,

I have a database is dumped every day and sent via ftp to another server. Sometimes I would like to open this sqldump and make a few queries on, but I don't want it to overwrite the current database. I saw that you can dump the sqldump back into the same database but I was unsure because I didn't want to overwrite the data. Is there a way I can open an sqldump file and perform some basic queries on it without it overwriting the main db?

Can you send it to a server that has its own instance of sql running (ie doesn't have the operational db you're using)?

* # ¿ Dec 28, 2007 21:43
  • Quote
Adbot
ADBOT LOVES YOU

# ¿ May 6, 2024 16:17
  • Quote
  • 1
  • 2
  • 3
  • 4
  • 5
  • Post
  • Reply
The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > SELECT * FROM Questions WHERE Type = 'Stupid'