of whether it is for MyISAM or
> InnoDB, will come through during a mysqldump.
>
>
> ------
>
> *From:* Mark Maunder [mailto:[EMAIL PROTECTED]
> *Sent:* Tuesday, August 05, 2008 12:17 PM
> *To:* Rolando Edwards
> *Cc:* mysql@lists.mysql.com
>
h during a mysqldump.
From: Mark Maunder [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2008 12:17 PM
To: Rolando Edwards
Cc: mysql@lists.mysql.com
Subject: Re: Possible bug in mysqldump?
Thanks for the reply Rolando.
In both the examples I provided (pipe and t
se --master-data in the mysqldump
>
> 5) In mysql session 2, run "CHANGE MASTER TO MASTER_LOG_FILE=' from SHOW MASTER STATUS>,MASTER_LOG_POS=' STATUS>';"
>
> 6) In mysql session 2,run 'START SLAVE'.
>
> 7) In mysql session 1, run 'UNLOCK TA
5) In mysql session 2, run "CHANGE MASTER TO MASTER_LOG_FILE=',MASTER_LOG_POS='';"
6) In mysql session 2,run 'START SLAVE'.
7) In mysql session 1, run 'UNLOCK TABLES'
Give it a try !!!
-Original Message-
From: Mark Maunder [mailto:[EMAIL PROTECTED]
Se
Hi all,
I'm busy setting up replication and have encountered what looks like a bug
in mysqldump. The following commands work perfectly:
Running the following commands in the mysql client on the slave:
stop slave;
reset slave;
create database dbName;
CHANGE MASTER TO MASTER_HOST='
[I searched the bug database...please let me know if I missed an already filed
or fixed bug.]
I am trying to dump a database from MySQL 4.0.24 using the client tools from
5.0. Debian server, Ubutnu 6.06 client.
I use this command line (watch for wrap):
mysqldump -u jkugler -p -h
dbserver --a
I have been running into problems with mysqldump. I have not been able to figure out
why mysqldump isnt working as I hope it would. Anyway I thought I'll make the
mysql-list aware of the problem and hopefully it will help someone. Or better yet
someone knows what I am doing wrong and could point
On 29 Sep 2003 at 20:47, Lorenzo Sicilia wrote:
> when I use mysqldump the database name is write:
> design-network instead "design-network"
If you have odd characters in your names, then you need to use the
--quote-names option on mysqldump, so that it puts backticks around
them.
--
Keith C
I have a database with the name design-network
when I use mysqldump the database name is write:
design-network instead "design-network"
in table name, field name, etc all work fine.
The dump finish correctly but when I try use generated SQL I get an
error. The problem is "-".
Other dump tool (e
I just noticed that mysqldump -d outputs
/*!4 ALTER TABLE equity_ind1 DISABLE KEYS */;
at the end of the dump of the table def...
If I understand this correctly... this will be executed
by any version of mysql version 4 and up...
That would be fine, except that since it is not dumping
ped.
>
> >How-To-Repeat:
>
> >Fix:
>
>
> >Submitter-Id:jonash
> >Originator:
> >Organization: Gatespace AB
>
> >MySQL support: none
> >Synopsis:Bug in mysqldump
> >Severity:serious
> >Priority: me
space AB
>MySQL support: none
>Synopsis: Bug in mysqldump
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.37 (Source distribution)
>Environment:
System: SunOS crocodile.crt.se 5.7 Gen
12 matches
Mail list logo
