MySQL数据库启动报错的处理
时间： 21:28:07
&&&& 阅读：15
&&&& 评论：
&&&& 收藏：0
标签：&&&&&&&&&&&&&&&今天在linux中启动mysql时提示mysql Starting MySQL..The server quit without updating PID file了，下面我来给大家介绍解决办法标签：&&&&&&&&&&&&&&&
&&国之画&&&& &&
版权所有 京ICP备号-2
迷上了代码！Linux重启后MySQL数据库文件全部丢失MySQL无法启动_数据库技术_Linux公社-Linux系统门户网站
你好，游客
Linux重启后MySQL数据库文件全部丢失MySQL无法启动
来源：Linux社区&
作者：fuwenchao
一早起来，发现数据目录下的mysql文件全部消失，一声冷汗，怎么回事！！？？？被黑了，还是因为前两天重启服务器导致mysql数据丢失？？？这是怎么回事，上网看看怎么解决，没找到解决方案！！！！看看mysql服务是不是开启的，
[root@pacteralinux mysql]# ps -ef|grep mysql root& & & & 0 13:10 pts/0& & 00:00:00 grep mysql [root@pacteralinux mysql]# service mysqld start Starting MySQL..The server quit without updating PID file (/mnt/resource/mysqldate/pacteralinux.pid).[FAILED]
靠，服务关闭，而且启动不了！看日志：
:10:57 mysqld_safe Starting mysqld daemon with databases from /mnt/resource/mysqldate
13:10:58 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
13:10:58 5650 [Note] Plugin 'FEDERATED' is disabled. /usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
13:10:58 5650 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
13:10:58 5650 [Note] InnoDB: The InnoDB memory heap is disabled
13:10:58 5650 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
13:10:58 5650 [Note] InnoDB: Compressed tables use zlib 1.2.3 13:10:58 5650 [Note] InnoDB: Not using CPU crc32 instructions
13:10:58 5650 [Note] InnoDB: Initializing buffer pool, size = 128.0M
13:10:58 5650 [Note] InnoDB: Completed initialization of buffer pool
13:10:58 5650 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
13:10:58 5650 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
13:10:58 5650 [Note] InnoDB: Database physically writes the file full: wait...
13:10:58 5650 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
13:10:58 5650 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
13:10:58 5650 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
13:10:58 5650 [Warning] InnoDB: New log files created, LSN=45781 13:10:58 5650 [Note] InnoDB: Doublewrite buffer not found: creating new 13:10:58 5650 [Note] InnoDB: Doublewrite buffer created
13:10:58 5650 [Note] InnoDB: 128 rollback segment(s) are active.
13:10:59 5650 [Warning] InnoDB: Creating foreign key constraint system tables.
13:10:59 5650 [Note] InnoDB: Foreign key constraint system tables created
13:10:59 5650 [Note] InnoDB: Creating tablespace and datafile system tables.
13:10:59 5650 [Note] InnoDB: Tablespace and datafile system tables created.
13:10:59 5650 [Note] InnoDB: Waiting for purge to start
13:10:59 5650 [Note] InnoDB: 5.6.14 log sequence number 0 13:10:59 5650 [Note] Server hostname (bind-address): '*'; port: 3306 13:10:59 5650 [Note] IPv6 is available.
13:10:59 5650 [Note]& - '::' resolves to '::';
13:10:59 5650 [Note] Server socket created on IP: '::'.
13:10:59 5650 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist :10:59 mysqld_safe mysqld from pid file /mnt/resource/mysqldate/pacteralinux.pid ended
[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist：表初始化没做好;不管，下意识的删除日志看下能不能重启1 [root@pacteralinux mysqldate]# ll total 110640-rw-rw----. 1 mysql mysql& & & 56 Nov 25 17:f -rw-rw----. 1 mysql mysql
Nov 26 13:15 ibdata1 -rw-rw----. 1 mysql mysql
Nov 26 13:15 ib_logfile0 -rw-rw----. 1 mysql mysql
Nov 26 13:10 ib_logfile1 -rw-rw----. 1 mysql root& & 39056 Nov 26 13:15 pacteralinux.err [root@pacteralinux mysqldate]# rm ib* rm: remove regular file `ibdata1'? y rm: remove regular file `ib_logfile0'? y rm: remove regular file `ib_logfile1'? y
不行，网上看看能不能恢复数据，无解决方案！！幸好这时一个mysql从服务器（我做了一个主从mysql热备份）！！！没办法，数据恢复不了就重新在复制一份吧！上述步骤后还是不能启动数据试试重新初始化：[root@pacteralinux mysqldate]# /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/data/ --datadir=/mnt/resource/mysqldate/ FATAL ERROR: Could not find ./bin/my_print_defaults If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. [root@pacteralinux mysqldate]# cd /usr/local/mysql/bin/ [root@pacteralinux mysql]# /usr/local/mysql/scripts/mysql_install_db --user=mysql --no-defaults Installing MySQL system tables... 13:20:42 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
13:20:42 6036 [Note] InnoDB: The InnoDB memory heap is disabled
13:20:42 6036 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
13:20:42 6036 [Note] InnoDB: Compressed tables use zlib 1.2.3 13:20:42 6036 [Note] InnoDB: Not using CPU crc32 instructions
13:20:42 6036 [Note] InnoDB: Initializing buffer pool, size = 128.0M
13:20:42 6036 [Note] InnoDB: Completed initialization of buffer pool
13:20:42 6036 [Note] InnoDB: Highest supported file format is Barracuda.
13:20:42 6036 [Note] InnoDB: 128 rollback segment(s) are active.
13:20:42 6036 [Note] InnoDB: Waiting for purge to start
13:20:42 6036 [Note] InnoDB: 5.6.14 log sequence number 1600607 13:20:42 6036 [Warning] InnoDB: Cannot open table mysql/innodb_table_stats from the internal data dictionary of InnoDB though the .frm file for the table exists. See /doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem. ERROR: 1146& Table 'mysql.innodb_table_stats' doesn't exist
13:20:42 6036 [ERROR] Aborting
13:20:42 6036 [Note] Binlog end
13:20:42 6036 [Note] InnoDB: FTS optimize thread exiting.
13:20:42 6036 [Note] InnoDB: Starting shutdown...
13:20:44 6036 [Note] InnoDB: S log sequence number 1600617 13:20:44 6036 [Note] ./bin/mysqld: Shutdown complete
初始化不了，，删除之前初始化的文件试试[root@pacteralinux data]# ll total 12drwx------. 2 mysql mysql 4096 Sep 25 12:27 mysql drwx------. 2 mysql mysql 4096 Sep 25 12:27 performance_schema drwxr-xr-x. 2 mysql mysql 4096 Sep 25 10:28 test [root@pacteralinux data]# cd .. [root@pacteralinux mysql]# rm -rf data/
更多详情见请继续阅读下一页的精彩内容：
相关阅读：
MySQL备份和恢复具体实施
MySQL备份：mylvmbackup介绍与使用
Linux下通过mysqldump备份MySQL数据库成sql文件
Linux中使用mysqldump对MySQL数据库进行定时备份
磁盘管理&&LVM
相关资讯 & & &
& (08/26/:57)
& (03/02/:41)
& (11/17/:15)
& (06/16/:43)
& (01/07/:35)
& (10/11/:28)
　　　同意评论声明
　　　发表
尊重网上道德，遵守中华人民共和国的各项有关法律法规
承担一切因您的行为而直接或间接导致的民事或刑事法律责任
本站管理人员有权保留或删除其管辖留言中的任意内容
本站有权在网站内转载或引用您的评论
参与本评论即表明您已经阅读并接受上述条款关于mysql新建表或者保存表的时候报1548-Cannot load from mysql.proc. The table is probably corrupted的解决办法
11:17:19 | 阅6817
来源：好空间网络
[打印] [关闭]
您的姓名：
验 证 码：
您的评论：
不能超过500个字符
所有留言只代表网友观点，不代表本站观点。
请各位遵纪守法并注意语言文明。
服务热线总机：400-666-3662
售前咨询:&&
技术支持:&&
jspkongjian
请扫右边二维码
经营许可证ICP：皖B2-
Copyright © , 安徽好空间网络科技有限公司 版权所有 , 本站素材部分来源于网络,如有侵权请告知删除。
&&&&&&&&&&在CMD里重启mysql数据库和服务 - 数据库 - MySql - 天使建站
当前位置：&&&
在CMD里重启mysql数据库和服务
有很多功能可以在CMD里非常简单的实现，不必要去进行太多的麻烦的操作，维护服务器的人最经常做的一件事就是重启IIS和MSSQL数据库及MYSQL数据库，现在站长把这三个最经常使用的命令整理出来共大家分享。运行里直接输入CMD然后回车，打开命令提示符，iisreset&&& 这个是重启IIS的命令，不需要任何的参数，直接输入命令然后回车就行了net stop mssqlserver& 这个是停止MSSQL数据库服务net start mssqlserver 这个是启动MSSQL数据库服net stop mysql&& 这个是停止MYSQL数据库net start mysql& 这个是启动MYSQL数据库
本文&在CMD里重启mysql数据库和服务&的内容摘要为：在CMD里停止和启动mysql服务&&由天使建站[]首发，转载请说明！
其他用户阅读&在CMD里重启mysql数据库和服务&的同时也阅读了：
[:116]& []
[:192]& []
[:113]& []
[:1128]& []
[:449]& []
[:441]& []
[:427]& []
[:203]& []
与&在CMD里重启mysql数据库和服务&同栏目下的站长推荐阅读：
[:1128]& []
与&Oracle&相关的栏目
与&Oracle&相关的专题
热点文章推荐
& & & & & & & & & & & & & & & & & & &
如果您需要建设网站、WEB程序定制或者现有网站改版，可以联系QQ：
天使建站 非常感谢您的到来!希望本站能对您有所帮助！
天使建站为您提供ASP、PHP、js、jquery、ajax等与网站开发相关的教程，实例与源码下载,打造最专业的站长交流和学习的免费平台
豫ICP备号-1 版权所有&
最后更新时间：linux重启后mysql数据库文件全部丢失mysql无法启动 - MySQL - 次元立方网 - 电脑知识与技术互动交流平台
linux重启后mysql数据库文件全部丢失mysql无法启动
一早起来，发现数据目录下的mysql文件全部消失，一声冷汗，怎么回事！！？？？被黑了，还是因为前两天重启服务器导致mysql数据丢失？？？这是怎么回事，上网看看怎么解决，没找到解决方案！！！！看看mysql服务是不是开启的，
[root@pacteralinux mysql]# ps -ef|grep mysql
0 13:10 pts/0
00:00:00 grep mysql
[root@pacteralinux mysql]# service mysqld start
Starting ..The server quit without updating PID file (/mnt/resource/mysqldate/pacteralinux.pid).[FAILED]
靠，服务关闭，而且启动不了！看日志：
:10:57 mysqld_safe Starting mysqld daemon with databases from /mnt/resource/mysqldate
13:10:58 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
13:10:58 5650 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
13:10:58 5650 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
13:10:58 5650 [Note] InnoDB: The InnoDB memory heap is disabled
13:10:58 5650 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
13:10:58 5650 [Note] InnoDB: Compressed tables use zlib 1.2.3
13:10:58 5650 [Note] InnoDB: Not using CPU crc32 instructions
13:10:58 5650 [Note] InnoDB: Initializing buffer pool, size = 128.0M
13:10:58 5650 [Note] InnoDB: Completed initialization of buffer pool
13:10:58 5650 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
13:10:58 5650 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
13:10:58 5650 [Note] InnoDB: Database physically writes the file full: wait...
13:10:58 5650 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
13:10:58 5650 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
13:10:58 5650 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
13:10:58 5650 [Warning] InnoDB: New log files created, LSN=45781
13:10:58 5650 [Note] InnoDB: Doublewrite buffer not found: creating new
13:10:58 5650 [Note] InnoDB: Doublewrite buffer created
13:10:58 5650 [Note] InnoDB: 128 rollback segment(s) are active.
13:10:59 5650 [Warning] InnoDB: Creating foreign key constraint system tables.
13:10:59 5650 [Note] InnoDB: Foreign key constraint system tables created
13:10:59 5650 [Note] InnoDB: Creating tablespace and datafile system tables.
13:10:59 5650 [Note] InnoDB: Tablespace and datafile system tables created.
13:10:59 5650 [Note] InnoDB: Waiting for purge to start
13:10:59 5650 [Note] InnoDB: 5.6.14 log sequence number 0
13:10:59 5650 [Note] Server hostname (bind-address): '*'; port: 3306
13:10:59 5650 [Note] IPv6 is available.
13:10:59 5650 [Note]
- '::' resolves to '::';
13:10:59 5650 [Note] Server socket created on IP: '::'.
13:10:59 5650 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
:10:59 mysqld_safe mysqld from pid file /mnt/resource/mysqldate/pacteralinux.pid ended
[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist：
表初始化没做好;不管，下意识的删除日志看下能不能重启
[root@pacteralinux mysqldate]# ll
total 110640
-rw-rw----. 1 mysql mysql
56 Nov 25 17:f
-rw-rw----. 1 mysql mysql
Nov 26 13:15 ibdata1
-rw-rw----. 1 mysql mysql
Nov 26 13:15 ib_logfile0
-rw-rw----. 1 mysql mysql
Nov 26 13:10 ib_logfile1
-rw-rw----. 1 mysql root
39056 Nov 26 13:15 pacteralinux.err
[root@pacteralinux mysqldate]# rm ib*
rm: remove regular file `ibdata1'? y
rm: remove regular file `ib_logfile0'? y
rm: remove regular file `ib_logfile1'? y
不行，网上看看能不能恢复数据，无解决方案！！
幸好这时一个mysql从服务器（我做了一个主从mysql热备份）！！！没办法，数据恢复不了就重新在复制一份吧！
上述步骤后还是不能启动数据
试试重新初始化：
[root@pacteralinux mysqldate]# /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/data/ --datadir=/mnt/resource/mysqldate/
FATAL ERROR: Could not find ./bin/my_print_defaults
If you compiled from source, you need to run 'make install' to
copy the software into the correct location ready for operation.
If you are using a binary release, you must either be at the top
level of the extracted archive, or pass the --basedir option
pointing to that location.
[root@pacteralinux mysqldate]# cd /usr/local/mysql/bin/
[root@pacteralinux mysql]# /usr/local/mysql/scripts/mysql_install_db --user=mysql --no-defaults
Installing
system tables... 13:20:42 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
13:20:42 6036 [Note] InnoDB: The InnoDB memory heap is disabled
13:20:42 6036 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
13:20:42 6036 [Note] InnoDB: Compressed tables use zlib 1.2.3
13:20:42 6036 [Note] InnoDB: Not using CPU crc32 instructions
13:20:42 6036 [Note] InnoDB: Initializing buffer pool, size = 128.0M
13:20:42 6036 [Note] InnoDB: Completed initialization of buffer pool
13:20:42 6036 [Note] InnoDB: Highest supported file format is Barracuda.
13:20:42 6036 [Note] InnoDB: 128 rollback segment(s) are active.
13:20:42 6036 [Note] InnoDB: Waiting for purge to start
13:20:42 6036 [Note] InnoDB: 5.6.14 log sequence number 1600607
13:20:42 6036 [Warning] InnoDB: Cannot open table mysql/innodb_table_stats from the internal data dictionary of InnoDB though the .frm file for the table exists. See /doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
ERROR: 1146
Table 'mysql.innodb_table_stats' doesn't exist
13:20:42 6036 [ERROR] Aborting
13:20:42 6036 [Note] Binlog end
13:20:42 6036 [Note] InnoDB: FTS optimize thread exiting.
13:20:42 6036 [Note] InnoDB: Starting shutdown...
13:20:44 6036 [Note] InnoDB: S log sequence number 1600617
13:20:44 6036 [Note] ./bin/mysqld: Shutdown complete
初始化不了，，删除之前初始化的文件试试
[root@pacteralinux data]# ll
drwx------. 2 mysql mysql 4096 Sep 25 12:27 mysql
drwx------. 2 mysql mysql 4096 Sep 25 12:27 performance_schema
drwxr-xr-x. 2 mysql mysql 4096 Sep 25 10:28 test
[root@pacteralinux data]# cd ..
[root@pacteralinux mysql]# rm -rf data/
重新初始化：
[root@pacteralinux mysql]# scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/mnt/resource/mysqldate --user=mysql
Installing MySQL system tables... 13:41:48 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
13:41:48 6768 [Note] InnoDB: The InnoDB memory heap is disabled
13:41:48 6768 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
13:41:48 6768 [Note] InnoDB: Compressed tables use zlib 1.2.3
13:41:48 6768 [Note] InnoDB: Not using CPU crc32 instructions
13:41:48 6768 [Note] InnoDB: Initializing buffer pool, size = 128.0M
13:41:48 6768 [Note] InnoDB: Completed initialization of buffer pool
13:41:48 6768 [Note] InnoDB: Highest supported file format is Barracuda.
13:41:48 6768 [Note] InnoDB: Log scan progressed past the checkpoint lsn 49463
13:41:48 6768 [Note] InnoDB: Database was not shutdown normally!
13:41:48 6768 [Note] InnoDB: Starting crash recovery.
13:41:48 6768 [Note] InnoDB: Reading tablespace information from the .ibd files...
13:41:48 6768 [Note] InnoDB: Restoring possible half-written data pages
13:41:48 6768 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1600617
13:41:48 6768 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
13:41:48 6768 [Note] InnoDB: 128 rollback segment(s) are active.
13:41:48 6768 [Note] InnoDB: Waiting for purge to start
13:41:48 6768 [Note] InnoDB: 5.6.14 log sequence number 1600617
13:41:54 6768 [Note] Binlog end
13:41:54 6768 [Note] InnoDB: FTS optimize thread exiting.
13:41:54 6768 [Note] InnoDB: Starting shutdown...
13:41:55 6768 [Note] InnoDB: S log sequence number 1625997
Filling help tables... 13:41:55 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
13:41:55 6793 [Note] InnoDB: The InnoDB memory heap is disabled
13:41:55 6793 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
13:41:55 6793 [Note] InnoDB: Compressed tables use zlib 1.2.3
13:41:55 6793 [Note] InnoDB: Not using CPU crc32 instructions
13:41:55 6793 [Note] InnoDB: Initializing buffer pool, size = 128.0M
13:41:55 6793 [Note] InnoDB: Completed initialization of buffer pool
13:41:55 6793 [Note] InnoDB: Highest supported file format is Barracuda.
13:41:55 6793 [Note] InnoDB: 128 rollback segment(s) are active.
13:41:55 6793 [Note] InnoDB: Waiting for purge to start
13:41:55 6793 [Note] InnoDB: 5.6.14 log sequence number 1625997
13:41:55 6793 [Note] Binlog end
13:41:55 6793 [Note] InnoDB: FTS optimize thread exiting.
13:41:55 6793 [Note] InnoDB: Starting shutdown...
13:41:57 6793 [Note] InnoDB: S log sequence number 1626007
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/mysql/bin/mysqladmin -u root pass 'new-pass'
/usr/local/mysql/bin/mysqladmin -u root -h pacteralinux password 'new-password'
Alternatively you can run:
/usr/local/mysql/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default.
strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd . ; /usr/local/mysql/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd mysql- perl mysql-test-run.pl
Please report any problems with the ./bin/mysqlbug script!
The latest information about MySQL is available on the web at
Support MySQL by buying support/licenses at
WARNING: Found existing config file /usr/local/f on the system.
Because this file might be in use, it was not replaced,
but was used in bootstrap (unless you used --defaults-file)
and when you later start the server.
The new default config file was created as /usr/local/mysql/f,
please compare it with your file and take the changes you need.
WARNING: Default config file /f exists on the system
This file will be read by default by the MySQL server
If you do not want to use this, either remove it, or use the
--defaults-file argument to mysqld_safe when starting the server
重新启动mysql
[root@pacteralinux scripts]# service mysqld start
Starting MySQL.[
[root@pacteralinux mysql]# ps -ef|grep msyql
0 14:08 pts/1
00:00:00 grep msyql
[root@pacteralinux mysql]# ps -ef|grep mysql
0 13:42 pts/1
00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/mnt/resource/mysqldate --pid-file=/mnt/resource/mysqldate/pacteralinux.pid
0 13:42 pts/1
00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/mnt/resource/mysqldate --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/mnt/resource/mysqldate/pacteralinux.err --pid-file=/mnt/resource/mysqldate/pacteralinux.pid --socket=/mnt/resource/mysqldate/mysql.sock --port=3306
0 14:08 pts/1
00:00:00 grep mysql
可以看到，mysql安装路径为--basedir=/usr/local/mysql，初始数据库的存放目录为--datadir=/mnt/resource/mysqldate
-rw-rw----. 1 mysql mysql
2048 Nov 26 13:41 user.MYI
[root@pacteralinux mysql]# pwd
/mnt/resource/mysqldate/mysql
[root@pacteralinux mysql]# cd ..
[root@pacteralinux mysqldate]# ll
total 110664
-rw-rw----. 1 mysql mysql
56 Nov 25 17:f
-rw-rw----. 1 mysql mysql
Nov 26 13:42 ibdata1
-rw-rw----. 1 mysql mysql
Nov 26 13:42 ib_logfile0
-rw-rw----. 1 mysql mysql
Nov 26 13:39 ib_logfile1
drwx------. 2 mysql mysql
4096 Nov 26 13:41 mysql
srwxrwxrwx. 1 mysql mysql
0 Nov 26 13:42 mysql.sock
-rw-rw----. 1 mysql root
46096 Nov 26 13:42 pacteralinux.err
-rw-rw----. 1 mysql mysql
5 Nov 26 13:42 pacteralinux.pid
drwx------. 2 mysql mysql
4096 Nov 26 13:41 performance_schema
drwx------. 2 mysql mysql
4096 Nov 26 13:41 test
可以看到，mysql安装路径为--basedir=/usr/local/mysql，初始数据库的存放目录为--datadir=/mnt/resource/mysqldate
-rw-rw----. 1 mysql mysql
2048 Nov 26 13:41 user.MYI
[root@pacteralinux mysql]# pwd
/mnt/resource/mysqldate/mysql
[root@pacteralinux mysql]# cd ..
[root@pacteralinux mysqldate]# ll
total 110664
-rw-rw----. 1 mysql mysql
56 Nov 25 17:f
-rw-rw----. 1 mysql mysql
Nov 26 13:42 ibdata1
-rw-rw----. 1 mysql mysql
Nov 26 13:42 ib_logfile0
-rw-rw----. 1 mysql mysql
Nov 26 13:39 ib_logfile1
drwx------. 2 mysql mysql
4096 Nov 26 13:41 mysql
srwxrwxrwx. 1 mysql mysql
0 Nov 26 13:42 mysql.sock
-rw-rw----. 1 mysql root
46096 Nov 26 13:42 pacteralinux.err
-rw-rw----. 1 mysql mysql
5 Nov 26 13:42 pacteralinux.pid
drwx------. 2 mysql mysql
4096 Nov 26 13:41 performance_schema
drwx------. 2 mysql mysql
4096 Nov 26 13:41 test
其中，mysql，performance_schema，test为初始化后的文件
下面开始恢复数据库
登录到生产服务器执行备份：
[root@uyhd000225 ~]# mysqldump -u***** -p***** mysqldb &mysqldb.sql
#数据库比较大，大约半小时
复制到备份服务器：
[root@uyhd000225 ~]# scp mysqldb.sql root@remoteIP:/mnt/backup/
root@remoteIP's password:
mysqldb.sql
153MB 680.6KB/s 1:43:33 ETA
延伸阅读：
统计访问页面数量，以分辨率进行排名SELECTCONCAT(`h...
本教程为 李华明 编著的iOS-Cocos2d游戏开发系列教程：教程涵盖关于i......
专题主要学习DirectX的初级编程入门学习，对Directx11的入门及初学者有......
&面向对象的JavaScript&这一说法多少有些冗余，因为JavaScript 语言本......
Windows7系统专题 无论是升级操作系统、资料备份、加强资料的安全及管......