Forums / General Questions / Database check in PHPMyAdmin shows errors

Database check in PHPMyAdmin shows errors

Locked

Results 1 to 7 of 7

This thread is locked. New replies are disabled.

13 Mar 2008, 1:11 PM

dbrewster

Zen Follower

Join Date:: Jul 2005
Location:: Charlottesville, VA
Posts:: 376
Plugin Contributions:: 0

Database check in PHPMyAdmin shows errors

I was looking in PHPMyAdmin, I ran the database check function, and got a big list of advisories like this in both my sandbox and production stores:

corek2_zc135.admin
error : Table upgrade required. Please do "REPAIR TABLE admin" to fix it!

I ran the update on my sandbox, and all seems well, but since I don't know what it did, I hesitate to run it on my production site.

Safe to run? Advisable to do so? What does it do?

I've been running this site for almost 3 years, been upgrading along the way.

---Diana

13 Mar 2008, 4:20 PM

Kim

Obaa-san

Join Date:: Jun 2003
Location:: West Coast, North America
Posts:: 26,603
Plugin Contributions:: 0

Re: Database check in PHPMyAdmin shows errors

Has the version of MYSQL changed?

13 Mar 2008, 4:42 PM

dbrewster

Zen Follower

Join Date:: Jul 2005
Location:: Charlottesville, VA
Posts:: 376
Plugin Contributions:: 0

Re: Database check in PHPMyAdmin shows errors

I'm sure my web host has done some upgrades in the version of MySQL.

Pretty safe to run this PHPMySQL repair thing? (of course I will backup before!)

13 Mar 2008, 7:33 PM

dbrewster

Zen Follower

Join Date:: Jul 2005
Location:: Charlottesville, VA
Posts:: 376
Plugin Contributions:: 0

Re: Database check in PHPMyAdmin shows errors

... version 5.0.45-community now, but I'm sure it didn't start with that.

13 Mar 2008, 7:37 PM

Kim

Obaa-san

Join Date:: Jun 2003
Location:: West Coast, North America
Posts:: 26,603
Plugin Contributions:: 0

Re: Database check in PHPMyAdmin shows errors

:) Back up and then run the table repair - Might keep an eye out and let us know if you run into any further oddities.

13 Mar 2008, 7:58 PM

dbrewster

Zen Follower

Join Date:: Jul 2005
Location:: Charlottesville, VA
Posts:: 376
Plugin Contributions:: 0

Re: Database check in PHPMyAdmin shows errors

Database repair ran without error, and it looks like the website loads faster, too!

(I went ahead did this for all my web apps, they all reported need for repair!)

thanks Kim!

---Diana

13 Mar 2008, 8:51 PM

Kim

Obaa-san

Join Date:: Jun 2003
Location:: West Coast, North America
Posts:: 26,603
Plugin Contributions:: 0

Re: Database check in PHPMyAdmin shows errors

:clap: glad to hear it!