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
co
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 th
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
IL 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_co
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.
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]
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
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 archiv
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]
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:
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]
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
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 hig
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
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: ht
03 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/e
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 P
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]
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]
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 ca
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 ma
) 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 PROTECTE
w 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]
nd 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]
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]>
legant 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: "P
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/
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,
Iuli
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 po
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 fold
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'"
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
>
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:
>
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
hould 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
> S
-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]>; &qu
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 P
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
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
: "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: D
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
I need a correct configure.in file. That file from site cannot be compiled in cygwin.
Please help me.
Iulian
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
43 matches
Mail list logo