LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   dashes in a mysql database (https://www.linuxquestions.org/questions/linux-software-2/dashes-in-a-mysql-database-4175516343/)

Habitual 08-25-2014 04:52 PM

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/
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.

j-ray 08-26-2014 01:42 AM

Within strings PHP will not treat dashes as minus.

Habitual 08-26-2014 09:25 AM

Thanks j-ray.


All times are GMT -5. The time now is 12:44 PM.