Hi,
we do have different LAMP systems and recently I started to put some
mysql databases on one, new master server. (RedHat, Fredora, MySQL 4.x -
5.0.xx)
I did this by exporting some databases with mysqldump and importing tham
on the new server.
Now I'd like to add a slave mysqlserver and so I s
I think even if you ignore the mysql database from replication and set
Is_Deterministic = YES then your stored procedures will be replicated.
Please set it to NO if you do not wish the stored procedures will not
be replicated. You can set this in mysql.proc table.
--
Regards,
Manasi Save
On
SP generally goes as per the database you have created. Set you binlog off
while creating for the sql.
sql_log_bin is the variable to do it.
On Tue, Jun 8, 2010 at 1:01 AM, Sabika Gmail wrote:
> I already have mysql in the replicate wild ingore table. I am running mysql
> 5.1.40sp1
>
> Could i
OK so I managed to open 3306. Now when I connect using 127.0.0.1 from the
intranet box it works, but when I connect using it's IP it's still the same
situation :(
And now when I connect remotely (from my front end which is accessible via
WWW), it says "ERROR 1045 (28000): Access denied for user
'a
Make sure the port is open from the db server. you can test it using "telnet
server 3306(if that's what you use)". If not, have your network admin open the
port for you.
-Original Message-
From: listan...@gmail.com [mailto:listan...@gmail.com]
Sent: Monday, June 07, 2010 3:37 PM
To:
Hello all,
New to MySQL and still exploring. I have MySQL installed on one of the boxes
on the intranet (on which I am not the root) and am trying to connect to it
remotely via a box (that can be see from the "external world").
Unfortunately it does not seem to be working. Here's what I did from t
I already have mysql in the replicate wild ingore table. I am running
mysql 5.1.40sp1
Could it be a bug?
On Jun 7, 2010, at 8:30 AM, Rolando Edwards
wrote:
I think this is normal because stored procedures live in mysql.proc.
You would have to filter out mysql.proc by adding this to /etc
I need some bugs fixed
W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On Jun 7, 2010, at 11:44 AM, Warren Young wrote:
> On 6/7/2010 9:57 AM, Ryan Chan wrote:
>> http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html
>>
>> Since MySQL only support BMP, so in fact 16 bit is needed actually?
>
> I imagine they were thinking they'd extend the support to full Un
On 6/7/2010 9:57 AM, Ryan Chan wrote:
http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html
Since MySQL only support BMP, so in fact 16 bit is needed actually?
I imagine they were thinking they'd extend the support to full Unicode
in the future and didn't want you to have to dump and re
http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html
Since MySQL only support BMP, so in fact 16 bit is needed actually?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
I think this is normal because stored procedures live in mysql.proc.
You would have to filter out mysql.proc by adding this to /etc/my.cnf
replicate-ignore-table=mysql.proc
Rolando A. Edwards
MySQL DBA (CMDBA)
155 Avenue of the Americas, Fifth Floor
New York, NY 10013
212-625-5307 (Work)
201-66
Hi!
I have a database in the wild ignore table as table.%. Recently I
created a store procedure on it and it replicated. Does any one know
if this is normal bahvior? If I wanted to make sure store procedures
do not replicate, what should I do?
--
MySQL General Mailing List
For list archiv
Hiya
Im trying to make use of maatkit as a means of dumping a database and
then restoring to another database.
For dumps: mk-parallel-dump --user abc --password xyz --databases
currentdb --base-dir /tmp/dump
For restore: mk-parallel-restore --create-databases --user abc
--password xyz --da
Does anyone have any sort of any idea on how to deal with this problem?
This is happening again and again and not all the time but randomly anytime.--Regards,Manasi Save
On Wed, 02 Jun 2010 06:46:56 -0400, Manasi Save
wrote:
Dear Venugopal, Here's the Sample
Java Code Which Calls stored procedur
15 matches
Mail list logo
