mysql备份sql无法还原 #772

Closed
opened 2017-11-07 09:52:00 +00:00 by zxysilent · 5 comments
zxysilent commented 2017-11-07 09:52:00 +00:00 (Migrated from github.com)

导出的的数据里面含有富文本文件
其中出现了一个字符串变成多行的情况
无法还原变成语法错误

导出的的数据里面含有富文本文件 其中出现了一个字符串变成多行的情况 无法还原变成语法错误

Please paste some example SQL

Please paste some example SQL
zxysilent commented 2017-11-07 14:34:25 +00:00 (Migrated from github.com)

lgdf7 nhp2uldaqf6m7u

![lgdf7 nhp2uldaqf6m7u](https://user-images.githubusercontent.com/19162822/32498352-7654f3d4-c40a-11e7-9e53-90cf5b9e8acd.png)

could you export the SQL via engine.Dump?

could you export the SQL via `engine.Dump`?
zxysilent commented 2017-11-08 03:28:33 +00:00 (Migrated from github.com)
bakSQL := toolbox.NewTask("bakSQL", "0 9 10 * * 1", func() error {
		os.MkdirAll(`logs/bak/`, 0777)
		file := time.Now().Format(utils.FormatDateTimeZStr) + `.sql`
		Db.DumpAllToFile(`logs/bak/sql_` + file)
		Lg.Info(`bakSQL : %s`, file)
		return nil
	})
``` bakSQL := toolbox.NewTask("bakSQL", "0 9 10 * * 1", func() error { os.MkdirAll(`logs/bak/`, 0777) file := time.Now().Format(utils.FormatDateTimeZStr) + `.sql` Db.DumpAllToFile(`logs/bak/sql_` + file) Lg.Info(`bakSQL : %s`, file) return nil }) ```
lunny modified the milestone from 0.8.2 to 1.1.1 2020-02-21 12:42:15 +00:00
lunny modified the milestone from 1.1.1 to 1.0.0 2020-03-13 09:25:55 +00:00

closed by #1603

closed by #1603
lunny closed this issue 2020-03-15 02:03:03 +00:00
Sign in to join this conversation.
No Milestone
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: xorm/xorm#772
No description provided.