Thanks lakshmi
On Wed, Jan 21, 2009 at 11:53 AM, lakshmi pathi wrote:
> Hi Krishna Chandra Prajapati,
>
> >How can i customize, to make it work on debian OS
>
> After months of search finally yesterday i got debian - Lastnight i
> tested giis binary with
> debian -- yes running binary version gav
You can embedded the result of mysql into the below script.
\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "\t\n";
foreach ($line as $col_value) {
echo "\t\t\t$col_value\n";
}
echo "\t\n";
}
echo "\n";
// Free resultset
mysql_free_result($result);
//
ERROR: not null column cannot be updated with null value. This error is
catched by server C mysql 5.1.30 but not my server B mysql 5.0.32
In production we have three servers.
A> B -C
A is replicating to B. B is replicating to C
A mysql-5.0.32 (Write)
B
Hi Krishna Chandra Prajapati,
>How can i customize, to make it work on debian OS
After months of search finally yesterday i got debian - Lastnight i
tested giis binary with
debian -- yes running binary version gave me an Error as "Floating Exception"
Then i tried to compile it from source it wor
Hello mysql,
I would like to run a PHP script to perform a CRON Database backup to
avoid passing database credentials to the CRON process. Does this make
sense?
What are the recommended MySQLDump options that should be used in
script and interactive? I am currently only using --opt but should I
b
I'm trying to diagnose this and not having much luck. I can't even
figure out where to even begin to look. I have two MySQL servers and
getting different results for the same query on both:
SERVER 1:
mysqladmin Ver 8.41 Distrib 5.0.37, for pc-linux-gnu on i686
SERVER 2:
While specing out a new server, I was wondering if there is any limit to how
much memory can be allocated to mysql 5.1. If a server has 16GB of ram, can
mysql take advantage of that much ram (minus a reserved amount for the OS
obviously)? Is there any limit such as those imposed by 32-bit proc
What error is shown by 'show slave status\G' on server C after you
issue that query?
There's all sorts of things that could break replication...
On Tue, Jan 20, 2009 at 7:21 AM, Krishna Chandra Prajapati
wrote:
> Hi Baron,
>
> In production we have three servers.
>
> A> B ---
Yes
On Tue, Jan 20, 2009 at 7:40 PM, wrote:
> Hi Krishna,
>
> I just tried the -X and -H options as you described. Works fine.
> Is it also possible to get -X or -H data from MySQL into PHP ?
>
> TIA, Cor
>
> - Original Message - From: "Krishna Chandra Prajapati" <
> prajapat...@gmail.co
Hi Baron,
In production we have three servers.
A> B -C
A is replicating to B. B is replicating to C
A mysql-5.0.32 (Write)
B mysql-5.0.32 (Read)
C mysql-5.1.30 (Report Server) Complex and big queries scanning all
data.
*ISSUE*: If any query
Hi,
You can use -X for xml and -H from html. See the example below.
debian76:~# mysql -h 192.168.1.10 -u teen -D teen -pteen -X
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Command
Hi Everyone
I am interested in how to get an XML request to query a database. I'm working
on generating the XML requests OK, I just need to know how XML meets database.
Are there any generalised pointers to begin with?
Thanks in advance
Jonathan Trahair
12 matches
Mail list logo
