[DiscordArchive] For any poor sods who are stuck on this in future, I fixed issue by adding `--hex-blob` and `--defau
[DiscordArchive] For any poor sods who are stuck on this in future, I fixed issue by adding `--hex-blob` and `--defau
Original source
For any poor sods who are stuck on this in future, I fixed issue by adding `--hex-blob` and `--default-character-set=utf8mb4` to the bak.py script on the telegram repo:
```python
os.system("mysqldump --hex-blob --default-character-set=utf8mb4 --no-tablespaces --column-statistics=0 -h {} -u {} -p'{}' {} > characters.sql".format(
mysql_localhost,
mysql_username,
mysql_password,
char_db
))
os.system("mysqldump --hex-blob --default-character-set=utf8mb4 --no-tablespaces --column-statistics=0 -h {} -u {} -p'{}' {} > auth.sql".format(
mysql_localhost,
mysql_username,
mysql_password,
auth_db
))
```
Any concerns with adding these two flags? I've tested and am able to sqldump from ubuntu and import back into heidisql windows, so i think all is good?
rektbyfaith
09-13-2025, 03:42 AM #1Archived author: Exlex • Posted: 2025-09-13T03:42:51.914000+00:00
Original source
For any poor sods who are stuck on this in future, I fixed issue by adding `--hex-blob` and `--default-character-set=utf8mb4` to the bak.py script on the telegram repo:
```python
os.system("mysqldump --hex-blob --default-character-set=utf8mb4 --no-tablespaces --column-statistics=0 -h {} -u {} -p'{}' {} > characters.sql".format(
mysql_localhost,
mysql_username,
mysql_password,
char_db
))
os.system("mysqldump --hex-blob --default-character-set=utf8mb4 --no-tablespaces --column-statistics=0 -h {} -u {} -p'{}' {} > auth.sql".format(
mysql_localhost,
mysql_username,
mysql_password,
auth_db
))
```
Any concerns with adding these two flags? I've tested and am able to sqldump from ubuntu and import back into heidisql windows, so i think all is good?
1 Guest(s)
1 Guest(s)