[root@sxun01 mysql(keystone_admin)]#mysqldump -uroot --all-database >> my_mysql.dump
-- Warning: Skipping the data of tablemysql.event. Specify the --events option explicitly.
[root@sxun01 mysql(keystone_admin)]#/etc/init.d/mysqld stop
Stopping mysqld: [ OK ]
[root@sxun01 mysql(keystone_admin)]# rm -rfibdata1 ib_logfile0 ib_logfile1
[root@sxun01 mysql(keystone_admin)]# vi/etc/my.cnf
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld_safe]
socket = /var/lib/mysql/mysql.sock
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld_safe]
socket = /var/lib/mysql/mysql.sock
nice = 0
[mysqld]
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
[mysqldump]
quick
quote-names
"/etc/my.cnf" 43L, 811C written
[root@sxun01 mysql(keystone_admin)]# mkdirdatabase_bak
[root@sxun01 mysql(keystone_admin)]# mvcinder/ glance/ keystone/ nova/ ovs_neutron/ database_bak/
[root@sxun01 mysql(keystone_admin)]# 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
[root@sxun01 mysql(keystone_admin)]# ll
total 29648
drwxr-xr-x 2 root root 4096 Apr 20 15:15 aaa
drwxr-xr-x 2 root root 4096 Apr 20 15:33 bbb
drwxr-xr-x 7 root root 4096 Apr 20 15:47 database_bak
-rw-r--r-- 1 root root 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
[root@sxun01 mysql(keystone_admin)]#
[root@sxun01 mysql(keystone_admin)]#
[root@sxun01 mysql(keystone_admin)]#/etc/init.d/mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
[root@sxun01 mysql(keystone_admin)]# 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
[root@sxun01 mysql(keystone_admin)]# mysql-uroot < my_mysql.dump
[root@sxun01 mysql(keystone_admin)]#
[root@sxun01 mysql(keystone_admin)]#
[root@sxun01 mysql(keystone_admin)]# 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 * from instances;
mysql> quit
Bye
[root@sxun01 mysql(keystone_admin)]#nova-manage service list
Binary Host Zone Status State Updated_At
nova-consoleauth sxun01 internal enabled XXX 2017-04-20 05:31:48
nova-scheduler sxun01 internal enabled XXX 2017-04-20 05:31:54
nova-conductor sxun01 internal enabled :-) 2017-04-20 07:49:07
nova-cert sxun01 internal enabled XXX 2017-04-20 05:31:55
nova-compute sxun01 nova enabled XXX 2017-04-20 05:31:53
[root@sxun01 mysql(keystone_admin)]# reboot
[root@sxun01 mysql(keystone_admin)]#
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
[root@sxun01 ~]# 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、欢迎大家加入本站运维交流群:群②:261659950 群⑤:202807635 群⑦870801961 群⑧679858003
2、本站所有主题由该帖子作者发表,该帖子作者与运维网 享有帖子相关版权
3、所有作品的著作权均归原作者享有,请您和我们一样尊重他人的著作权等合法权益。如果您对作品感到满意,请购买正版
4、禁止制作、复制、发布和传播具有反动、淫秽、色情、暴力、凶杀等内容的信息,一经发现立即删除。若您因此触犯法律,一切后果自负,我们对此不承担任何责任
5、所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其内容的准确性、可靠性、正当性、安全性、合法性等负责,亦不承担任何法律责任
6、所有作品仅供您个人学习、研究或欣赏,不得用于商业或者其他用途,否则,一切后果均由您自己承担,我们对此不承担任何法律责任
7、如涉及侵犯版权等问题,请您及时通知我们,我们将立即采取措施予以解决
8、联系人Email:admin@iyunv.com 网址:www.yunweiku.com