【服务器启动不了】菜鸟刚刚接触这个东西所以真心不怎么会用。安装就不说了,这个照着文档就偶了。
1、启动mysql服务器
以前用习惯了Oracle所以服务器没开的时候都是去任务管理器那里去手动打开的,但是mysql就傲娇了,不让我开,有图为证:
木有办法了,又去问了老鸟们,才知道mysql要去MySQL Workbench这里面来开启的(可能也可以从别的地方开,不懂不懂·······)
2、打开MySQL Workbench然后点开Startup/Shutdown窗口点击Start Server就ok啦。
【导出-高级选项】
(Inserts)
1、add-locks - Surround each table dump with LOCK TABLES and UNLOCK TABLES statements
围绕每个表转储用LOCK TABLES和UNLOCK TABLES语句
2、complete-insert - Use complete INSERT statements that include column
使用完整插入语句,包括列
3、extended-insert - Use multiple-row INSERT syntax that include several VALUES lists
使用多行插入的语法,包括几个值列表
4、insert-ignore - Write INSERT IGNORE statements rather than INSERT statements
写INSERT IGNORE语句而不是INSERT语句
5、replace - Write REPLACE statements rather than INSERT statements
写替换语句而不是插入语句
6、delayed-insert - Write INSERT DELAYED statements rather than INSERT statements
写延迟插入语句,而不是插入语句
(Other)
1、lock-table - Lock tables for read.Disable if user has no Lock TABLES privilege
锁表只读。如果用户没有锁表权限则禁用
2、dump-date - Include dump date as "Dump completed on" comment if -comments is given
3、flush-logs - Flush the MySQL server log files before starting the dump
开始转储前刷新MySQL服务器日志文件
4、delete-master-logs - On a master replication server,delete the binary logs after performing the dump operation
在一个主复制服务器,进行转储操作后删除二进制日志
5、hex-blob - Dump binary columns using hexadecimal notation(for example,'abc' becomes 0x616263)
二进制列使用十六进制转储
6、compress - Use compression in server/client protocol
使用压缩的服务器/客户端协议
7、flush-privileges - Emit a FLUSH PRIVILEGES statements after dumping the mysql database
发出一个FLUSH PRIVILEGES语句在转储MySQL数据库之后
8、disable-keys - For each table,surround the INSERT statements with statements to disable and enable keys
每个表的INSERT语句都有语句禁用或启用键的语句
9、force - Continue even if we get an sql-error
即使我们报出SQL错误仍然继续
10、order-by primary - Dump each table's rows sorted by its primary key,or by its first unique index
转储每个表中的行排序通过主键,或者通过它的第一个唯一索引
11、tz-utc - Add SET TIME_ZONE='+00:00' to the dump file
添加设置time_zone =”+ 00:00到转储文件
警句:菜鸟用爪挖,看者需谨慎,切莫听一面之词,徒走曲折之路。