RootForum Community

Code: Select all

mysql> FLUSH TABLES WITH READ LOCK;
mysql> SHOW MASTER STATUS;
+-------------------+----------+--------------+------------------+
| File              | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+-------------------+----------+--------------+------------------+
| mysqld-bin.000004 |       98 |              |                  |
+-------------------+----------+--------------+------------------+
1 row in set (0.00 sec)

Code: Select all

UNLOCK TABLES;

Code: Select all

service mysqld stop; #(loesche auch noch ggf. existierende Slave-Datenbankverzeichnisse)
tar xpjvf /master.tar.bz2
mysqld_safe --skip-slave-start &
[...]
mysql> RESET SLAVE;

mysql> CHANGE MASTER TO
    ->     MASTER_HOST='master_host_name',
    ->     MASTER_USER='replication_user_name',
    ->     MASTER_PASSWORD='replication_password',
    ->     MASTER_LOG_FILE='mysqld-bin.000004',
    ->     MASTER_LOG_POS=98;
START SLAVE;

Code: Select all

mysql> SHOW SLAVE STATUSG
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
                Master_Host: master.dom.ain
                Master_User: slave1
                Master_Port: 3306
              Connect_Retry: 60
            Master_Log_File: mysqld-bin.000004
        Read_Master_Log_Pos: 98
             Relay_Log_File: mysqld-relay-bin.000002
              Relay_Log_Pos: 236
      Relay_Master_Log_File: mysqld-bin.000004
           Slave_IO_Running: Yes
          Slave_SQL_Running: Yes
            Replicate_Do_DB:
        Replicate_Ignore_DB:
         Replicate_Do_Table:
     Replicate_Ignore_Table:
    Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
                 Last_Errno: 0
                 Last_Error:
               Skip_Counter: 0
        Exec_Master_Log_Pos: 98
            Relay_Log_Space: 236
            Until_Condition: None
             Until_Log_File:
              Until_Log_Pos: 0
         Master_SSL_Allowed: No
         Master_SSL_CA_File:
         Master_SSL_CA_Path:
            Master_SSL_Cert:
          Master_SSL_Cipher:
             Master_SSL_Key:
      Seconds_Behind_Master: 0
1 row in set (0.01 sec)

Code: Select all

[root@mysql mysql]# mysqldump --opt -u root -p --all-databases > mysql.dump
Enter password:
mysqldump: Got error: 1146: Table 'gallerie.g2_EventLogMap' doesn't exist when using LOCK TABLES

Code: Select all

[root@mysql gallery]# ls |grep -i event
g2_EventLogMap.frm
g2_SequenceEventLog.frm
g2_SequenceEventLog.MYD
g2_SequenceEventLog.MYI

Code: Select all

scp root@master:/root/master.tar.bz2 /root
cd /var/lib/mysql
service mysqld stop
tar xjpvf /root/master.tar.bz2
mysqld_safe --skip-slave-start &
mysql> RESET SLAVE; 
mysql> CHANGE MASTER TO MASTER_HOST='master.doma.in', MASTER_USER='slave1', MASTER_PASSWORD='password', MASTER_LOG_FILE='mysqld-bin.000005', MASTER_LOG_POS=98;
mysql> START SLAVE;
mysql> SHOW SLAVE STATUSG
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
[...]

Code: Select all

[root@master mysql]# mysqldump --opt -u root -p --all-databases > mysql.dump
Enter password:
[root@master mysql]#

Code: Select all

[root@slave mysql]#  mysqldump --opt -u root -p --all-databases > mysql.dump
Enter password:
mysqldump: Got error: 1146: Table 'gallerie.g2_EventLogMap' doesn't exist when using LOCK TABLES
[root@mysql mysql]#

Code: Select all

mysqldump --opt --master-data --lock-all-tables --triggers --routines --flush-logs --delete-master-logs  -u root -p --all-databases > mysql.dump

Code: Select all

tar cf - /etc | tar xvf - -C /backup

Code: Select all

mysqlcheck --analyze --check --auto-repair --extend --optimize --all-databases -uroot -p
[...]
gallerie.g2_EventLogMap                             OK
gallerie.g2_ExifPropertiesMap                       OK
gallerie.g2_ExternalIdMap                           Table is already up to date

Code: Select all

mysqlcheck --analyze --check --auto-repair --extend --optimize --all-databases -uroot -p
[...]
gallerie.g2_EventLogMap
error    : Table 'gallerie.g2_EventLogMap' doesn't exist
gallerie.g2_ExifPropertiesMap                       Table is already up to date
gallerie.g2_ExternalIdMap                           Table is already up to date

Repairing tables
gallerie.g2_EventLogMap
error    : Table 'gallerie.g2_EventLogMap' doesn't exist

Code: Select all

[root@master ~]# mysqlshow gallerie g2_EventLogMap -uroot -p -i
Enter password:
Database: gallerie  Wildcard: g2_EventLogMap
+----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+----------------------+
| Name           | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time | Check_time | Collation       | Checksum | Create_options | Comment              |
+----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+----------------------+
| g2_EventLogMap | InnoDB | 10      | Compact    | 9    | 1820           | 16384       | 0               | 16384        | 0         |                | 2009-03-25 21:33:39 |             |            | utf8_general_ci |          |                | InnoDB free: 4096 kB |
+----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+----------------------+

Code: Select all

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
bind-address = 127.0.0.1

#Following entries for MASTER DB
log-bin
server-id=1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
bind-address = 127.0.0.1

Code: Select all

#ls -l /var/lib/mysql
drwx------ 2 mysql mysql    12288 Mar 25 21:13 gallerie
-rw-rw---- 1 mysql mysql 10485760 Mar 25 21:47 ibdata1
-rw-rw---- 1 mysql mysql  5242880 Mar 25 21:47 ib_logfile0
-rw-rw---- 1 mysql mysql  5242880 Jan  9 20:33 ib_logfile1
[...]