dashes in a mysql database
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/ 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.
|
Thanks j-ray.
|
All times are GMT -5. The time now is 12:44 PM. |