Linux - ServerThis forum is for the discussion of Linux Software used in a server related context.
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.
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?
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..
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.
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.