Mysql Backup in DB Utilities

[eluser]megabyte[/eluser]
You have to move to another server.

You use the backup function in the DB Utilities to create a dump file to import into phpmyadmin on your new server.

Problem:

Old server has magic quotes on, and new server has them off. (maybe a rare occurence, but it can happen and did for me.)So when you go to dump the sql file you get errors because quotes were nto escaped.

The fix:

DB utilities should have its own function escape_str($str) that does not care if magic quotes is off or on, and should escpape all data anyway.