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 sabika.makhd...@gmail.comwrote:
I already have mysql in the replicate wild ingore table. I am running
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
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
Devart
Email: i...@devart.com
Web: http://www.devart.com
FOR IMMEDIATE RELEASE
CONTACT INFORMATION:
Julia Samarska
jul...@devart.com
08-Jun-2010
Greatly Enhanced LINQ Capabilities in Devart ADO.NET Data Providers
Devart has recently announced the release of dotConnect products for Oracle,
On Mon, Jun 7, 2010 at 11:59 PM, Götz Reinicke - IT-Koordinator
goetz.reini...@filmakademie.de wrote:
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)
MySQL 4.X is EOL. I strongly suggest
Hi,
On Tue, Jun 8, 2010 at 12:44 AM, Warren Young war...@etr-usa.com wrote:
The Unicode consortium has stated that Unicode will
never require more than 21 bits per character[*], and 24 bits is the next
even multiple of 8 up from that.
Maybe off topic, but just curious...If 3 bytes is enough
If you only allow local connection, your setup should works, otherwise, you
need to specify from which host you allow the connection in your grant
statement. I think you need a DNS entry for your first question, not so sure
about the question.
From: Andy [mailto:listan...@gmail.com]
Sent:
I am receiving this error:
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to you MySQL server version for the right syntax to use near '16
varchar(255) NOT NULL default 'Not applicable', 17a varch
I have version 4.0.16 and have a dump file that I'm
Hi Brad,
2010/6/8 Brad Scott outlawsco...@hotmail.com:
[...]
Any line beginning with just a number (ie 9, 10, 16) causes a failure. What
am I missing?
you should add backticks ( ` ) at both ends of the column name, e.g.
`7c` varchar(255) NOT NULL default '',
I think your export should have
Brad Scott skrev:
Any line beginning with just a number (ie 9, 10, 16) causes a failure. What am
I missing?
backticks. Use `9`, `10`, etc.
Having column names that begin with numbers is a really bad design
decision. 9a123 (unquoted, of course) will work, as you've noticed,
but e.g.
Good morning all
I would like to try and find out how you can see what is using the
query cache.
My reason for asking is the following:
On one of our client databases, the query cache is set to
128Mb and the usage always varied between 5% and 53%
11 matches
Mail list logo