Error 1044 when moving database to new server

[mc12345678]

I have cashexch_ I presume that's the table name?
The full name is cashexch_ingleburncashexchange

There is a difference between a prefix for the database name and the prefix that is prepended to "every" table within the database... Following kobra's suggestion, if you look at the first table in the database or at the sql that was uploaded, do you have a table named admin or one that has something before the word admin? Also how many tables are there? Somewhere around 100? Or 200? Or more?

[Annie_zaz]

There is a difference between a prefix for the database name and the prefix that is prepended to "every" table within the database... Following kobra's suggestion, if you look at the first table in the database or at the sql that was uploaded, do you have a table named admin or one that has something before the word admin? Also how many tables are there? Somewhere around 100? Or 200? Or more?

Hello,
On the left hand side I see half way down kinectwe infront of the tables. I have 194 tables.

[mc12345678]

Hello,
On the left hand side I see half way down kinectwe infront of the tables. I have 194 tables.

That may be because of one of the above actions as well... Btw, in the future if going to use a prefix, it is suggested that it end with an underscore for example... It helps with reading it as well as for any type of table name manipulations.

But both appear to be present in that database, in particular by the total number of tables... It is as if two installs are present... One with a prefix of 'kinectwe' the other with a prefix of ''

Should be able to look at the sql of the file being iimported to see if it has the prefix of kinectwe on all (most) of the tables as well... If both sets of the tables are present in the sql file, then need to figure out which is more recent as it is likely the one that was active on the store being moved... There are dates that are logged for various things which should make that discovery relatively easy...