| Linux - Server This forum is for the discussion of Linux Software used in a server related context. |
| Notices |
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
 |
GNU/Linux Basic Guide
This 255-page guide will provide you with the keys to understand the philosophy of free software, teach you how to use and handle it, and give you the tools required to move easily in the world of GNU/Linux. Many users and administrators will be taking their first steps with this GNU/Linux Basic guide and it will show you how to approach and solve the problems you encounter.
Click Here to receive this Complete Guide absolutely free. |
|
 |
07-07-2009, 06:30 AM
|
#1
|
|
Member
Registered: Aug 2004
Location: Saudi Arabia
Distribution: Mandrake
Posts: 60
Rep:
|
sending data to server?
hi guys...
i have a project in the university which is to make a data base program that send data to a server which will show the the data to another user on the internet....
but i don't know how to transfere data from the program to the server...
can any body help?
|
|
|
|
07-07-2009, 08:09 AM
|
#2
|
|
Guru
Registered: Oct 2005
Location: Willoughby, Ohio
Distribution: linuxdebian
Posts: 7,231
Rep: 
|
That sounds like a homework problem, which we don't answer per the rules here..
Don't expect people here to do your school work for you, you won't learn anything that way..
If you had a solution already started and had a specific minor issue you needed help with, then assistance might be provided. but asking us to provide the overall solution to the issue isn't going to happen..
Best of luck, or narrow down the scope of the question..
|
|
|
|
07-07-2009, 11:33 AM
|
#3
|
|
LQ 5k Club
Registered: Aug 2005
Distribution: OpenSuse, Fedora, Redhat, Debian
Posts: 5,259
|
What farslayer said, notwithstanding...
You will need to start by breaking the problem set down into MUCH smaller components. Start by clearly defining what you mean by the various components: 'server', 'data base program', 'send data', 'show the data', what you mean by 'data', etc. Maybe you should define what computing platform(s) you wish to use or are required to use. When you have done this basic first step, you may have identified more specific questions that someone here can reasonably answer.
--- rod.
|
|
|
|
07-07-2009, 07:46 PM
|
#4
|
|
Member
Registered: Aug 2004
Location: Saudi Arabia
Distribution: Mandrake
Posts: 60
Original Poster
Rep:
|
what i mean is what opensource tool i can use to send data (from data base like mysql) to a dtata base on a server?
|
|
|
|
07-08-2009, 09:29 AM
|
#5
|
|
LQ 5k Club
Registered: Aug 2005
Distribution: OpenSuse, Fedora, Redhat, Debian
Posts: 5,259
|
Do you mean you want to make a copy of the database, and transfer that copy to another database server? In your original post, it sounded like you want to be able to extract specific data from the database, and display it for an end-user. This is fairly common practice. An application, that you would have to write as a PHP or CGI application running on a web server (Apache, for instance), would fetch application-specific data from a database server, and then format it as a web page according to the specifications of the application. The end-user would view and/or manipulate the data using a web browser.
The basic components to do this are: database server (DBMS) such as mySQL or PostgreSQL, web server such as Apache, the application code that you write (in PHP, Perl, etc.), and any web browser. Most modern Linux distributions include all of these components, and if not included, are easily acquired and installed. Just add code.
If you simply want to copy a database from one database manager to another, then there are at least a couple of options. You can do a 'dump' of the database using the tools provided by whatever DBMS you use. The resulting file can be transferred to another host, and loaded as a new database. This requires the source and destination DBMSs to be the same product, and probably the same or similar versions. The file transfer can be done using any number of common file transfer protocols such as SFTP, SCP, FTP (not preferred), etc. Alternatively, you could write an application that makes concurrent database connections to the two DBMSs, queries the source database and writes the results to the destination database. You would use any of a number of programming languages in conjunction with libraries that support access to the DBMSs using the given programming language. There are a few GUI tools such as PgAdmin (for Postgresql), which may allow you to connect to multiple DBMS hosts, and may be capable of duplicating all or parts of a database on another DBMS server.
Now, you need to start defining your problem space more clearly. Do as I suggested in my previous post, and identify the various elements of your problem in specific terms. Your question, as posed, is far too vague for anyone to offer any concrete solution.
--- rod.
|
|
|
|
| Thread Tools |
Search this Thread |
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -5. The time now is 10:34 PM.
|
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|