Error 1044 when moving database to new server

[Annie_zaz]

I am moving a site to a new server.
My old server had a prefix of kinectwe_ and the new server has a prefix of cashexch_ . Also my sql backup file (from old server) is called kinectwe_ingleburncashexchange.sql .
I am following these instructions https://www.zen-cart.com/content.php...fferent-server
I have followed all steps ok, however when I get to step 5D (import into database) I encounter a 1044 error:
--
-- Database: `kinectwe_ingleburncashexchange`
--
CREATE DATABASE IF NOT EXISTS `kinectwe_ingleburncashexchange` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci;


MySQL said: Documentation

#1044 - Access denied for user 'cashexch'@'localhost' to database 'kinectwe_ingleburncashexchange'

In step 2a it says: IMPORTANT: when asked about the database-table-prefix during Database-Setup, use the same prefix that your old store uses.
I have this in my includes/configure.php and admin/includes/configure.php. Did I do that correctly?

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'kinectwe');
define('DB_CHARSET', 'utf8');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'cashexch_ice');
define('DB_SERVER_PASSWORD', 'XXXXX');
define('DB_DATABASE', 'cashexch_ingleburncashexchange');

[kobra]

I am supposing that you have created a database already - if not do so in the account control panel

Then if your backup has the "CREATE DATABASE IF NOT EXISTS" function enabled
Create another backup without it

Then use phpmyadmin to import the backup into the DB you have created

[Annie_zaz]

I am supposing that you have created a database already - if not do so in the account control panel

Then if your backup has the "CREATE DATABASE IF NOT EXISTS" function enabled
Create another backup without it

Then use phpmyadmin to import the backup into the DB you have created

Hi Kobra,
I have created a database via the CP.
I just did another sql backup without CREATE DATABASE checkmarked and it uploaded. But now I'm getting an 0071 error !!!
http://www.zen-cart.com/content.php?...ce-is-required
So now I'm trying to sort that one out.

[Annie_zaz]

Hi Kobra,
I have created a database via the CP.
I just did another sql backup without CREATE DATABASE checkmarked and it uploaded. But now I'm getting an 0071 error !!!
http://www.zen-cart.com/content.php?...ce-is-required
So now I'm trying to sort that one out.

Kobra, do you think I should change all instances of cashexch_ to kinectwe_ in the configure files?

[kobra]

To manually figure out the correct prefix to use, look at the database using phpMyAdmin and see what common 2-4 letter prefix starts all the tablenames.

Check using phpmyadmin that tables do exist and what the prefix actually is

[Annie_zaz]

Check using phpmyadmin that tables do exist and what the prefix actually is

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

[Ajeh]

I would also suggest changing your database password as soon as you can ...

[Annie_zaz]

I would also suggest changing your database password as soon as you can ...

Thanks I will do that now.

[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]

I ended up making the site work. I still don't know what was wrong, maybe a table or configure.php file thing.
But what I did to correct it was upload a zc_install and reinstall it using the files from the old site and voila it worked.