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
Code:
/var/lib/mysql/aa@002dbb@002dcc@002ddd/
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.