Fresh Install But Importing SQL ERROR

[Xiao]

SQL BackUp From 1.2.3 Importing to new install of 1.2.4

I made a new database same server ServerName_CustomName
When i try to import the .zip file i get the following error

Error in ZIP archive: CRC32 checksum is not equal with the value in header information.

If i extract the sql file and import it i get the following error

Error

SQL query: 

--
-- Database: `roothack_prestashop`
--
-- --------------------------------------------------------
--
-- Table structure for table `ps_access`
--
CREATE TABLE `ps_access` (
`id_profile` int( 10 ) unsigned NOT NULL ,
`id_tab` int( 10 ) unsigned NOT NULL ,
`view` int( 11 ) NOT NULL ,
`add` int( 11 ) NOT NULL ,
`edit` int( 11 ) NOT NULL ,
`delete` int( 11 ) NOT NULL ,
PRIMARY KEY ( `id_profile` , `id_tab` ) 
) ENGINE = MYISAM DEFAULT CHARSET = utf8;



MySQL said:  
#1050 - Table 'ps_access' already exists

[TropischBruin]

How obvious:

MySQL said:
#1050 - Table 'ps_access' already exists

Empty your database (drop tables) before you upload the zip again.

[Xiao]

How obvious:

MySQL said:
#1050 - Table 'ps_access' already exists

Empty your database (drop tables) before you upload the zip again.

Even if the database back up is from 1.2.3 and the new install is 1.2.4?

[TropischBruin]

Why would you import a database if you already have one?

[Xiao]

because i wish to do a fresh install as i have a currency bug which the developers are unable to recreate on their end

I did wat u said and it worked

But now if i try to login to admin i get this error

There is 1 error
employee does not exist, or bad password

Admin Folder is different name from the old install
I tried to change it to the same name but it still wont work


All coustomers passwords are unable to be accessed

[TropischBruin]

You should restore your backup and then do an update but NOT a fresh install.
You have corrupted your database I'll guess.

Just to be sure.

What you need to do is make a backup and restore this on a local or differend server to perform a test migration before doing this on you live shop.

Important, before you start:

1. Make sure you disable Friendly urls and third-party modules.
2. Switch over to the original/default theme that comes with your version of PS.
3. Copy, just before the actual update, an empty .htaccess in the root of your site.

Upgrade from 1.1.0.5 (is this 1.1 Final?) to 1.2.4.0 Final in one go (do not (ever) use the beta releases).

You can find all versions: here.

How to upgrade can be read: here.

[Xiao]

well the new install did not solve my currency problem