Options such as these are set in my.cnf/my.ini (depending on your host
operating system).
innodb_file_per_table is a very useful option but not neccessarily the
best choice for a novice trying to set up replication.
- michael dykman
On Tue, Jul 13, 2010 at 5:43 AM, lejeczek wrote:
> I'm a novi
I'm a novice myself and yes I must say on-line documentation is not easy
nor comprehensive,
let's take this page as an example:
http://dev.mysql.com/doc/refman/5.1/en/replication-howto-rawdata.html
if I don't use InnoDB Hot Backup, doc says..
"..Otherwise, you can obtain a reliable binary snaps
4.x servers are old and should be
> migrated to the recent redhat EL released mysql 5.0.x.
Even 5.0 should be just an intermediate step, given that it is in
"extended support" only.
You didn't specify whether you are with a customer having a contract for
extended support or n
4.x -
>> 5.0.xx)
>
> MySQL 4.X is EOL. I strongly suggest not using it for new projects, if
> you have the option. If possible, MySQL 5.1 is recommended,
Thanks, I'm aware of that. The 4.x servers are old and should be
migrated to the recent redhat EL released mysql 5.0.x.
&g
On Mon, Jun 7, 2010 at 11:59 PM, Götz Reinicke - IT-Koordinator
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 not using it for new proj
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
Shaun Adams schrieb:
> When I perform a dump in mysql5 to mysql 4 DB, I get the error (below).
> Does anyone know how I can resolve this?
>
>
>
> QUERY (windows server from the cmd prompt)
>
> mysqldump --lock-tables --user=root [SOURCE DB] | mysql --user=[USERNAME]
> --password=[PASSWORD] --
When I perform a dump in mysql5 to mysql 4 DB, I get the error (below).
Does anyone know how I can resolve this?
QUERY (windows server from the cmd prompt)
mysqldump --lock-tables --user=root [SOURCE DB] | mysql --user=[USERNAME]
--password=[PASSWORD] --host=[HOST] [TARGET DB]
ERROR MESS
Don't include the password, let mysql prompt for it. ' ./bin/
mysqladmin -u root password -p '.
Daniel Culver
[EMAIL PROTECTED]
On Jan 17, 2007, at 7:57 PM, Mariella Petrini wrote:
./bin/mysqladmin -u root password '***'
./bin/mysqladmin: connect to server at 'localhost' failed
Hi,
After having compiled (debug and optimized version) of MySQL 5.1.14 on
Itanium-2 using icc, I have run
mysql_install_db --user=...
and started mysqld_safe in both scenarios (debug and optimized). In both
cases mysqld starts without any errors.
Unfortunaly when
Dear All,
I am trying to compile MySQL 5.0.27 and 5.1.14 on a shared memory processors
system with 128 processors IA-64 Itanium-2.
I have downloaded the binary version of MySQL-max 5.0.27 Linux IA64 and I have
installed and configured it with no problems.
I need to install also the MySQ
pecially with date fields
> >
> > For example with 4.0.x I do: "select startDate from TEvent" and in my
> > application it is displayed ok(managed with controls), but the same
> > code, same odbc, same control in delphi, etc with mysql 5.0.x it
> > displays: byte ins
s" on each record instance of get
date formated, the column type is datetime(of my table)
Regards!
-Mensaje original-
De: Martijn Tonies [mailto:[EMAIL PROTECTED]
Enviado el: Viernes, 10 de Febrero de 2006 12:51 p.m.
Para: 'Mysql '
Asunto: Re: MySQL 5.0.x and Delphi
example with 4.0.x I do: "select startDate from TEvent" and in my
> application it is displayed ok(managed with controls), but the same code,
> same odbc, same control in delphi, etc with mysql 5.0.x it displays: byte
> instance of the date storaged in my table
What datatype is b
Hi all!
I'm having problems upgrading my database from 4.0.x to 5.0.x, specially
with date fields
For example with 4.0.x I do: "select startDate from TEvent" and in my
application it is displayed ok(managed with controls), but the same code,
same odbc, same control in delphi, etc
I have 2 almost identical SQL statements {copied except 1 is a LEFT join and
the other is an INNER join}.
The INNER join gives me values for all of the fields. The LEFT join gives me
NULL's for all of the prec_... {the LEFT join table} fields.
If the INNER JOIN gives me values and not an empty se
Joerg Bruehe <[EMAIL PROTECTED]> wrote on 07/14/2005 09:35:50 AM:
> Hi!
>
> Jochem van Dieten wrote:
> > On 7/14/05, Joerg Bruehe wrote:
> >
> >>
> >>However, the online manual is not cloned, so while we are building
5.0.9
> >>there can also be new text for 5.0.10 changes that gets integrated
Hi!
Sujay Koduri wrote (in personal mail):
Hi jorg,
DO you have any idea when MySQL 5.0 is going to get into production.
Sujay, please
1) mail such questions to the list, not just to me personally
2) do not post above a full quote, it wastes readers' time, bandwidth,
and disk space.
Re
Hi!
Jochem van Dieten wrote:
On 7/14/05, Joerg Bruehe wrote:
However, the online manual is not cloned, so while we are building 5.0.9
there can also be new text for 5.0.10 changes that gets integrated into
the online manual, and this may become visible earlier than 5.0.9 gets
published.
Wh
On 7/14/05, Joerg Bruehe wrote:
> Rick Robinson wrote:
>
> However, the online manual is not cloned, so while we are building 5.0.9
> there can also be new text for 5.0.10 changes that gets integrated into
> the online manual, and this may become visible earlier than 5.0.9 gets
> published.
Why a
Hi Rick, all!
Rick Robinson wrote:
Just a question on upcoming MySQL 5.0.x releases...what the heck is going on? I
see doc notes for 5.0.8, 5.0.9, and 5.0.10 all concurrently. Is the plan to
merge all these together for a single 5.0.10 release? Or will there be a 5.0.11
that merges all
Just a question on upcoming MySQL 5.0.x releases...what the heck is going on? I
see doc notes for 5.0.8, 5.0.9, and 5.0.10 all concurrently. Is the plan to
merge all these together for a single 5.0.10 release? Or will there be a 5.0.11
that merges all these?
Just curious, as it seems that
Hi there,
Does someone have a MySQL 5.0.x current source build
available for the Win32 platform?
I'm not able to build it myself, but I would like to give the
stored procedures (db specific, not the current MySQL
5.0 Alpha stuff) a try and make Database Workbench
MySQL 5.0 ready...
With re
23 matches
Mail list logo
