So, I'm doing this migration of Wordpress sites (ok, 520 of them, eek)
and one of the databases has dashes, or hyphens in it.
and I expect even more to have these dashes.

Near as I can tell the original host (phpmyadmin 2.8.1 login only shows)
"MySQL - 4.1.12" and "MySQL client version: 4.1.12"
The new db host has version: 5.1.73

The client did an export and imported it onto the new host I don't know how, Workbench, TOAD, something and it shows up on the new host as and shows up in "show databases" as aa-bb-cc-dd

I had to use backticks around the aa-bb-cc-dd when I issued the grant. No big deal there.

My concern is if I don't change the db to aa_bb_cc_dd I've read that all sorts of scary things will come up, such as mysqldump hates dashes|hyphens, and
I may have some unintended side-affects wrt: PHP code. (PHP treats dashes as minus no matter how they're escaped)?

Can someone tell me if we can expect Zero code changes if I allow the database name on the new host to remain with dashes?

GOD, I hope this isn't too confusing to anyone.

Thanks for your valuable time.

Within strings PHP will not treat dashes as minus.

1 members found this post helpful.

Thanks j-ray.