摘要：解决Table 'mysql.servers' doesn't exist今天遇到一事，就是我在升级mysql数据库后进入数据建立一远程用户，结果报错了。mysql> flush privileges;ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist这是由于升级完数据库后丢失原有的系统表后造成的解决方案：mysql> CREATE TABLE `servers` ( -> `Server_name` char(64) NOT NULL, -> `Host` ch 阅读全文

摘要：1.在从库上设置master_info信息时出错mysql> change master to master_host='192.168.157.143',master_port=3306,master_user='backup',master_password='redhat',master_log_file='mysql-bin.000002',master_log_pos=597;ERROR 1201 (HY000): Could not initialize master info structure; more e 阅读全文

摘要：mysql建立数据库的方法方法一：使用createmysql> create database roudy;Query OK, 1 row affected (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)方法二：使用mysqladmin来创建数据库[root@master ~]# mysqladmin create roudy-1 -u root -pEnter password:[root@master ~]# mysql -uroot -p'redhat' -e &qu 阅读全文

摘要：备份单个数据库[root@master var]# mkdir /backup[root@master var]# mysqldump -uroot -p luodi_test >/backup/$(date +%F).backup.sql drop database luodi_test;Query OK, 1 row affected (0.01 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> create database luodi_test; flush privilege 阅读全文