As in the email content is converted or the SQL content inside it?
Thread Starter
nagak
(@nagak)
Thank you for your reply.
SQL content inside is converted like this.
INSERT INTO wp_xxx_posts VALUES (3889,1,’2012-07-17 11:37:13′,’2012-07-17 02:37:13′,'(snip)「(?)? ???と(?)???」は(snip)
Thread Starter
nagak
(@nagak)
Just for your information,
-Manual backup via web interface was fine.
-Auto backup files under /wp-content/backp-db are also corrupted.
Weird, they run the same command.
Can you add a error_log( $command ) above this line https://github.com/lesterchan/wp-dbmanager/blob/master/wp-dbmanager.php#L245.
Then run a manual backup and wait for automated backup and let me know the error logs.
Thread Starter
nagak
(@nagak)
I found default-character-set=”utf8″ is missing when auto backup.
This should be a cause 🙂
(Auto)
/usr/local/bin/mysqldump –force –host=’xxx’ –user=’xxx’ –password=’xxx’ –add-drop-table –skip-lock-tables xxx | gzip > /home/xxx/www/xxx/wp-content/backup-db/1503319412_-xxx.sql.gz
(Manual)
/usr/local/bin/mysqldump –force –host=’xxx’ –user=’xxx’ –password=’xxx’ –default-character-set=”utf8″ –add-drop-table –skip-lock-tables xxx | gzip > /home/xxx/www/xxx/wp-content/backup-db/1503319519_-_xxx.sql.gz
Thread Starter
nagak
(@nagak)
Now I confirmed that both gzipped files and non-gzipped files are generated correctly.
Thank you very much for your help.
-
This reply was modified 8 years, 9 months ago by
nagak.
