Removed local database from phpmyadmin by mistake

[Soulkreed]

Hi Rod,
I'm back, lol. I need some help please. ( with my test/local install of zen cart - not my live zencart )
The issue I was having in regards to not being able to work the phpmyadmin ( local ) has been fixed via me deleting everything and starting from scratch again. I now have a working url ( store ) and a fully functional phpmyadmin on my localhost. What I would now like to do is import my saved sql table/files into the now fresh install of zen cart. I did try it before and stuffed it all up. I imported the saved sql files and it put them on there but when i clicked on the store refresh button nothing had actually changed, in my attempt at fixing/solving this problem i stuffed it all up and had to re install the zen cart from scratch once again.
I am now asking for help, it would seem this should be an easy enough task to do but I am missing something here, does anyone have any help/suggestions for going forward here please.

Thanks in advance.
Ash.

[RodG]

but when i clicked on the store refresh button nothing had actually changed,

This is common with many changes to the store, on account of the fact that much of the data is cached.

The basic rule is If you make a change that doesn't have the effect you are expecting, it is because the data is being fed from a cache, or the change you made wasn't the change that needed to be made.

Until proven otherwise always assume it is a cache problem before looking for other causes.

Cheers
Rod

[Soulkreed]

Hi Rod,
I have performed a ( ipconfig/flushdns ) also a ( net stop dnscache ) and a ( net start dnscache ) all from the command prompt window and I am still not seeing any results on my local test zen cart store or the admin section.

Any clues please?
Cheers, Ash.

[RodG]

Hi Rod,
I have performed a ( ipconfig/flushdns ) also a ( net stop dnscache ) and a ( net start dnscache ) all from the command prompt window and I am still not seeing any results on my local test zen cart store or the admin section.

Any clues please?
Cheers, Ash.

Firstly, it is your web-browser cache that possibly caused your original 'no change' symptom, rather than DNS cache.

Secondly, just clearing the cache(s) now isn't going to solve the issue if you had already moved on and made other changes. This is simply compounding the problems.

You need to go all the way back to

" now have a working url ( store ) and a fully functional phpmyadmin on my localhost. What I would now like to do is import my saved sql table/files into the now fresh install of zen cart.

Then do the import, and if you don't see the result of the import you will need to clear your browser cache BEFORE moving ahead with other changes.

Cheers
Rod

[Soulkreed]

Ok, I have cleared the browsers cache and went back and deleted the zen cart install and re-installed it again and uploaded the saved SQL backup files and still nothing has changed in my store front.
I know that the files are there as the files amount has gone from zencart 93 to zencart 190 in the drop down box in the left field of phpmyadmin.
Ok, now if I have done these things correctly that should cancel it out as being a browser cache problem?

Ok, what's next on the check list please?

Cheers mate. ( by the way, merry xmas and a happy new year and a big THANKING YOU for all your help )

[RodG]

Ok, I have cleared the browsers cache and went back and deleted the zen cart install and re-installed it again and uploaded the saved SQL backup files and still nothing has changed in my store front.

Although no longer relevant (due to further information that you have supplied), it is at this point where you would need to be clearing your cache.

I know that the files are there as the files amount has gone from zencart 93 to zencart 190 in the drop down box in the left field of phpmyadmin.

To avoid confusion, these should always be referred to as 'database tables' rather than files.

Ok, now if I have done these things correctly that should cancel it out as being a browser cache problem?

Not in itself, but the fact that your database tables have doubled tells us that you haven't really imported any 'new' data for the store, you have created a complete new set of tables that the store doesn't 'know' about.

Ok, what's next on the check list please?

I'm guessing that the doubling up of the database tables is caused by a prefix mismatch. On your live server your database tables are prefixed with 'soulk_' (or something like that), but on your local machine you are probably using 'zen_' or perhaps no prefix at all.

The solution is to ensure the correct prefix is specified in your configure files.

My personal approach would be to re-install zencart (again) on the local machine, and ensure I use the same prefix that is used on the live server.

Cheers
Rod

[Soulkreed]

I have done as you said, I have deleted and re-installed everything and have made the prefix match the live server. ( soulkr_ ) ( the prefixs in the configure files both matched, they are both soulkr_ and I changed the prefix in the install to soulkr_ as well ) the only thing I am not sure about is the SQL table file backup itself, am i to change anything in that at all ?, I had a look and couldn't find anything like soulkr_ or zen_ in there using a text editor.
I am still getting the doubling up of my database tables from 93 to 190. There is no change reflected in my store front.

Ash.

[RodG]

I am still getting the doubling up of my database tables from 93 to 190.

Regardless of anything else, this is still the issue you need to resolve.

The first table in a default zencart database with a "zen_" prefix is called
"zen_address_book"

In your case it will be "soulkr_address_book" (before any imports). After the import you'll find that there is another "??????_address_book.
What is the name you get in the place that I've used question marks?

Cheers
Rod

[Soulkreed]

I am looking in phpmyadmin at the tables and there is one address_book at the very top and one soulk_address_book about half way down.

I cannot find any other address_book anywhere, just these two.

Cheers.

[RodG]

I am looking in phpmyadmin at the tables and there is one address_book at the very top and one soulk_address_book about half way down.

This is your prefix mismatch.

One of those entries is from your local installation, the other is from your imported tables. (You'll find similar duplication with all the other tables).

You *must* make these table names match (and/or edit the local config files to match the table names created by the import).

Cheers
Rod