how to fix MySQL database [Solved]

[lambiv]

Ok, so this wasn't clever...

I was without internet for a few days so had been working on a website that I had set up offline in XAMPP (on Window's Vista, the website uses Joomla and Virtuemart). I ran out of things I could do without having internet so decided I would start on another website, also offline. I'm pretty new to XAMPP and Joomla so thought I would just be able to create another folder, put another installation of Joomla in it and create another database for it to run off. Which I done and it was all looking good for the new site. The problem is, when I went back to view my original site, which I've spent a lot of time creating, I now get the message 'Database Error: Unable to connect to the database:Could not connect to MySQL', same if I try and access the administrator area of the site.

So I guess I stuffed up. If I open up the XAMPP control panel and try and go to the MySQL admin page then I also get the message 'phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.'

From having a bit of a Google search, I'm thinking that the old site no longer works because it's now pointing to the new database and all the settings are wrong? (hence the username and password are incorrect). Unfortunately I have no idea how to fix this. My problem also is that I can't actually remember what the database user name and password were... And can't access the admin page to check or change these.....

Help! I really don't want to lose the old site as I've spent a load of time getting it right. If anyone knows a way to recover the site I would be extremely grateful!

[JonB]

OK - here's a suggestion -

Use a tool to do the work. Oracle, the 'owners' of MySQL have a database tool called MySQL Workbench. It can connect to local or remote databases, with or without XAMPP or phpMyAdmin. You will only have to be able to start MySQL on the target machine (presumably your machine).

As long as you know the 'root' password, you will be able to work with, and.or extract/export your database, fix users/passwords etc.
If you DON'T know the 'root' PW for the local MySQL instance, XAMPP has a 'resetroot.bat' script in the \xampp\mysql folder. If 'resetroot' chokes there's a fix on my XAMPP site:

http://bravo.newnetenterprises.com/word ... for-mysql/

I design databases for a living and MySQL Workbench is one of my favorite tools, and its FREE (unlike many others) plus it works the same on both my Windows and Linux workstations. There are a few things phpMyAdmin can do better, and neither is a replacement for 'power tools' like Navicat Enterprise. But for what you want to do, its ideal.

http://www.mysql.com/products/workbench/

Good Luck

[lambiv]

Yay! I have my website back! Thank you SO much!

I couldn't use the Workbench tool at first as I didn't know the password. I tried running the 'resetroot' script which didn't work at first but I realised after looking at the tips on your website that it was because I hadn't stopped the database running first. I stopped that in the XAMPP control panel and the script then ran successfully. This let me access the XAMPP admin page again so I deleted the new database I had created (not sure if this was necessary but it seemed like a good plan). Anyway, checked the original site and it is now back exactly as it was before I done this which is fantastic, thank you very, very much!

PS - the Workbench tool also now works and I'm sure it will be a useful tool to have in future

[JonB]

Well that's great - Good luck and I'm glad it worked out..

[alva]

When my MySQL file got damaged I was very annoyed. I don’t want to lose my important files but as came across MySQL Repair Tool I was really happy this repair tool is very helpful in order to recover the damaged, corrupted or inaccessible file. Hope it will be useful to you.For more information follow the link:

http://mysql.filerepairtool.net/