Changing default encoding

**knows MySQLDumper** Age: 51 Joined: 31 Jul 2011 Posts: 2

I have recently 'discovered' MySQLDumper 1.24.4 and have found it to be a great tool for managing database dumps between my development machine and production servers by using the automatic FTP transfer.

I now have a client that uses Thai text within their database and a restore of a local dump using the default utf8 caused the site to display in an unreadable form.

The live site has the following variables :

character set client utf8
(Global value) tis620
character set connection utf8
(Global value) tis620

My development site has

character set client utf8
(Global value) tis620
character set connection tis620

As I am developing a utility for a customer to automatically update their internet site from their intranet site at the end of each day, they need to remember to select tis620 in the dropdown for the backup or the internet site displays incorrectly.

Is there a way to change the default encoding or to simply hard code the encoding for them?

Thanks

Posted: 2011-07-31, 11:52 (No subject)

MySQLDumper pre-selects the detected standard encoding of the MySQL server.
Nevertheless you could overwrite this to fit your special needs.
Open the file filemanagement.php and change line 23 from

**knows MySQLDumper** Age: 51 Joined: 31 Jul 2011 Posts: 2

Many thanks.

I've had to strip out many of the options that deleopers would use, but now they will have a simple solution to backup, transfer and restore without being able to do any 'damage'.

Nice software!