Removed local database from phpmyadmin by mistake

[Soulkreed]

Hi Rod,
I have buggered up your instructions below

To do this, from the original 'priviliges' link, identify the zencart user, as before, click on the 'edit' icon at the RHS of the screen, and in the 'global priviliges' section located the 'data' block, and tick the 'file' checkbox (and no others). Save the changes, log out of phpmyadmin and re-log in using the zencart user account. The 'import' function should now appear.

Cheers
Rod

Instead of ticking the ' file ' box in the zen cart user edit section i ticked the ' file ' box ( and no others ) in the root account and now have no databases or anything remotely similar to how it used to look ( i think i am screwed )

Any suggestions....

[Vger]

When, in your local phpMyAdmin, you could not see the 'Import' tab this was not unusual. If you have an older version of phpMyAdmin then what you'll see is an 'SQL' tab, which you click on. Then you see a Browse link, which you click on. Then you locate the backup of your online db which you downloaded - and select that. Then you click 'Go' and it imports the backup.

It's no more complicated than that.

Vger

[RodG]

Instead of ticking the ' file ' box in the zen cart user edit section i ticked the ' file ' box ( and no others ) in the root account and now have no databases or anything remotely similar to how it used to look ( i think i am screwed )

Any suggestions....

Yes. Just log back in as the root/admin user, select 'privileges', tick *everything* in the global privileges section (use the 'check all' link)

Save your changes and you should be back where you were before you made the change.

As long as you can get back to this stage, try following vger's instructions .. personally I can't recall the 'import' tab not being visible on the older versions of phpMyAdmin, and knowing that you have a pretty new installation this possibility didn't even occur to me anyway.
(Thanks vger. Something worth remembering).

Anyway Soulkreed, even if you can't restore back to how things were before you can move forward, you still have another option.

As far as I'm aware from our previous discussions, the only thing you are currently using your mySQL database for is Zencart, correct? and since it is the zencart data you wish to restore I can see no reason why you couldn't just delete your current mySQL installation, reinstall it, and start afresh if you need to.

FWIW, when I first starting learning mySQL I probably trashed my databases/installation at least a dozen times (or more) before I came to grips with what I could and should change, and what I should leave alone. I must admit it was very frustrating at the time, but I really did learn a lot more than if I'd just blindly followed instructions and never had a problem. Your early 'screw ups' will eventually turn out to be to your benefit.

Cheers
Rod

[Soulkreed]

Hi,
I am unable to log back in, I don't know how to do it, sorry.
I only have one screen ( phpmyadmin-local ) that I go to when i click on the saved url in my favourites. This screen is no longer looking like it used to. Is it possible to show you a picture of the screen i am looking at which may shed some light on this?

In regards to deleting and re-installing a new mysql installation, i wouldn't know where to begin, any clues please?

Cheers

[Soulkreed]

Forgot to mention this, I have been trying to find the configure.php file from a new zen cart to overwrite the corrupted configure.php file in admin/includes.... on my current installation and i am unable to track it down, it's just not there anywhere..mystery to me.

All the configure.php files are there on my current store ( both in my admin/includes and my includes.. ) but not visible anywhere on a new zen cart ( one that i unzipped solely for taking out files )

Cheers.

[RodG]

Forgot to mention this, I have been trying to find the configure.php file from a new zen cart to overwrite the corrupted configure.php file in admin/includes.... on my current installation and i am unable to track it down, it's just not there anywhere..mystery to me.

All the configure.php files are there on my current store ( both in my admin/includes and my includes.. ) but not visible anywhere on a new zen cart ( one that i unzipped solely for taking out files )

Cheers.

The configure.php files are created during the installation process so you won't find them in the distribution package.

You *should* have uncorrupted copies on your local machine from the first installation that you did though. Just use those (making sure you update the various settings to match what is needed for your dot easy installation.

If for some reason you DON'T have a local copy, you can also use the files named "dist-configure.php" for recovery purposes (just make a copy and then rename to configure.php). Don't just rename these (as some people have done) because you never know when you may need them again.

Cheers
Rod

[RodG]

Hi,
I am unable to log back in, I don't know how to do it, sorry.
I only have one screen ( phpmyadmin-local ) that I go to when i click on the saved url in my favourites. This screen is no longer looking like it used to. Is it possible to show you a picture of the screen i am looking at which may shed some light on this?

Sure.

In regards to deleting and re-installing a new mysql installation, i wouldn't know where to begin, any clues please?
Cheers

Uninstalling should be possible from your windows control panel add/remove programs (or whatever Windoze calls it these days).

To re-install, just repeat the process you used the first time you installed it.

Also, if you are lucky, the 'uninstall' process may even give you an option to 'repair' the installation - If so, I'd be trying that out before doing an uninstall/re-install. Sorry I can't be any be explicit or definitive about this, but I don't run windows so I can't verify it for you.

Cheers
Rod

[Soulkreed]

Hi Rod,
thanks mate and evryone else for all your help, very much appreciated.
I did the configure.php overwrite of the corrupted one with the original version and there were a few little things i needed to fix which i did. It is now giving me this below

0 DB_ERROR_NOT_CONNECTED
in:
[select * from project_version WHERE project_version_key = 'Zen-Cart Database' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any clues...?

I am unable to find anywhere in my windows add/remove anything remotely that looks like a mysql file/folder/program, unless it's named something completely different.

I can't remember how to do the print screen thing to show you a copy of what the phpmyadmin page is now looking like ( i press the print screen button and then what...? ) but here is an attempt with the ctrl c and paste of the actual phpmyadmin screen, hope it sheds some light,

Welcome to phpMyAdmin 2.6.4-pl1

MySQL 4.1.14-nt running on localhost as root@localhost
phpMyAdmin - Logo
MySQL
Create new database Create new database: Documentation
No Privileges
Show processes Show processes Documentation
Character Sets and Collations Character Sets and Collations
Storage Engines Storage Engines
Databases Databases
Export Export

phpMyAdmin
Language
Language Info:
MySQL charset MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation
MySQL connection collation: armscii8_binarmscii8_general_ciascii_binascii_general_cibig5_binbig5_chinese_cib inarycp1250_bincp1250_croatian_cicp1250_czech_cscp1250_general_cicp1251_bincp125 1_bulgarian_cicp1251_general_cicp1251_general_cscp1251_ukrainian_cicp1256_bincp1 256_general_cicp1257_bincp1257_general_cicp1257_lithuanian_cicp850_bincp850_gene ral_cicp852_bincp852_general_cicp866_bincp866_general_cicp932_bincp932_japanese_ cidec8_bindec8_swedish_cieuckr_bineuckr_korean_cigb2312_bingb2312_chinese_cigbk_ bingbk_chinese_cigeostd8_bingeostd8_general_cigreek_bingreek_general_cihebrew_bi nhebrew_general_cihp8_binhp8_english_cikeybcs2_binkeybcs2_general_cikoi8r_binkoi 8r_general_cikoi8u_binkoi8u_general_cilatin1_binlatin1_danish_cilatin1_general_c ilatin1_general_cslatin1_german1_cilatin1_german2_cilatin1_spanish_cilatin1_swed ish_cilatin2_binlatin2_croatian_cilatin2_czech_cslatin2_general_cilatin2_hungari an_cilatin5_binlatin5_turkish_cilatin7_binlatin7_estonian_cslatin7_general_cilat in7_general_csmacce_binmacce_general_cimacroman_binmacroman_general_cisjis_binsj is_japanese_ciswe7_binswe7_swedish_citis620_bintis620_thai_ciucs2_binucs2_czech_ ciucs2_danish_ciucs2_estonian_ciucs2_general_ciucs2_icelandic_ciucs2_latvian_ciu cs2_lithuanian_ciucs2_persian_ciucs2_polish_ciucs2_roman_ciucs2_romanian_ciucs2_ slovak_ciucs2_slovenian_ciucs2_spanish2_ciucs2_spanish_ciucs2_swedish_ciucs2_tur kish_ciucs2_unicode_ciujis_binujis_japanese_ciutf8_binutf8_czech_ciutf8_danish_c iutf8_estonian_ciutf8_general_ciutf8_icelandic_ciutf8_latvian_ciutf8_lithuanian_ ciutf8_persian_ciutf8_polish_ciutf8_roman_ciutf8_romanian_ciutf8_slovak_ciutf8_s lovenian_ciutf8_spanish2_ciutf8_spanish_ciutf8_swedish_ciutf8_turkish_ciutf8_uni code_ci Documentation
Theme / Style
Theme / Style:
phpMyAdmin documentation phpMyAdmin documentation
Official phpMyAdmin Homepage Official phpMyAdmin Homepage
[ChangeLog] [CVS] [Lists]
Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole.

I don't know what alot of this extra stuff is here in the middle but it certainly isn't on the page i just copied, perhaps it just shows up when copying and pasting.

Ciao for now, Ash.

[RodG]

I did the configure.php overwrite of the corrupted one with the original version and there were a few little things i needed to fix which i did. It is now giving me this below

0 DB_ERROR_NOT_CONNECTED

A part of the configure.php files (there are TWO of them) specifies the logon details (and a couple of other things) for the database. Did you set these correctly? Both files?

I am unable to find anywhere in my windows add/remove anything remotely that looks like a mysql file/folder/program, unless it's named something completely different.

Time to stop and take a step or two backwards.

You are telling us things in one message that may require specific actions that you need to take to correct the problem, yet in other messages, (such as this one) you are providing information that shows without a doubt that the information originally supplied was incorrect or incomplete, and as such you are basically digging yourself into a deeper and deeper hole.

Welcome to phpMyAdmin 2.6.4-pl1

MySQL 4.1.14-nt running on localhost as root@localhost
<snip>
Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account.

The latest problem we were trying to solve was your inability to login to
phpMyAdmin, which was supposedly caused by the incorrect changing of the mysql administrator priviliges.(and this was in an attempt to fix yet another issue entirely). The 'last resort' option to fixing the login issue was to be to re-install your mySQL database.

You have now shown us positive proof that you CAN log into phpMyAdmin (and therefore the mySQL database), so the re-install is now a moot point. It also totally contradicts what you told us in the first place.

I really don't know what to tell you from here, as I said, you are providing misleading information (albeit, not intentional), and based on this information I/we are giving you answers that you don't need, which you are acting upon anyway, messing up even further when doing so, and in short getting further and further away from the original problem (inability to import your backup data).

So, you tell me .... where do you want to go from here? I no longer even know where to start

Cheers
Rod

[Soulkreed]

Hi Rod,
i am unsure of what to do myself. I simply cannot for reasons most likely of my own lack of knowledge here in regards to certain procedures and the like, navigate my way around the phpmyadmin page/s, a couple of the things you have asked me to do I have no knowledge of them and i am trying to find these things to put the actions into place you have suggested. I am already logged in as you have seen by my previous post ( cool ) i knew i was logged into something i just didn't know if it was the right one or not. ( that's that out of the way then ) In regards to re-installing the mysql file as described by vger below

[ quote = vger ]

When, in your local phpMyAdmin, you could not see the 'Import' tab this was not unusual. If you have an older version of phpMyAdmin then what you'll see is an 'SQL' tab, which you click on. Then you see a Browse link, which you click on. Then you locate the backup of your online db which you downloaded - and select that. Then you click 'Go' and it imports the backup.

It's no more complicated than that.

Vger

[ / quote ]

I no longer have these options on my screen at all, the only thing that is there that say's SQL is a query window and a documentation window, ntohing that opens to a browse option or anything remotely like that, none of the other tabs lead to anything at all like the option explained by vger, it just isn't there.

Cheers