Sponsored Content
Top Forums Shell Programming and Scripting Moving a database from one server to another Post 302436975 by Scott on Tuesday 13th of July 2010 02:56:36 PM
Old 07-13-2010
Hi.

You're getting the > because you have an opening single quote ', which is never closed.

In any case, I don't think you can pipe tar to ssh in this manner.

Best is to tar and compress the stuff, then scp it.

Code:
tar cf - dir_of_my_files | gzip -c > dir_of_my_files.tar.gz
scp dir_of_my_files.tar.gz user@host:/some_dir

As to whether your database actually works on the other server depends on more factors (software being one of them)

HTH
This User Gave Thanks to Scott For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Moving data from one database to other

Dear All, I have 2 databases, There is a lot of data in both the databases, i would like to move some data from one database to the other. I would like to accept 2 parameters from the user, i.e. emplyee id & dept, on entering the 2 i will unload all the data from the tables to the flat files.... (6 Replies)
Discussion started by: lloydnwo
6 Replies

2. AIX

Moving to new AIX server

Hello everybody, I am going to move to new AIX server and the question is how to correctly and painless move the whole configuration? I mean for example users, network, and - what is very important - the whole printer system configuration? I think users are simple to move - only /etc/passwd and... (1 Reply)
Discussion started by: Yac
1 Replies

3. UNIX for Dummies Questions & Answers

moving apache from 1 server to another

i need to move apache 2.2 from one server over to another server..... my servers are in atlanta and i'm logged in here in florida... what commands do i use ???? somebody mentioned the fetch command... please help.... i'm an idiot when it comes to unix (2 Replies)
Discussion started by: marinob007
2 Replies

4. AIX

moving to new server

I'm moving an application from an old RS6000 running 4.3.2 to a p5 running 5.3. Could someone point me a the direction on docs to perform such a function? Critical OS files, moving of printers and print queues especially. thanks (5 Replies)
Discussion started by: sullivjp
5 Replies

5. Shell Programming and Scripting

Moving files from one server to another server every 5 min

HI All, I am trying to automate my stuff to make 'to-do-easier'. I am new to shell scripting. I need help to you regarding the below problem. I have one directory in my server, frequently files will store in that directory. I want to move that files into another server on every 5... (5 Replies)
Discussion started by: ravvamohan
5 Replies

6. Solaris

Key Points when Moving from Server A to Server B??

Hi Everyone, I'm still learning daily about UNIX (specifically Solaris 10). I'm tasked with moving my current application and database from Datacenter A to Datacenter B. There will be no updates and no changes other than a new server and new location. So far, I have Solaris... (3 Replies)
Discussion started by: smckech1972
3 Replies

7. UNIX and Linux Applications

Moving Oracle database

how does one move Oracle database to new OS? Does Oracle need to be the same version as old one? (6 Replies)
Discussion started by: orange47
6 Replies

8. Programming

Problem with Perl script after moving from a Windows/Apache Server to a UNIX server.

I have a Perl script that worked fine before moving it to justhost.com. It was on a Windows/Apache server. Just host is using UNIX. Other Perl scripts on other sites that were also moved work fine so I know Perl is functioning. The script is called cwrmail.pl and is located in my cgi-bin. When I... (9 Replies)
Discussion started by: BigBobbyB
9 Replies

9. Red Hat

Moving boot SSD from a dead server to a new server

Hi all, We have a disk array that has the boot drive on an OCZ SSD on a PCIe card. Well, the motherboard died and we got a new motherboard. We moved the controllers, NICs, etc, to the exact same slots on the new motherboard, except now it won't boot. I guess it doesn't recognize the OS on the... (1 Reply)
Discussion started by: glowe57
1 Replies

10. UNIX and Linux Applications

Is it mandatory or not to stop/start Applcation server ehen Restarting Database Server?

Good afternoon I need your help please. There is a Mantenance Windos which needs to Restart de Database Server 192.x.x.97 to set up some configuration Is it mandatory or not to stop/start Applcation server that runs in 192.x.x.95 ? Is it mandatory or not to stop/start apache and Tomcat?... (3 Replies)
Discussion started by: alexcol
3 Replies
nsquery(1)						      General Commands Manual							nsquery(1)

Name
       nsquery - name server query command

Syntax
       /usr/ucb/nsquery [ lookup ] [ host ] [ server ]

Description
       The command provides an interface to obtain host name and address information.

       If  you	specify  host,	the command obtains information about the specified host. If no host is specified, the command obtains information
       about the local host system.

       If you specify server, the command queries the BIND server that you specify. If you do not  specify  a  server,	the  command  queries  the
       default BIND server.

Options
       lookup  Retrieves the host name, Internet Protocol (IP) address, and aliases of the specified host.  If no host or server is specified, the
	       command obtains information about the local system from the default BIND server.

	       If you do specify the lookup option, the command obtains the information about  the  BIND  server  and  host  specified	(or  their
	       defaults).   If the system from which you issue the command is a BIND server, and you do not specify the lookup option, information
	       about only that server is retrieved.

Files
       Directory containing BIND server data file

       BIND server boot file

       Host database file containing name to address mapping for BIND primary
			   server

       Host database file containing address to name mapping for BIND primary
			   server

       Local host database file containing address to name mapping for BIND
			   server

       BIND server cache file

       BIND data file

See Also
       nslookup(1), resolver(3), resolver(5), named(8)
       Guide to the BIND/Hesiod Service

																	nsquery(1)
All times are GMT -4. The time now is 05:00 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy