I notice in the startup messages there is an underscore in the file
names, but there are dashes in the dir list you provided. ???
On 3/26/09, Dirk Bremer wrote:
> On the master in the directory specified in the my.ini on the master,
> there are seven log-files:
>
>
> D:\Logs>dir mysql*.*
> Volum
On the master in the directory specified in the my.ini on the master,
there are seven log-files:
D:\Logs>dir mysql*.*
Volume in drive D is Local Disk
Volume Serial Number is A46F-D8E7
Directory of D:\Logs
2009-03-25 00:1738,366,715 mysql-bin.01
2009-03-25 00:17 19
Hi Dirk,
it seems that the information about binary files on the master contained
in the mysql-bin.index does not match the actual files on the disk.
The first two log messages are just info on the slave starting the two
replication threads,
the other two seem to be a message coming from the mas
Most likely something is wrong in your AMSCD2-relay-bin.index file.
Check this out:
http://forums.mysql.com/read.php?26,9390,242387#msg-242387
Walter Heck
On Thu, Mar 26, 2009 at 10:02 PM, Dirk Bremer wrote:
> Could not find
> first log file name in binary log index file
--
MySQL General Ma
We recently completed a project where all of our production servers were
replaced. As part of this project, one of the new servers acted as a
replication-slave to one of the old servers, which was the
replication-master. I had replication up and running just fine on
multiple slaves for a couple of
Hi,
Alpha version 5.08 of the BLOB streaming engine for MySQL has been released.
The BLOB Streaming Engine is a MySQL storage engine which enables the
storage and streaming of BLOB data directly in and out of a MySQL database.
You can download the source code from http://www.blobstreaming.org/d
The table mysql.proc always contains the hard code of stored procedures and
functions.
Triggers in 5.0 are stored in a .TRG file
Make sure, if you used mysqldump, to include --triggers as a dump option
Rolando A. Edwards
MySQL DBA (CMDBA)
155 Avenue of the Americas, Fifth Floor
New York, NY 100
In the last episode (Mar 26), Cui Shijun said:
> It seems that the stored functions isn't stored in a seperated file
> like trigger does.
> Where are them?
> If I copy the database directory from a server to another, can I get
> the same functions on the both servers?
They're stored in the m
In the last episode (Mar 26), Riccardo Michele Filippone said:
> Hello! First of all sorry for my terrible english.
>
> Well I've a big problem with ibdata1, this damn file increase its size
> constantly.
>
> I tryed to use innodb_file_per_table... but:
>
> - MySQL create a lot of ibd files fo
forgot the list, sorry :)
Walter Heck
-- Forwarded message --
From: Walter Heck - OlinData.com
Date: Thu, Mar 26, 2009 at 2:09 PM
Subject: Re: A problem relative ibdata1
To:
Cc: Riccardo Michele Filippone
Riccardo,
if you're ibdata1 file is growing fast, it means you are inse
Hi Riccardo,
I don't think you should need any other storage engine if you need foreign
keys.
InnoDB is by far the most used, standard, transactional, foreign
key-supporting MySQL storage engine.
No other valid option comes to my mind now.
But please share your needs and let's see if I am wrong
hi,
It seems that the stored functions isn't stored in a seperated file
like trigger does.
Where are them?
If I copy the database directory from a server to another, can I get
the same functions on the both servers?
Thank you.
--
MySQL General Mailing List
For list archives: http://lists
You can't!
it is part of the datafiles of InnoDB storage engine!
and It contains important data like the information schema.
So I would rather ask you, is it abnormally growing or is it just your
feeling?
You should be more precise to have good answers,
for instance how much megabytes per minu
Hello! First of all sorry for my terrible english.
Well I've a big problem with ibdata1, this damn file increase its size
constantly.
I tryed to use innodb_file_per_table... but:
- MySQL create a lot of ibd files for all DB (correct)
- ibdata1 is however created and increase its size...
how
I had the same problem and was going crazy,
the ket/foreign key fields must be exactly the same.
I 'forward' engineered the database with MySQL Workbench and was almost
posting a bug!
Cheers
Claudio
2009/3/26 John Daisley
> Sorry all, I was being a dummy! Missed the unsigned attribute off th
Sorry all, I was being a dummy! Missed the unsigned attribute off the
foreign key columns on the problem tables.
Regards
> Hi,
>
> I have the script below to create 5 tables. Three of them create fine but
> two return an error of 150 which I understand to be a foreign key issue,
> however I can'
Hi,
I have the script below to create 5 tables. Three of them create fine but
two return an error of 150 which I understand to be a foreign key issue,
however I can't see anything wrong with the foreign key statements.
Could someone possibly have a look and see if they can identify the issue
plea
17 matches
Mail list logo
