作者:WYZ的小舟于SZ | 来源:互联网 | 2023-09-24 21:36
数据库|mysql教程mysqlfrm,方法,结构数据库-mysql教程1、mysqlfrm安装vb.net源码,ubuntu配置控制节点,tomcat下载中文文件,使用爬虫挣钱,
数据库|mysql教程
mysqlfrm,方法,结构
数据库-mysql教程
1、mysqlfrm安装vb.net源码,ubuntu配置控制节点,tomcat下载中文文件,使用爬虫挣钱,php属性是数组,梅州网络推广seo的转化率高lzw
—————————–
交易乐源码教程,双系统 ubuntu扩容,查tomcat连接数,爬虫云注册,把变量存入缓存 php,相城区seolzw
由于mysqlfrm是mysql-utilities工具一部分,那么我们安装mysql-utilities即可,下载好对应的源码包,进行编译安装。
微赞最新版源码 下载,mac怎么使用vscode,nvme上装ubuntu,tomcat如何刷dns,安卓sqlite汉化版3,crunchbase爬虫,php 上传图片类型,平潭提供seo服务电话,网站地图调用,个人介绍网页制作模板lzw
shell> tar -xvzf mysql-utilities-1.6.4.tar.gz shell> cd mysql-utilities-1.6.4shell> python ./setup.py buildshell> python ./setup.py install
安装完成后,在相应的python执行目录下,就能mysqlfrm等执行文件了。
2、mysqlfrm相关参数介绍
——————————-
--basedir :如 --basedir=/usr/local/percona-5.6.21--server : 如 --server=user:password@192.168.1.100:3306--diagnostic : 开启按字节模式来恢复frm结构--user :启动MySQL用户,通过为mysql
3、mysqlfrm使用
————————-
使用–basedir模式恢复:
[ 16:35:29-root@br3cy1sw:~ ]# mysqlfrm --basedir=/usr/local/percona-5.6.21/ /root/t1.frm --port=3434 --user=mysql --diagnostic# WARNING The --port option is not used in the --diagnostic mode.# WARNING: The --user option is only used for the default mode.# WARNING: Cannot generate character set or collation names without the --server option.# CAUTION: The diagnostic mode is a best-effort parse of the .frm file. As such, it may not identify all of the components of the table correctly. This is especially true for damaged files. It will also not read the default values for the columns and the resulting statement may not be syntactically correct.# Reading .frm file for /root/t1.frm:# The .frm file is a TABLE.# CREATE TABLE Statement:CREATE TABLE `root`.`t1` (`a` int(11) NOT NULL,`b` int(11) DEFAULT NULL,`c` int(11) DEFAULT NULL,`d` varchar(600) DEFAULT NULL,PRIMARY KEY `PRIMARY` (`a`),KEY `idx_t1_bc` (`b`,`c`)) ENGINE=InnoDB; #...done.
使用–server方式恢复:
[ 16:35:10-root@br3cy1sw:~ ]#mysqlfrm --server=user:password@192.168.1.100:3306 /root/t1.frm --port=3434 --user=mysql --diagnosticWARNING: Using a password on the command line interface can be insecure.# WARNING The --port option is not used in the --diagnostic mode.# WARNING: The --user option is only used for the default mode.# Source on 192.168.1.100: ... connected.# CAUTION: The diagnostic mode is a best-effort parse of the .frm file. As such, it may not identify all of the components of the table correctly. This is especially true for damaged files. It will also not read the default values for the columns and the resulting statement may not be syntactically correct.# Reading .frm file for /root/t1.frm:# The .frm file is a TABLE.# CREATE TABLE Statement:CREATE TABLE `root`.`t1` ( `a` int(11) NOT NULL, `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL,`d` varchar(200) COLLATE `utf8_general_ci` DEFAULT NULL,PRIMARY KEY `PRIMARY` (`a`),KEY `idx_t1_bc` (`b`,`c`)) ENGINE=InnoDB DEFAULT CHARSET=utf8; #...done.
注意到没有,使用–basedir恢复出来的varchar竟然是–server模式的3倍;这应该是mysqlfrm在使用basedir模式时,无法进行字符编码校验所致引起的。
再次看了下–server的文件:(重点看标红加粗的文字),建议:能用–server模式时,尽量使用–server同时保证提供mysqld环境与原生产环境的一致。
--server=serverConnection information for a server. Use this option or --basedir for the default mode. If provided with the diagnostic mode, the storage engine and character set information are validated against this server.