openstack基于mysql的问题修复
#mysqldump -uroot--all-database>> my_mysql.dump-- Warning: Skipping the data of tablemysql.event. Specify the --events option explicitly.
#/etc/init.d/mysqld stop
Stopping mysqld:
# rm -rfibdata1 ib_logfile0 ib_logfile1
# vi/etc/my.cnf
port = 3306
socket = /var/lib/mysql/mysql.sock
socket = /var/lib/mysql/mysql.sock
port = 3306
socket = /var/lib/mysql/mysql.sock
socket = /var/lib/mysql/mysql.sock
nice = 0
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/lib/mysql/mysql.sock
port = 3306
basedir= /usr
datadir= /var/lib/mysql
tmpdir = /tmp
skip-external-locking
#innodb_force_recover = 6
bind-address = 0.0.0.0
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size= 8
myisam-recover = BACKUP
query_cache_limit= 1M
query_cache_size = 16M
log_error = /var/log/mysqld.log
expire_logs_days = 10
max_binlog_size = 100M
default-storage-engine = InnoDB
quick
quote-names
"/etc/my.cnf" 43L, 811C written
# mkdirdatabase_bak
# mvcinder/ glance/ keystone/ nova/ ovs_neutron/ database_bak/
# lldatabase_bak/
total 20
drwx------ 2 mysql mysql 4096 Oct 25 15:08cinder
drwx------ 2 mysql mysql 4096 Oct 25 15:08glance
drwx------ 2 mysql mysql 4096 Oct 25 15:08keystone
drwx------ 2 mysql mysql 4096 Oct 25 15:08nova
drwx------ 2 mysql mysql 4096 Oct 25 15:08ovs_neutron
# ll
total 29648
drwxr-xr-x 2 rootroot 4096 Apr 20 15:15 aaa
drwxr-xr-x 2 rootroot 4096 Apr 20 15:33 bbb
drwxr-xr-x 7 rootroot 4096 Apr 20 15:47 database_bak
-rw-r--r-- 1 rootroot 29610746 Apr 20 15:45 my_mysql.dump
drwx------ 2 mysql mysql 4096 Oct 25 15:05 mysql
-rw-r----- 1 mysql root 82317 Apr 20 15:46 sxun01.err
-rw-r----- 1 mysql root 637765 Apr 20 15:35 sxun01.err--
drwx------ 2 mysql mysql 4096 Oct 25 15:05 test
#
#
#/etc/init.d/mysqld restart
Stopping mysqld:
Starting mysqld:
# mysql
Welcome to the MySQL monitor.Commands end with ; or \g.
Your MySQL connection id is 22
Server version: 5.1.73 Source distribution
Copyright (c) 2000, 2013, Oracle and/or itsaffiliates. All rights reserved.
Oracle is a registered trademark of OracleCorporation and/or its
affiliates. Other names may be trademarksof their respective
owners.
Type 'help;' or '\h' for help. Type '\c' toclear the current input statement.
mysql> quit
Bye
# mysql-uroot < my_mysql.dump
#
#
# mysql
Welcome to the MySQL monitor.Commands end with ; or \g.
Your MySQL connection id is 93
Server version: 5.1.73 Source distribution
Copyright (c) 2000, 2013, Oracle and/or itsaffiliates. All rights reserved.
Oracle is a registered trademark of OracleCorporation and/or its
affiliates. Other names may be trademarksof their respective
owners.
Type 'help;' or '\h' for help. Type '\c' toclear the current input statement.
mysql> use nova ;
Reading table information for completion oftable and column names
You can turn off this feature to get aquicker startup with -A
Database changed
mysql> select * frominstances;
mysql> quit
Bye
#nova-manage service list
Binary Host Zone Status State Updated_At
nova-consoleauth sxun01 internal enabled XXX2017-04-20 05:31:48
nova-scheduler sxun01 internal enabled XXX2017-04-20 05:31:54
nova-conductor sxun01 internal enabled :-)2017-04-20 07:49:07
nova-cert sxun01 internal enabled XXX2017-04-20 05:31:55
nova-compute sxun01 nova enabled XXX2017-04-20 05:31:53
# reboot
#
Broadcast message from root@sxun01
(/dev/pts/0) at 15:49 ...
The system is going down for reboot NOW!
Last login: Thu Apr 20 15:28:26 2017
# nova-manage service list
Binary Host Zone Status State Updated_At
nova-consoleauth sxun01 internal enabled :-)2017-04-20 07:53:28
nova-scheduler sxun01 internal enabled :-)2017-04-20 07:53:28
nova-conductor sxun01 internal enabled :-)2017-04-20 07:53:28
nova-cert sxun01 internal enabled :-)2017-04-20 07:53:28
nova-compute sxun01 nova enabled :-)2017-04-20 07:53:24
页:
[1]