Re: Server to Server Connection
Oh, I see now!
When you gave the command mysql ... my_database, at the moment of the MySQL
shell, you have the database "my_database" already selected. So all of your
queries works fine because you are in the right database.
In the PHP or other environment, you need to select the database after
connecting and before query.So follow the order:
1. connection with $conn = @mysql_connect($dh,$du,$dp);
2. selecting the database with mysql_select_db("my_database",$conn);
3. performing query $result=db_query($sql);
If you get an error in this step, it's not a PHP/Web matter.
If all works fine, you can use :
mysql_select_db($db,$conn);
in place of
mysql_select_db("my_database",$conn);
If you get an error in the last step, the value of $db is wrong, so check
the webpage which sends the value to $db.
Iulian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Server to Server Connection
Your PHP code for the server 1 is not the same with the code for the server
2 or the names of the tables from MySQL server 1 are not the same with the
value of your PHP queries.
Put the first PHP not-working query in the command-line for server 1 and see
if it works.
Put here the PHP code for the first not-working query.
Add, also, the real names of the MySQL tables used in your lines.
Iulian
- Original Message -
From: "Thomas Deliduka" <[EMAIL PROTECTED]>
To: "m a b" <[EMAIL PROTECTED]>
Sent: Monday, August 18, 2003 5:47 PM
Subject: Re: Server to Server Connection
> The table is in the SQL statement. "Select * from table_name" If you
> really want my code it's very long. I will paste in the stuff that's
> relevant. It's at the bottom.
>
> If it's a PHP matter why does the same code connecting to a 3.23 server
work
> perfectly fine. This same EXACT code works perfectly with the site that
is
> on server 2 (i.e. connecting via localhost NOT server to server).
>
> My code:
> --
> /* This is the code to connect to the database. $dh: host, $du: user,
$dp:
> password, $db: database. Adding debug code showed all information that I
> wanted to pass was correctly passed. */
> if ($config['pconn'] == 1) {
> $conn = @mysql_pconnect($dh,$du,$dp);
> } else {
> $conn = @mysql_connect($dh,$du,$dp);
> }
> if (!$conn) {
> echo "FATAL ERROR: No connection to database.";
> $error = "FATAL ERROR: No connection to database.\nError: " .
> mysql_error() . "\nUsed:\n host: " . $dh . "\n user: " . $dp . "\n
pass:
> " . $dp;
> emailadmin($error);
> exit;
> } else {
> $dbs = @mysql_select_db($db, $conn);
> if (!$dbs) {
> echo "FATAL ERROR: Could not select database.";
> $error = "FATAL ERROR: Could not select database.\nError:
"
> . mysql_error() . "\nUsed:\n host: " . $dh . "\n user: " . $du . "\n
> pass: " . $dp;
> emailadmin($error);
> exit;
> } else {
> return $conn;
> }
> }
> }
>
> /*function for performing the mysql_query() You will notice the commented
> out line there, that is the work-around that I employed to force the
> database name for all the tables (my application uses the xno_ prefix for
> all tables) I should not have to do that. */
>
> function db_query($query, $dconn = false) {
> global $conn, $config;
> if (!$conn) { // if connection isn't there, connect to db
> $conn = db_connect($config);
> }
> if (!$dconn) $dconn = $conn; file://if $dconn is false (not using a
> file://different connection) then set
it.
>
> file://$query = str_replace("xno_",$config["dbname"].".xno_",$query);
> $ret = @mysql_query($query, $dconn);
> echo db_error(0).""; file://my debug code.
> return $ret;
> }
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Server to Server Connection
You have selected my_database as database. What about the table? Put some of
your code to clarify the problem. It's a PHP matter.
Iulian
- Original Message -
From: "Thomas Deliduka" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 18, 2003 5:14 PM
Subject: Server to Server Connection
> I have written this to the PHP-DB list and couldn't get any answers. I
have
> gone through all the documentation I could find. I have been everywhere
and
> cannot find an answer to this problem! Perhaps someone on this list can
> lend me some insight?!
>
> I think, at heart, the problem is with MySQL permissions or some way 4.0
> handles connections across a network, however I just cannot figure it out.
>
> I'm using PHP 4.3.2+MySQL 4.0.14 on server 1
> Server 1, however, is connecting to Server 2 which has MySQL 4.0.12
>
> I have permissions on the 4.0.12 server setup like:
> user:
> localhostuser1 all main privs are 'N' except for "File_priv"
> 192.168.1.% user1 all main privs are 'N' except for "File_priv"
> (internal SAN).
>
> db:
> %user11 my_database all main privs set to "Y" (select,
> insert,update, delete, create, drop, references, index, alter)
>
> If I use the command-line interface from server 1 to server 2 it works
> perfectly fine.
>
> I'm using PHP connection to do code like:
>
> $conn = mysql_connect("192.168.1.2","user1","pass");
> mysql_select_db("my_database",$conn);
>
> mysql_select_db returns true.
>
> My queries are like:
> mysql_query($sql,$conn);
> So I'm using the proper connection.
>
> The webpage mysql_error outputs "select command denied to user:
> '[EMAIL PROTECTED]' for table 'table_name'"
>
> For every table. And I wonder what the heck is this for because the select
> priv is on for that table in the 'db' table.
>
> So, what I did was change the 'user' table with select_priv to "Y" which
> basically make this user a super-user for every table. After doing this I
> get these errors:
>
> Table 'another_database.table_name' doesn't exist.
>
> I didn't select another_database as my table! I selected my_database as my
> table! Why the heck is it selecting the wrong table?!
>
> So, I added a ton of bebugging code. I confirmed that just before calling
> mysql_select_db() I had the right table in the variable. I confirmed I'm
> only making one database connection, not two. I confirmed that this user
> has no permissions for another_database with that user/pass. I confirmed
> the same Reference ID for $conn. Is being used in every case.
>
> I know the reason I'm getting the initial "select command denied" error is
> because it's still selecting another_database for the table and I don't
have
> permissions for that unless I add it for super-user like I did.
>
> A work around (which will not work once I get this site in production) is
to
> do a search/replace on the SQL strings and add "my_database." to every
> database table. Once the SQL command becomes "select xxx from
> my_database.table_name" it works fine but this is not what I can do in the
> end. What the heck could be the problem?! Why doesn't PHP select the
right
> table?!
>
> This problem happens with persistant or non-persistant connections.
>
> Oh, and another site using the same code and the same PHP install (same
> server1) but connecting to a 3.23.xx database works perfectly fine. Just
to
> throw a wrench in the works.
>
> I've been through all of the mysql docs can't find a thing. Do you guys
> know where I'm going wrong?
>
> --
>
> Thomas Deliduka
> IT Manager
> -
> Xenocast
> Street Smart Media Solutions
> http://www.xenocast.com/
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: replication blues
I meant that the solution is to put master_connect_retry=2. When I met this problem, to solve it, I did : 1.stop the slave thread; 2.save the table from the master; 3.drop the table on master; 4.drop the table on slave; 5.reset the master and slave; 6.set master_connect_retry=2; 7.start the slave thread; 8. create the table on master from the saved one. In this way the master and the slave will communicate in better way, so the changes from the master will be instantly replicated. - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 15, 2003 1:04 PM Subject: Re: replication blues > "Primaria Falticeni SDU" <[EMAIL PROTECTED]> wrote: > > I met the same problem > > Problem with auto_increment column? > If so I wasn't able to repeat it with master_connect_retry=2. > > >and I noticed that you need, on the slave, set > > connect_retry to 2 (connect_retry is the time after which the slave retries > > to connect to master). > > It's a replication problem met by me on MySQL 4.0.14 on Linux Red Hat 9. > > > > I manually managed the replication conflicts until then. I mean conflicts > > from the late of the update slave <- master. > > > > Iulian > > - Original Message - > > From: "Victoria Reznichenko" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, August 12, 2003 9:49 PM > > Subject: Re: replication blues > > > > > >> Bogdan TARU <[EMAIL PROTECTED]> wrote: > >> > And data is inserted into it with simple inserts, w/o specifing the id > >> > (it's autoincrementing). > >> > > >> > With a little debugging, I have located the problem. If I run 'alter > >> > table xxx auto_increment=1' on both the master and the slave (this table > >> > is empty at the time on both machines), and then I insert datas into the > >> > master, they look like: > >> > > >> > On master: > >> > > >> > > > +++--+++--+---+- > > ---+ > >> > | 1 | 3 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > >> > | 2 | 4 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > >> > | 3 | 5 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > >> > | 4 | 6 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > >> > | 5 | 13 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > >> > | 6 | 14 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > >> > | 7 | 18 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > >> > | 8 | 19 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > >> > | 9 | 20 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > >> > | 10 | 21 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > >> > +++--+++--+--++ > >> > > >> > But on slave it looks like: > >> > > >> > +++--+++--+--++ > >> > | id | dialer | uid | action | acc_no | template | name | status | > >> > +++--+++--+--++ > >> > | 10 | 3 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > >> > | 11 | 4 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > >> > | 12 | 5 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > >> > | 13 | 6 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > >> > | 14 | 13 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > >> > | 15 | 14 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > >> > | 16 | 18 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > >> > | 17 | 19 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > >> > | 18 | 20 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > >> > | 19 | 21 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > >> > +++--+++--+--++ > >> > > >> > > >> > Why does it start on the id=10 on the slave? Of course, this is the > >> > cause for the replication failures later on, because datas are deleted > > on > >> > the master with 'delete from xxx where id=3', for example, action w
Re: replication blues
I met the same problem and I noticed that you need, on the slave, set connect_retry to 2 (connect_retry is the time after which the slave retries to connect to master). It's a replication problem met by me on MySQL 4.0.14 on Linux Red Hat 9. I manually managed the replication conflicts until then. I mean conflicts from the late of the update slave <- master. Iulian - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 12, 2003 9:49 PM Subject: Re: replication blues > Bogdan TARU <[EMAIL PROTECTED]> wrote: > > And data is inserted into it with simple inserts, w/o specifing the id > > (it's autoincrementing). > > > > With a little debugging, I have located the problem. If I run 'alter > > table xxx auto_increment=1' on both the master and the slave (this table > > is empty at the time on both machines), and then I insert datas into the > > master, they look like: > > > > On master: > > > > +++--+++--+---+- ---+ > > | 1 | 3 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > > | 2 | 4 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > > | 3 | 5 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > > | 4 | 6 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > > | 5 | 13 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > > | 6 | 14 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > > | 7 | 18 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > > | 8 | 19 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > > | 9 | 20 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > > | 10 | 21 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > > +++--+++--+--++ > > > > But on slave it looks like: > > > > +++--+++--+--++ > > | id | dialer | uid | action | acc_no | template | name | status | > > +++--+++--+--++ > > | 10 | 3 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > > | 11 | 4 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > > | 12 | 5 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > > | 13 | 6 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > > | 14 | 13 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > > | 15 | 14 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > > | 16 | 18 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > > | 17 | 19 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > > | 18 | 20 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > > | 19 | 21 | 1007 | REGENERATE | NULL | NULL | NULL | OKAY | > > +++--+++--+--++ > > > > > > Why does it start on the id=10 on the slave? Of course, this is the > > cause for the replication failures later on, because datas are deleted on > > the master with 'delete from xxx where id=3', for example, action which > > doesn't delete anything on the slave (because there is no id=3 entry), > > thus inconsistency. > > > > I'm using 4.0.13 on both machines. > > I wasn't able to repeat it on 4.0.14. Could you provide a test case? What replication options do you use? > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqld_multi don't starts groups on Linux RedHat 9
Hello, mysqld_multi doesn't start the two groups if I gave this command imediately after stopping them. Thanks Anticipated, Iulian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqld_multi don't starts groups on Linux RedHat 9
Hello, mysqld_multi doesn't start the two groups from my.cnf if I give the start command immediately after stopping them. How can I safely start the groups with mysqld_multi anytime (including immediately after stopping them)? Thanks Anticipated, Iulian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqld_multi don't starts groups on Linux RedHat 9
Hello, mysqld_multi doesn't start the two groups if I gave this command imediately after stopping them. It will start only one group. I'm working on Linux RedHat 9 MySQL 4.0.14. How can I solve this problem, please? Thanks Anticipated, Iulian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqld_multi on Linux RedHat 9
Hello, mysqld_multi doesn't start the two groups if I gave this command imediately after stopping them. Thanks Anticipated, Iulian . -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Extensions for MySQL in C not MySQL API
Yes, indeed! Sorry for mistake. I'd like to know functions in MySQL I can use for replacing. For example: in the docs it's writing about xxx_reset "This function is called when MySQL finds the first row in a new group. ". I need the description of such kind of the functions which can be wrapped and the results which can be provided by them. Thank Anticipated, Iulian - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Primaria Falticeni" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, August 04, 2003 7:05 PM Subject: Re: Extensions for MySQL in C not MySQL API > At 16:40 +0300 8/4/03, Primaria Falticeni wrote: > >Hello, > > > >I want to make some extensions for MySQL in C/C++. > >Please give me some samples. I read the documentation but I didn't find > >anything about this. > > > >Thanks Anticipated, > >Iulian > > What do you mean by "extension"? > > If you mean user-defined function, the manual addresses that topic: > > http://www.mysql.com/doc/en/Adding_functions.html > > -- > Paul DuBois, Senior Technical Writer > Madison, Wisconsin, USA > MySQL AB, www.mysql.com > > Are you MySQL certified? http://www.mysql.com/certification/ > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL extension
Hello, Would you help me with some samples for making a MySQL extension in C/C++? Please! Thanks Anticipated, Iulian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Extensions for MySQL in C not MySQL API
Hello, I want to make some extensions for MySQL in C/C++. Please give me some samples. I read the documentation but I didn't find anything about this. Thanks Anticipated, Iulian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to Ask Questions the Smart Way...
Ralph, Yes, indeed. It's a good idea to read this book. Iulian - Original Message - From: "Ralph Guzman" <[EMAIL PROTECTED]> To: "mySQL Mailing List" <[EMAIL PROTECTED]> Sent: Monday, August 04, 2003 11:13 AM Subject: How to Ask Questions the Smart Way... > Maybe the weed has got me high right now, but here is something some of > you on this list may find funny, others may find this useful. This is > not spam, this is actually a good manual you should all read: > > http://catb.org/~esr/faqs/smart-questions.html > > Good Reading. > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem reading my.cnf
Try to not use "#" if you want the password to be in my.cnf file. The "#" is for comments if my.cnf file. - Original Message - From: "Ganbold" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 04, 2003 11:08 AM Subject: Problem reading my.cnf > Hi, > > I have just upgraded mysql server version from 4.0.13 to 4.0.14, from > FreeBSD 5.1 ports collection. > Before upgrade mysql command line client could read password from > /etc/my.cnf file and I could use mysql without supplying -p option. > But after upgrade it could read password only up to # sign. For instance in > /etc/my.cnf file: > > [client] > password= test#istest$ > port= 3306 > socket= /tmp/mysql.sock > > When I issue command mysql --print-defaults it prints: > > mysql would have been started with the following arguments: > --password=test --port=3306 --socket=/tmp/mysql.sock --no-auto-rehash > > > Is this a bug of mysql command line client or it is something different? > Is there anybody who solved this already? > > thanks in advance, > > Ganbold > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL extensions in C
Hello, I read in the docs about the extensions but I didn't met any example. Please, if you could, give me a link or a site with extensions in C/C++ for MySQL. Best Regards, Iulian Teodosiu Economist/software developer Falticeni Municipality -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: show variables
Thank you very much! 1. Is it a way to grow the speed of the replication out of the master-connect-retry variable? 2. I backup the databases. Assuming that the last relay log file is sql-relay-bin.005 and the last bin log file is sql-bin.007, can I simply delete the files from sql-relay-bin.001 to sql-relay-bin.004 and from sql-bin.001 to sql-bin.006? If not, how can I escape by these logs in an elegant way? Respectfully Yours, Iulian - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 31, 2003 1:16 PM Subject: Re: show variables > "Primaria Falticeni" <[EMAIL PROTECTED]> wrote: > > > > How can I see the value of master-connect-retry? show variables doesn't work > > on it. > > Use SHOW SLAVE STATUS command: > http://www.mysql.com/doc/en/SHOW_SLAVE_STATUS.html > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Deleting Duplicate Records
The cleanest way is to add a column (ukey) to the table which will uniquely identify each record. This will help you in the following phases too. Let's say the name of your table is 'focus_table'. 1.adding the unique key 'ukey': ALTER TABLE 'focus_table' ADD COLUMN ukey BIGINT(12) AUTO_INCREMENT PRIMARY KEY; *Now you know what records are remaining after deleting the duplicates and the table will have the same structure. 2.backup your table 3.select the duplicates: CREATE TEMPORARY TABLE dupls SELECT * FROM 'focus_table' GROUP BY field1,field2,... ; *field1,field2,... is the list of the fields which give the duplicates. 4.empty the table: DELETE FROM 'focus_table'; 5.fill it with unique records: INSERT INTO 'focus_table' SELECT * FROM dupls; - Original Message - From: "Cybot" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 31, 2003 11:41 AM Subject: Re: Deleting Duplicate Records > Kim Mackey wrote: > > Group, > > > > I have been working on a project for a while now trying to figure out > > how to remove duplicate records from a single table using a query. To > > complicate matters, what constitutes a duplicate record is a match on > > several fields, but not all fields. I have been successful in matching > > all duplicates based on the fields I'm interested in, but this only > > returns the duplicate records. I want a query that will return all > > records from the table, but only once if certain fields are the same. > > > > The table structure is basically: > > User Code > > Date > > Last Name > > First Name > > Address > > City > > State > > ZIP > > and then some other fields > > > > I don't want to use the values in the other fields to determine if the > > record duplicates another. I'm not concerned about which one of the > > duplicate records I keep because I will make a backup copy of this table > > before removing the duplicates, so I will still have all the data from > > the records deleted. Later I will redesign the tables for this database > > and link back in the data from the other fields. > > > > So I need a method that will output one and only one record from the > > table in which the data in the above mentioned fields are the same. > > Again, even if the data in the remaining fields are different I just > > want one of the records, and I don't care which one. > > CREATE TABLE `new_table` > SELECT * > FROM `old_table` > GROUP BY [your_fields_you_want_unique]; > > -- > Sebastian Mendel > > www.sebastianmendel.de > www.tekkno4u.de > www.nofetish.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A new charset without recompiling
Can I put a new charset or modify an existing one without recompiling MySQL? If yes, please tell me how. Thanks Anticipated, Iulian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
show variables
Hello List, How can I see the value of master-connect-retry? show variables doesn't work on it. Thanks Anticipated, Iulian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
master-connect-retry
Hello, I installed MySQL 4.0.14 on a new Linux machine unde the form of two servers: one master and one slave. I met many unsynchronized events so it was appears conflicts from this late of the changes from master to slave. I put the master-connect-retry to 2. Now it seems to work clearly but I cannot see the master-connect-retry variable with "show variables" command. Is this bad? Shall I have another unsynchronized events in the future between master and slave? I manually repaired each conflict or I did RESET MASTER/SLAVE to escape from the errors' labirint. I want to be sure on my replication. On Windows all worked fine! Iulian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication on Linux RedHat 9 in MySQL 4.0.14
Sorry for was sending HTML. I didn't noticed it. My default was TEXT and now I found HTML in the settings ... maybe because of international chars. I turned it back to TEXT. Hello, I installed MySQL 4.0.14 on a new Linux machine unde the form of two servers: one master and one slave. I met many unsynchronized events so it was appears conflicts from this late of the changes from master to slave. I put the master-connect-retry to 2. Now it seems to work clearly but I cannot see the master-connect-retry variable with "show variables" command. Is this bad? Shall I have another unsynchronized events in the future between master and slave? I manually repaired each conflict or I did RESET MASTER/SLAVE to escape from the errors' labirint. I want to be sure on my replication. On Windows all worked fine! Iulian Teodosiu, Falticeni Municipality -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Please HELP Romanian charset Collate in MySQL
I can copy the latin2.conf into new one, but I need to know what each codefrom the conf file represents and how can I obtain the relation from thesecodes and the chars.So that's two problems:1) Can I use asc function or what function I need to know to obtain thecodes from the chars?2) How is the way to arrange the codes in the conf file? Assuming that Iknow the codes for each characters (found at the above point) how can I putthese codes in the three tables within the latin2.conf file?- Original Message -From: "Primaria Falticeni" <[EMAIL PROTECTED]>To: "MySQL LIST" <[EMAIL PROTECTED]>Sent: Monday, July 28, 2003 10:00 PMSubject: Please HELP Romanian charset Collate in MySQL> Hello,>> Simply I made a table with romanian characters "aAîÎâÂsStT". I tried to> sort> it, in fact to order it in a query.>> I settled the default_charset to some charsets:> latin1(default) (latin2 win1250(central european))> Îte Ibur> Ibur Îte> Ito Ito>> The correct result must be: Ibur, Ito, Îte in ascending order.>> How can I do this? Please give me an example at how can I change the> latin2.conf in a romanian one to fairly sort the chars for me. I must do> change the behaviour and I don't know how.>> Thanks Anticipated,>> Iulian Teodosiu> Economist/Analyst Programmer> Primaria Falticeni> Falticeni (town), jud. Suceava> Romania, Europe>>>> --> MySQL General Mailing List> For list archives: http://lists.mysql.com/mysql> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] smime.p7s Description: S/MIME cryptographic signature
Please HELP Romanian charset Collate in MySQL
Hello, Simply I made a table with romanian characters "aAîÎâÂsStT". I tried to sort it, in fact to order it in a query. I settled the default_charset to some charsets: latin1(default)(latin2 win1250(central european)) ÎteIbur Ibur Îte ItoIto The correct result must be: Ibur, Ito, Îte in ascending order. How can I do this? Please give me an example at how can I change the latin2.conf in a romanian one to fairly sort the chars for me. I must do change the behaviour and I don't know how. Thanks Anticipated, Iulian Teodosiu Economist/Analyst Programmer Primaria Falticeni Falticeni (town), jud. Suceava Romania, Europe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Please URGENTLY Romanian charset Collate in MySQL
Hello, Simply I made a table with romanian characters "aAîÎâÂsStT". I tried to sort it, in fact to order it in a query. I settled the default_charset to some charsets: latin1(default)(latin2(iso-8859-2 I think) the same like win1250(central european)) SteSbur Sbur Ste StoSto The correct result must be: Sbur, Sto, Ste in ascending order. How can I do this? Please give me an example at how can I change the latin2.conf in a romanian one to fairly sort the chars for me. I must do change the behaviour and I don't know how. Thanks Anticipated, Iulian Teodosiu Economis/Analyst Programmer Primaria Falticeni Falticeni (town), jud. Suceava Romania, Europe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Succeeded!!!Two Servers on Windows and ONE my.ini file
Hello, Your solution has succeeded. Thank you very much. All the servers are running well! Iulian Teodosiu, Economist/Analyst Programmer, Primaria Falticeni, Falticeni Town, Romania, Europe - Original Message - From: "Primaria Falticeni" <[EMAIL PROTECTED]> To: "MySQL LIST" <[EMAIL PROTECTED]> Sent: Tuesday, July 22, 2003 10:45 PM Subject: Re: Two Servers on Windows and my.cnf/my.ini groups > > Yes, that's the problem. > Until now I started the two servers from the command line/batch file/service > and each server had its own my.ini. The two servers are in replication: one > master and another slave. Two days ago I read that I can use a unique my.ini > for the both servers; and MySQL for Windows is searching for the ini file in > an unique place. I tried to find that mysqld_multi tool in the MySQL Win > package but no trace of it. > > But the ideea sounded very interesting to me so I tried to find the answer > for Win MySQL in this list. > > Thank you very much, I'm happy to use this elegant and clean solution, > tommorrow I'll put both to start by the unique my.ini file. > > Sincerely, > > Iulian Teodosiu, > Economist/Analyst Programmer, > Primaria Falticeni, > Falticeni Town, > Romania, Europe > > - Original Message - > From: "Paul DuBois" <[EMAIL PROTECTED]> > To: "Primaria Falticeni" <[EMAIL PROTECTED]>; "MySQL LIST" > <[EMAIL PROTECTED]> > Sent: Tuesday, July 22, 2003 10:08 PM > Subject: Re: Two Servers on Windows and my.cnf/my.ini groups > > > > At 20:12 +0300 7/22/03, Primaria Falticeni wrote: > > >Hello and thank you for the info, > > > > > >As I said earlier, I already did the other ways of starting multiple > > >servers. > > >But from these docs I lived with the idea that one/unique my.cnf is able > to > > >start two servers on Windows. > > >Must I see that two configuration files is needed? > > > > I'm not sure what you're asking. Do you mean that you want to run > > two servers as services, and you want to use a single my.cnf file > > to store the options for them? > > > > If so, then you use the approach of specifying a service name after > > the --install option, and using an option group corresponding to the > > service name in the option file. Each server will have a different > > service name, so each server also reads a distinct option group name > > in the option file. > > > > If that's not what you want to do, please clarify. Thanks. > > > > > > > >Iulian > > > > > >- Original Message - > > >From: "Paul DuBois" <[EMAIL PROTECTED]> > > >To: "Primaria Falticeni" <[EMAIL PROTECTED]>; "MySQL LIST" > > ><[EMAIL PROTECTED]> > > >Sent: Tuesday, July 22, 2003 7:51 PM > > >Subject: Re: Two Servers on Windows and my.cnf/my.ini groups > > > > > > > > >> At 19:37 +0300 7/22/03, Primaria Falticeni wrote: > > >> >Hello, > > >> > > > >> >I run two MySQL servers on Windows with the two services. > > >> >I read in the docs that it exists a way to identify the servers in > my.cnf > > >by > > >> >groups and about a tool from Linux to manage the groups. > > >> >How can I start a server on Windows through the my.cnf/my.ini 's > groups? > > >> > > >> If by Linux tool you mean mysqld_multi, it's inapplicable to Windows. > > >> For instructions on running multiple servers on Windows, have a look > > >> in the MySQL manual here: > > >> > > >> http://www.mysql.com/doc/en/Multiple_servers.html > > >> > > >> > > > >> > > > >> >Thanks Anticipated, > > >> >Iulian > > >> > > >> > > >> -- > > >> Paul DuBois, Senior Technical Writer > > >> Madison, Wisconsin, USA > > >> MySQL AB, www.mysql.com > > >> > > >> Are you MySQL certified? http://www.mysql.com/certification/ > > >> > > >> > > >> -- > > >> MySQL General Mailing List > > >> For list archives: http://lists.mysql.com/mysql > > >> To unsubscribe: > > >http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > >-- > > >MySQL General Mailing List > > >For list archives: http://lists.mysql.com/mysql > > >To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > > Paul DuBois, Senior Technical Writer > > Madison, Wisconsin, USA > > MySQL AB, www.mysql.com > > > > Are you MySQL certified? http://www.mysql.com/certification/ > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Two Servers on Windows and my.cnf/my.ini groups
Yes, that's the problem. Until now I started the two servers from the command line/batch file/service and each server had its own my.ini. The two servers are in replication: one master and another slave. Two days ago I read that I can use a unique my.ini for the both servers; and MySQL for Windows is searching for the ini file in an unique place. I tried to find that mysqld_multi tool in the MySQL Win package but no trace of it. But the ideea sounded very interesting to me so I tried to find the answer for Win MySQL in this list. Thank you very much, I'm happy to use this elegant and clean solution, tommorrow I'll put both to start by the unique my.ini file. Sincerely, Iulian Teodosiu, Economist/Analyst Programmer, Primaria Falticeni, Falticeni Town, Romania, Europe - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Primaria Falticeni" <[EMAIL PROTECTED]>; "MySQL LIST" <[EMAIL PROTECTED]> Sent: Tuesday, July 22, 2003 10:08 PM Subject: Re: Two Servers on Windows and my.cnf/my.ini groups > At 20:12 +0300 7/22/03, Primaria Falticeni wrote: > >Hello and thank you for the info, > > > >As I said earlier, I already did the other ways of starting multiple > >servers. > >But from these docs I lived with the idea that one/unique my.cnf is able to > >start two servers on Windows. > >Must I see that two configuration files is needed? > > I'm not sure what you're asking. Do you mean that you want to run > two servers as services, and you want to use a single my.cnf file > to store the options for them? > > If so, then you use the approach of specifying a service name after > the --install option, and using an option group corresponding to the > service name in the option file. Each server will have a different > service name, so each server also reads a distinct option group name > in the option file. > > If that's not what you want to do, please clarify. Thanks. > > > > >Iulian > > > >- Original Message - > >From: "Paul DuBois" <[EMAIL PROTECTED]> > >To: "Primaria Falticeni" <[EMAIL PROTECTED]>; "MySQL LIST" > ><[EMAIL PROTECTED]> > >Sent: Tuesday, July 22, 2003 7:51 PM > >Subject: Re: Two Servers on Windows and my.cnf/my.ini groups > > > > > >> At 19:37 +0300 7/22/03, Primaria Falticeni wrote: > >> >Hello, > >> > > >> >I run two MySQL servers on Windows with the two services. > >> >I read in the docs that it exists a way to identify the servers in my.cnf > >by > >> >groups and about a tool from Linux to manage the groups. > >> >How can I start a server on Windows through the my.cnf/my.ini 's groups? > >> > >> If by Linux tool you mean mysqld_multi, it's inapplicable to Windows. > >> For instructions on running multiple servers on Windows, have a look > >> in the MySQL manual here: > >> > >> http://www.mysql.com/doc/en/Multiple_servers.html > >> > >> > > >> > > >> >Thanks Anticipated, > >> >Iulian > >> > >> > >> -- > >> Paul DuBois, Senior Technical Writer > >> Madison, Wisconsin, USA > >> MySQL AB, www.mysql.com > >> > >> Are you MySQL certified? http://www.mysql.com/certification/ > >> > >> > >> -- > >> MySQL General Mailing List > >> For list archives: http://lists.mysql.com/mysql > >> To unsubscribe: > >http://lists.mysql.com/[EMAIL PROTECTED] > > > > > >-- > >MySQL General Mailing List > >For list archives: http://lists.mysql.com/mysql > >To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > Paul DuBois, Senior Technical Writer > Madison, Wisconsin, USA > MySQL AB, www.mysql.com > > Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Two Servers on Windows and my.cnf/my.ini groups
Hello and thank you for the info, As I said earlier, I already did the other ways of starting multiple servers. But from these docs I lived with the idea that one/unique my.cnf is able to start two servers on Windows. Must I see that two configuration files is needed? Iulian - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Primaria Falticeni" <[EMAIL PROTECTED]>; "MySQL LIST" <[EMAIL PROTECTED]> Sent: Tuesday, July 22, 2003 7:51 PM Subject: Re: Two Servers on Windows and my.cnf/my.ini groups > At 19:37 +0300 7/22/03, Primaria Falticeni wrote: > >Hello, > > > >I run two MySQL servers on Windows with the two services. > >I read in the docs that it exists a way to identify the servers in my.cnf by > >groups and about a tool from Linux to manage the groups. > >How can I start a server on Windows through the my.cnf/my.ini 's groups? > > If by Linux tool you mean mysqld_multi, it's inapplicable to Windows. > For instructions on running multiple servers on Windows, have a look > in the MySQL manual here: > > http://www.mysql.com/doc/en/Multiple_servers.html > > > > > > >Thanks Anticipated, > >Iulian > > > -- > Paul DuBois, Senior Technical Writer > Madison, Wisconsin, USA > MySQL AB, www.mysql.com > > Are you MySQL certified? http://www.mysql.com/certification/ > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Two Servers on Windows and my.cnf/my.ini groups
Hello, I run two MySQL servers on Windows with the two services. I read in the docs that it exists a way to identify the servers in my.cnf by groups and about a tool from Linux to manage the groups. How can I start a server on Windows through the my.cnf/my.ini 's groups? Thanks Anticipated, Iulian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Slave not working....
Try recreate the replication (shut down the servers, copy the master database into the slave place and so on). - Original Message - From: "Jeff McKeon" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Monday, July 21, 2003 7:20 PM Subject: Slave not working > I had a power failure on the master and it bounced rather ungracefully. > Now I'm getting this error on the slave and it's not replicating. Both > are ver 3.23 > > mysql> slave start; > Query OK, 0 rows affected (0.00 sec) > > mysql> show slave status \G; > *** 1. row *** > Master_Host: 10.32.1.10 > Master_User: repli > Master_Port: 3306 > Connect_retry: 60 >Log_File: db01tc0927-bin.035 > Pos: 73 > Slave_Running: No > Replicate_do_db: > Replicate_ignore_db: > Last_errno: 1062 > Last_error: error 'Duplicate entry '245937' for key 1' on query > '%' >Skip_counter: 0 > 1 row in set (0.00 sec) > > ERROR: > No query specified > > How do I fix this? > > Jeff McKeon > IT Manager > Telaurus Communications LLC > [EMAIL PROTECTED] > (973) 889-8990 ex 209 > > ***The information contained in this communication is confidential. It > is intended only for the sole use of the recipient named above and may > be legally privileged. If the reader of this message is not the intended > recipient, you are hereby notified that any dissemination, distribution > or copying of this communication, or any of its contents or attachments, > is expressly prohibited. If you have received this communication in > error, please re-send it to the sender and delete the original message, > and any copy of it, from your computer system. Thank You.*** > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A bug in replication 4.1 Windows version 2000
Hello, About a week ago I created two databases on the master mysql engine while the slave engine was off. After that I tried to start the slave mysql engine and I received an error message and in some seconds the slave service shuts down. After I copied the database from the master database folder to the slave database folder all things went normally and NO error message. So do not create databases on the master when the slave is down. Another problem is: I tried to sort a file on a field with international html codes(õ and so on these codes works on the both charsets of Windows West European and Windows Central European). It correctly sends to me but the order is wrong. Is it because of the "&"? I think I must use direct codes in the database? How can I set in PHP the Romanian charset? In the European ISO there are the other countries but not Romania. Thank you very much, Iulian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: multiple versions of MySql
The most sure way is to keep the same version of server on the same database. If you want to test more versions make one database per server version. Iulian - Original Message - From: "Reggie Burnett" <[EMAIL PROTECTED]> To: "'Primaria Falticeni'" <[EMAIL PROTECTED]> Cc: "'MySQL LIST'" <[EMAIL PROTECTED]> Sent: Wednesday, June 18, 2003 6:37 PM Subject: RE: multiple versions of MySql > No. It complains as well. The error I get > > Can't open file: platforms.InnoDB > > The funny thing is that I have never seen a file ending with Innodb. I > created this table just last night of type InnoDB and the extension was .frm > > Reggie > > > -Original Message- > > From: Primaria Falticeni [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, June 18, 2003 10:31 AM > > To: Reggie Burnett > > Cc: MySQL LIST > > Subject: Re: multiple versions of MySql > > Importance: High > > > > What about the mysql client? Did it report that table exists? > > Test mysqlc from the all versions from your computer. > > > > Iulian > > > > - Original Message - > > From: "Reggie Burnett" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Wednesday, June 18, 2003 6:20 PM > > Subject: multiple versions of MySql > > > > > > > What problems am I going to have with 3.23, 4.0.13, and 4.1 alpha > > installed > > > on the same machine (Win XP?) > > > > > > I am developing some software and wanting to test against these versions > > but > > > I am starting to have intermittent problems with MySql-Front where it > > > declares that a table is now missing. > > > > > > Should I keep the databases separate? I am starting to think that I > > > installed 4.1 alpha last and possibly am using an alpha libmysql and > > that > > is > > > causing the problem. > > > > > > Reggie > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: multiple versions of MySql
What about the mysql client? Did it report that table exists? Test mysqlc from the all versions from your computer. Iulian - Original Message - From: "Reggie Burnett" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 18, 2003 6:20 PM Subject: multiple versions of MySql > What problems am I going to have with 3.23, 4.0.13, and 4.1 alpha installed > on the same machine (Win XP?) > > I am developing some software and wanting to test against these versions but > I am starting to have intermittent problems with MySql-Front where it > declares that a table is now missing. > > Should I keep the databases separate? I am starting to think that I > installed 4.1 alpha last and possibly am using an alpha libmysql and that is > causing the problem. > > Reggie > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lock Tables - Manual Ambiguity
So, when client X has Read lock, the client Y cannot have Write lock, Egor? Iulian - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 18, 2003 1:33 PM Subject: Re: Lock Tables - Manual Ambiguity > "K.L." <[EMAIL PROTECTED]> wrote: > > The 3.23.54 Manual states in; > > > > Section 1.4.4.3 Transactions > > > > "If you only obtain a read lock (as opposed to a write lock), then reads and > > inserts are still allowed to happen. The new inserted records will not be seen > > by any of the clients that have a READ lock until they release their read locks > > " > > > > But in Section 6.7.2 Lock Tables/Unlock Tables Syntax > > > > "If a thread obtains a READ lock on a table, that thread (and all other threads) > > can only read from the table. If a thread obtains a WRITE lock on a table, then > > only the thread holding the lock can READ from or WRITE to the table." > > > > > > What am I missing pls? Can I, with a "READ" Lock, still write to the table? > > Only thread that obtains lock on the table can write to the table. > > > Is the following assumption correct? > > > > "READ" Lock - Thread/Client with Lock, can write to locked Table, and is ONLY > > ONE who can until Lock released. > > Sure. > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Long turn-around time.... and double sending
Yes, in the last day the messages came twice and earlier. Iulian - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Jay Blanchard" <[EMAIL PROTECTED]> Cc: "MySQL LIST" <[EMAIL PROTECTED]> Sent: Wednesday, June 18, 2003 1:38 AM Subject: Re: Long turn-around time > On Tue, Jun 17, 2003 at 03:08:37PM -0500, Jay Blanchard wrote: > > Is anyone else seeing a long turn-around time with their messages going > > to the MySQL list or do I need to check my local mail server (which has > > experienced some hiccups the past couple of days)? > > It doesn't seem to have been that bad recently. But maybe this post > will prove me wrong. > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 4.0.13: up 14 days, processed 469,979,927 queries (371/sec. avg) > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: I wonder why nobody answered me
Thank you very much! I was worried because I posted the first question about a week ago twice. And guess why I am interested in 5.0? Because of the sweet triggers. I compiled the rest of the folders of 5.0 version. I like this list and MySQL. Respectfully Yours, Iulian - Original Message - From: "Becoming Digital" <[EMAIL PROTECTED]> To: "MySQL LIST" <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 9:54 PM Subject: Re: I wonder why nobody answered me > > Why nobody answered me? > > I posted two questions on this list. > > 1. I have a problem with MySQL 5.0 Tree compiling. The configure after I > > launched configure.in made an error. > > Probably because there are very few people using MySQL 5.0 and we don't have an > answer. > > > > 2. How could I make accumulated sums in MySQL (described in the actual > > forwarded message) > > You asked that question five hours ago. If you want immediate support, you'll > have to pay MySQL AB for it. The downside to free stuff is that you often have > to wait a bit. You've got two replies now, though, so that should satisfy you. > > Edward Dudlik > Becoming Digital > www.becomingdigital.com > > > - Original Message - > From: "Primaria Falticeni" <[EMAIL PROTECTED]> > To: "MySQL LIST" <[EMAIL PROTECTED]> > Sent: Tuesday, 17 June, 2003 12:50 > Subject: I wonder why nobody answered me > > > Why nobody answered me? > I posted two questions on this list. > 1. I have a problem with MySQL 5.0 Tree compiling. The configure after I > launched configure.in made an error. > 2. How could I make accumulated sums in MySQL (described in the actual > forwarded message) > > > - Original Message - > From: "Primaria Falticeni" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, June 17, 2003 5:48 PM > Subject: How the Partial SUMs are made in MySQL > > > Hello, > > I need one complex query which makes partial sums on some dates. > > Let's get the structure of table rates: Day Date, Amount. > 01/05/20033,000 > 01/06/20032,000 > 01/09/20034,000 > > > > SELECT Day as DayF,SUM(Amount) as S_Am FROM rates GROUP BY Day > > gives the list of totals each one from a day: > DayFS_Am > 01/05/20033,000 > 01/06/20032,000 > 01/09/20034,000 > > > > I need the sum of the Amount from the beginning of the file until each > day...something like SUM(Amount FOR Day > DayFS_Am > 01/05/20033,000 > 01/06/20035,000 (I mean 3,000 on 01/05/2003 + 2,000 on 01/06/2003) > 01/09/20039,000 (I mean 4,000 on 01/09/2003 + 3,000 on 01/05/2003 + > 2,000 on 01/06/2003) > > > How can I do this in MySQL queries? > > Thanks in advance, > Iulian > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Triggers
I like triggers and I'm anxiously waiting for them but only when the 5.0 version will be for production. I spoke from the risk point of view of a new version. Also, in C/C++ we can make precompiled triggers which can hide the tables only until the MySQL 5.0 version will be ready. The server-side scripts doesn't appear in the client Web page code. With Respects, Iulian - Original Message - From: "Roman Neuhauser" <[EMAIL PROTECTED]> To: "Primaria Falticeni" <[EMAIL PROTECTED]> Cc: "Kerry Colligan" <[EMAIL PROTECTED]>; "MySQL LIST" <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 10:05 PM Subject: Re: Triggers > # [EMAIL PROTECTED] / 2003-06-17 21:28:12 +0300: > > From: "Kerry Colligan" <[EMAIL PROTECTED]> > > > I see that 5.x will support triggers. Does anyone have any advice for > > > implementation of triggers on the DB? I will need to be able to utilize > > > them from web applications AND from command-line type interface. Any > > > suggestions welcome at this point. (RH 7.3, MySQL 3.23.56 presently) > > > > Why don't you use PHP or ASP functions on the server-side in Web page code. > > They act like a trigger and you don't need MySQL 5.0 for them. Remember that > > you can benefit from the both servers: MySQL and Web server. > > I think the OP has made himself clear enough: there'll be two access > paths to the database, and command line use with ad-hoc queries is > most likely to cause RI damage; triggers are a way to avoid this > risk. > > I would however (probably) prefer hiding the tables behind a set of > stored procedures. Usually, they have a few advantages: > > * they don't slow the RDBMS down by triggering the... errr... > triggers > * they're stored "precompiled", so you avoid the parser overhead of > ad-hoc queries > * you can make them the only access point to the data, allowing you > to know (or trust :) that there'll be no random problems of the > "oh wait, I forgot to put WHERE in that UPDATE!" variety > > -- > If you cc me or remove the list(s) completely I'll most likely ignore > your message.see http://www.eyrie.org./~eagle/faqs/questions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Triggers
Use PERL to make a script which acts like a trigger. It can be launched from the command line. Iulian - Original Message - From: "Kerry Colligan" <[EMAIL PROTECTED]> To: "MySQL LIST" <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 9:46 PM Subject: RE: Triggers > I think I mentioned this. The problem is, I need reproducible results from > both web interface AND command line. If I implement the triggers in PHP, I > only get the results from the web. > KC > > -----Original Message- > From: Primaria Falticeni [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 17, 2003 2:28 PM > To: Kerry Colligan > Cc: MySQL LIST > Subject: Re: Triggers > Importance: High > > > > Why don't you use PHP or ASP functions on the server-side in Web page code. > They act like a trigger and you don't need MySQL 5.0 for them. Remember that > you can benefit from the both servers: MySQL and Web server. > > - Original Message - > From: "Kerry Colligan" <[EMAIL PROTECTED]> > To: <> > Sent: Tuesday, June 17, 2003 9:10 PM > Subject: Triggers > > > > I see that 5.x will support triggers. Does anyone have any advice for > > implementation of triggers on the DB? I will need to be able to utilize > them > > from web applications AND from command-line type interface. Any > suggestions > > welcome at this point. (RH 7.3, MySQL 3.23.56 presently) > > > > Thanks > > > > -- > > Kerry > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Remote access to MySQL
Yes, indeed. You don't have a firewall. But the firewall from the Internet Service Provider's computer prohibits the access of the others users from the Internet to the port of your MySQL server. Or you are in a private network which must use IP port forwarding to be reached from the Internet. Talk with your ISP to give all others, from the Internet, access to your MySQL port. The poor Windows is not guilty for this. It has too much guilty for the other problems... Good Luck, Iulian - Original Message - From: "Renato" <[EMAIL PROTECTED]> To: "Becoming Digital" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 9:11 PM Subject: RES: Remote access to MySQL > >> I have all privileges to all the databases and tables, with user 'root'. > >User 'root' likely doesn't have access from the desired IP. > >Users are configured by both name and approved hosts. Try this: > >GRANT ALL ON database TO [EMAIL PROTECTED] IDENTIFIED BY 'password'; > >Edward Dudlik > >Becoming Digital > >www.becomingdigital.com > > > I have all grant statements: > GRANT ALL PRIVILEGES ON *.* to root@'%' IDENTIFIED BY 'password'; > GRANT ALL PRIVILEGES ON *.* to [EMAIL PROTECTED] IDENTIFIED BY 'password'; > GRANT ALL PRIVILEGES ON *.* to [EMAIL PROTECTED] IDENTIFIED BY 'password'; > FLUSH PRIVILEGES; > > Still not working... > Do you know if Win98 have some trouble receiving telnet commands? > > Thanks again. > > Regards, > Renato Uchoa > [EMAIL PROTECTED] > > - Original Message - > From: "Renato" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, 15 June, 2003 19:28 > Subject: Remote access to MySQL > > > I have installed MySQL in Win98SE, with connection ASDL and Fixed IP. > > In the same machine, works web server (Apache2+PHP) and e-mail e ftp server. > > Everything works perfectly accessing from my INTRANET (local network). I > obtain access to MySQL without problems. > > In Internet, all servers works perfect, except MySQL. Always I get error of > access when use: > > mysql - h xx.xx.xx.xx - u root - p > ERROR 2003: Can't connect you the MySQL server on 'xx.xx.xx.xx' (10060) > > Informations: > > * I don't have any firewall > * I have all privileges to all the databases and tables, with user 'root'. > * I have pleny access to the 'server' machine. > * Telnet 'xx.xx.xx.xx:3306 ' also doesn't answer on Internet - In local > network, the reply is positive, what confirms server is on > * I work with PHP and I have access to Mysql with PHP programming, never > directly. > * I use 'mysqld.exe', as MySQL server, without any special configuration in > my.ini: > [WinMySQLAdmin] > Server=C:/MYSQL/bin/mysqld.exe > [mysqld] > basedir=C:/MYSQL > datadir=C:/MYSQL/data > > Summarizing: I can't access to the Mysql from Internet! > > Some additional suggestions? > > Regards, > Renato Uchoa > [EMAIL PROTECTED] > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Triggers
Why don't you use PHP or ASP functions on the server-side in Web page code. They act like a trigger and you don't need MySQL 5.0 for them. Remember that you can benefit from the both servers: MySQL and Web server. - Original Message - From: "Kerry Colligan" <[EMAIL PROTECTED]> To: <> Sent: Tuesday, June 17, 2003 9:10 PM Subject: Triggers > I see that 5.x will support triggers. Does anyone have any advice for > implementation of triggers on the DB? I will need to be able to utilize them > from web applications AND from command-line type interface. Any suggestions > welcome at this point. (RH 7.3, MySQL 3.23.56 presently) > > Thanks > > -- > Kerry > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I wonder why nobody answered me
Why nobody answered me? I posted two questions on this list. 1. I have a problem with MySQL 5.0 Tree compiling. The configure after I launched configure.in made an error. 2. How could I make accumulated sums in MySQL (described in the actual forwarded message) - Original Message - From: "Primaria Falticeni" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 5:48 PM Subject: How the Partial SUMs are made in MySQL Hello, I need one complex query which makes partial sums on some dates. Let's get the structure of table rates: Day Date, Amount. 01/05/20033,000 01/06/20032,000 01/09/20034,000 SELECT Day as DayF,SUM(Amount) as S_Am FROM rates GROUP BY Day gives the list of totals each one from a day: DayFS_Am 01/05/20033,000 01/06/20032,000 01/09/20034,000 I need the sum of the Amount from the beginning of the file until each day...something like SUM(Amount FOR Dayhttp://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How the Partial SUMs are made in MySQL
Hello, I need one complex query which makes partial sums on some dates. Let's get the structure of table rates: Day Date, Amount. 01/05/20033,000 01/06/20032,000 01/09/20034,000 SELECT Day as DayF,SUM(Amount) as S_Am FROM rates GROUP BY Day gives the list of totals each one from a day: DayFS_Am 01/05/20033,000 01/06/20032,000 01/09/20034,000 I need the sum of the Amount from the beginning of the file until each day...something like SUM(Amount FOR Day
Compiling MySQL 5 Tree
I need a correct configure.in file. That file from site cannot be compiled in cygwin. Please help me. Iulian
Making MySQL 5.0 Source Tree
Hello, I gave the follow commands to make the binary form in cygwin: autoconf configure.in ./configure and the messages were: loading cache ... bla bla bla checking build system type... i686-pc-cygwin configure: 724: Syntax error: word unexpected (expecting ")") Maybe the cause is the linefeeds conversion from UNIX to DOS. I need help to be able to compile MySQL 5.0 source tree. Sincerely Yours, Iulian Information System Officer/Economist Falticeni, jud. Suceava Romania, Europe
