A short time ago I had a mysql database for a mambo web site I set up for a Chinese friend of mine. She painstakingly entered all her content in Chinese and the site worked fine. I made backups using mysqldump on a nightly basis. When the nevitable happened and I came to restore her database, all of the Chinese characters had turned into gobbldy gook<nobr> <wbr></nobr>:-( How can I get my backup to restore properly?
Also, wrt to network backup, much simpler to just run the backup as a cron job on the backup host and specify port / hostname to the database server when doing the database dump. Of course ssh / rsync is better in htat you can compress the backup down before passing it over the network....
Learn about Linux
Download Linux
Get Linux help
Backing up databaases with UTF-8 data
Posted by: tim_qgis on December 28, 2004 06:21 PMAlso, wrt to network backup, much simpler to just run the backup as a cron job on the backup host and specify port / hostname to the database server when doing the database dump. Of course ssh / rsync is better in htat you can compress the backup down before passing it over the network....
#