MySQL database import error

[xikan]

Hi guys

I'm currently moving my Zen cart project to another server.
The new server has a MySQL database.

when i try to recreate the database (using an SQL dump), it says access denied. It seems the new database server doesn't allow schema names with the '_' character.

If I change the schema name, will this cause an error i.e does Zen Cart make reference the schema name anywhere in its code?

Thanks,

[DrByte]

It's likely not the "_" character, but rather that you're doing your dump wrong and thus trying to run prohibited commands during your import.

When you take your database backup, do it *after* already selecting your database from the pulldown.
That should stop it from putting the CREATE DATABASE and USE DATABASE commands in your sql dump file, which are prohibited by most hosts.
Related FAQ: https://www.zen-cart.com/tutorials/i...hp?article=103