Backup/Restore mysql charasets

Version 1.51


Backup and restore of databases should maintain same character-sets. Related query for backup: SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'username_dbname'; mysqldump -uUSERNAME -pPASSWORD --default-character-set=utf8 USER_DATABASE > backup.sql Related restore: mysql -uUSERNAME -pPASSWORD --default-character-set=utf8 USER_DATABASE < backup.sql New directadmin.conf option: extra_mysql_restore_options internal default is null (unset), but you can add it to your directadmin.conf, to add extra options, eg: extra_mysql_restore_options=--default-character-set=utf8

Interested to try DirectAdmin? Get a 30-day Free Trial!