www.centos.org - Forums - CentOS 5 - Server Support - mysqldump different on 32bit vs. 64bit?

www.centos.org Forum Index

CentOS 5 - Server Support

mysqldump different on 32bit vs. 64bit?

Bottom

Previous Topic

Next Topic

Topic options

Rate Thread

Rate this Thread
Excellent Good Average Bad Terrible

Search Forum

Search Forum

Advanced Search

View mode

View mode
Threaded
Oldest First

Poster	Thread

TrevorH

Re: mysqldump different on 32bit vs. 64bit?

Moderator

Joined: 2009/9/24

From Brighton, UK

Posts: 6306

It just means that you have binary logging turned on on one server and not on the other

_________________
Linux/VoIP Systems Administrator

Posted on: 2012/1/24 12:00

knebb

mysqldump different on 32bit vs. 64bit?

Newbie

Joined: 2011/10/24

From

Posts: 5

Hi all,

I'm having a strange issue with mysqldump.

I've two MySQL servers running independend from each other. One is CentOS 5.7 32bit and the other is CentOS 5.7 64bit. RPM command shows both are same versions:

[root@mysqla ~]# rpm -qa|grep mysql
mysql-5.0.77-4.el5_6.6
php-mysql-5.1.6-27.el5_7.4
mysql-server-5.0.77-4.el5_6.6

And:

[root@mysqlb ~]# rpm -qa|grep mysql
perl-DBD-mysql-4.012-1.el5.rf
mysql-server-5.0.77-4.el5_6.6
mysql-5.0.77-4.el5_6.6

My script looks like this:

[root@mysqla ~]# cat backup_mysql.sh
#!/bin/bash
mysqldump -v --opt --master-data --lock-all-tables --triggers --routines --flush-logs --delete-master-logs  -u root -pxXxXx --all-databases > mysql.dump

On host a this runs fine, host b it connects but does not dump anything.

Being in mysql it shows different versions:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 933651
Server version: 5.0.77 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select @@version;
+-----------+
| @@version |
+-----------+
| 5.0.77    |
+-----------+
1 row in set (0.00 sec)

mysql> select @@version;
+------------+
| @@version  |
+------------+
| 5.0.77-log |
+------------+
1 row in set (0.00 sec)

The only difference I see is the "-log" appendix to the server version.

So could someone explain what the "-log" means and why the identical mysqldump commands are NOT doing the same?

And, there is no major difference in /etc/my.cnf nor in ~/.my.cnf.

Posted on: 2012/1/24 11:46

Top

Previous Topic

Next Topic

You cannot start a new topic.

You can view topic.

You cannot reply to posts.

You cannot edit your posts.

You cannot delete your posts.

You cannot add new polls.

You cannot vote in polls.

You cannot attach files to posts.

You cannot post without approval.