Re: Looking for a bona fide distributed database that is open source
My experience may be limited but I don't know of any database that will allow a single query to access mutiple database servers In fact, only a few seem to be able to even access mutiple databases on the same server Frankly, I am still looking for a db that provides n way replication (this may solve some of your wishes since a local copy could be maintain on your local server) Paul DuBois ([EMAIL PROTECTED]) wrote: At 9:55 -0500 3/14/03, Bruce Feist wrote: Gelu Gogancea wrote: To anyone that *didn't see the forest because of the trees*. You already find it. Is MySQL really distributed, or just client-server? I've seen no indication of distributed capabilities; I'm new to MySQL, so maybe I just haven't read enough. But a distributed DBMS should be able to execute a single query which transparently accesses multiple database installations on multiple computers, possibly on multiple platforms. For instance, SELECT * from a, b ON a.id = b.id; where table 'a' is in a database on a Windows/2000 computer and table 'b' is on a Linux machine. The DBMS should keep track of which table is in which database on which computer, and its optimizer should be capable of figuring out an efficient way of resolving such queries. Can MySQL do that? Bruce Feist No. A given connection is a connection to a specific server. You cannot access tables managed by different servers within a single query. - Original Message - From: james [EMAIL PROTECTED] Sent: Thursday, March 13, 2003 4:44 PM I am looking for a bona fide distributed database system, like Oracle or SQLServer, but open source running on Linux. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Brian Johnson This is where my witty signature line would be if I bothered to edit this line :) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ERROR 2002
Locate the mysql.sock file and create a symbolic link to the /var/lib/mysql/mysql.sock file. :) - Brian J. -Original Message- From: Tomasz Krasiel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 04, 2003 6:56 AM To: [EMAIL PROTECTED] Subject: ERROR 2002 I installed MySQL 3.23.54 on RedHat 8.0. The installation ran smoothly ; but when trying to start MySQL, from the terminal this appeared communiqué: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) What I should to do? Thanks in advance to all who reply! Best regards, Tomasz Krasiel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access replacement...
That looks like a windows-only solution John Ragan ([EMAIL PROTECTED]) wrote*: i've been hesitant to respond because i'm not sure that this is a head on solution for you, but take a look at http://corereader.com it's certainly easier to use than access queries. simple point and click to build complex output. however, it's not designed for the fancy formatted output to which your folks are accustomed. it'll do text, browser, schema xml, and html, but it's all (intentionally) plain vanilla. Brad wrote: A programming environment; Python comes to mind immediately; very easy to learn, especially compared to VB, and its even Windows compatible (MFC even). A database maintenance utility; To what end? A database query tool; Visual query tools exist for MySQL already; someone keeps posting the name of one from time to time ... A report builder Any report program that works from ODBC will work. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access replacement...
I've been looking at a similar scenario Here is what I've arrived at so far: There is little that rivals the ease of use of MS Access - but most alernatives offer different features (like security, performance improvement, and other database related functions) that make the loss of ease of use bearable. The closest open source system to Access that I have seen is Openoffice - it isn't yet very well documented but there is a powerful database frontend system lying under the hood of that suite. You still need a separate database to store the info, but there is a form design tool and a query design tool similar to MS Access and something similar to reports can be made by using the mail merge function to pull info from the database. As for database backend, I've had trouble finding something that is as portable as MS Access. The main open source databases (MySQL and PostgreSQL) have replication functions to provide off-line access to the databases but they too have limitations (eg you have to set up the database server software, and maintin it, on the remote client as well as the central server). There are some db formats that save the data in a file that can be transferred to other systems, but then you lose some of the advantages as well (I haven't played with these systems) Keep us posted on what you find Brad ([EMAIL PROTECTED]) wrote*: I am thinking of a move from a Windows network to Red Hat Linux at my work. I am happy with OpenOffice for spreadsheets, word processing etc but the main problem is replacing MSAccess. MySQL provides a replacement for the database component but that still leaves: A programming environment; A database maintenance utility; A database query tool; A report builder Some of our users have had MSAccess training and are quite proficient in producing simple but usable applications involving: The creation of a database and tables; Forms to populate the database; Queries and reports to display the data. All this in a graphical interface without needing to know SQL or doing any serious programming. They would need to be able to continue doing this in the new Linux environment - is there a suitable Forms utility? We also have some serious applications written in MSAccess by outside professional programmers. This was partly done to allow the simpler changes (eg reports and screen layouts) to be made by the advanced users in order to reduce costs and delays. I would assume that a Forms utility would not provide enough features to be used here. Does this mean that development has to be done in the opensource equivalent of VB which may shut out the advanced users from making changes? Regards, Brad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to create a sequence for an id field
I have a SQL statement to create a PostgreSQL table that include a line 'id serial' This line creates a integer field with a sequence atached to it to create an autonumber Is there a way to create a SQL statement to accomplish this that would work with both MySQL and PostgreSQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
laptop configuration/replication
Is it practical to use the builtin MySQL replication to have a MySQL server on a laptop that syncs to the LAN Database Master when it is connected? Are there any configuration issues that I should be aware of? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
hello
Dear Sirs Hello, i have questions on mysql i create a table and i create an index key in it i want to know how can i know in mysql if the date that i import it into the table are fully indexd. please reply. best regards. nabil jaber. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php