weird error in Optimize Database

07 Jan 2008, 12:20

#1

New Zenner

Join Date:: Feb 2007
Posts:: 63
Plugin Contributions:: 0

weird error in Optimize Database

Hi,

When I want to Optimize Database my database through admincp to remove wasted space from deleted records.

After I click on confirm i get the following;

1044 Access denied for user 'v-mus'@'%' to database 'v'
in:
[SHOW TABLE STATUS FROM v-mus]
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.

what should I do?

Thanks

Saman-

07 Jan 2008, 21:27

#2

saman

New Zenner

Join Date:: Feb 2007
Posts:: 63
Plugin Contributions:: 0

Re: weird error in Optimize Database

come on guys, please anyone?

07 Jan 2008, 21:53

#3

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: weird error in Optimize Database

saman:

1044 Access denied for user 'v-mus'@'%' to database 'v'
in:
[SHOW TABLE STATUS FROM v-mus]

a. "1044 Access denied" ... means ... access was denied
b. "user 'v-mus'@'%' " -- refers to the database user account named v-mus from any server addresses (the % is a wildcard)
c. "database 'v' " -- this is the database it was trying to access
d. SHOW TABLE STATUS FROM v-mus --- this is the SQL query it was trying to run.

Thus, according to the error, it means your v-mus user account doesn't have permission go run the SHOW TABLE STATUS query, which is used by the store_manager script to get a list of all tables to optimize.

So, you can either fix your permissions problem (talk to your host if you're uncertain how), or don't use the script.

Were you intending to run the optimize script because you know exactly what you're doing with it? or did you just see it in the list and figure you'd try it out?
There are other ways to do table optimization, such as via phpMyAdmin.

08 Jan 2008, 14:43

#4

saman

New Zenner

Join Date:: Feb 2007
Posts:: 63
Plugin Contributions:: 0

Re: weird error in Optimize Database

DrByte:

Were you intending to run the optimize script because you know exactly what you're doing with it? or did you just see it in the list and figure you'd try it out?
There are other ways to do table optimization, such as via phpMyAdmin.

Thanks for the reply. Once in a while I do that to cleanup...
My database is performing a little slow so i Thought I should cleanup some maybe it helps...

How should I cleanup/check if there are some tables which should be cleanedup to improve the speed etc.

I know that it could be a server issue but I also want to try if its anything else

Thanks:smile:

08 Jan 2008, 20:26

#5

website_rob

Inactive

Join Date:: Oct 2006
Posts:: 4,572
Plugin Contributions:: 0

Re: weird error in Optimize Database

When I want to Optimize Database my database through admincp to remove wasted space from deleted records.

Define "admincp". Is is phpMyAdmin, your Control Panel (i.e. cPanel), or some other panel?

Both phpMyAdmin & cPanel give the option to Optimize / Repair databases but the correct Username must always be used.

09 Jan 2008, 14:44

#6

saman

New Zenner

Join Date:: Feb 2007
Posts:: 63
Plugin Contributions:: 0

Re: weird error in Optimize Database

Website Rob:
Define "admincp". Is is phpMyAdmin, your Control Panel (i.e. cPanel), or some other panel?

Both phpMyAdmin & cPanel give the option to Optimize / Repair databases but the correct Username must always be used.

its phpmyadmin

what is the best way to that through phpmyadmin?

thanks

09 Jan 2008, 16:34

#7

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: weird error in Optimize Database

To do it via phpMyAdmin, you click on one table at a time. Click the Operations tab. Choose the Optimize Table option, and Go. Repeat for each table.

09 Jan 2008, 20:55

#8

website_rob

Inactive

Join Date:: Oct 2006
Posts:: 4,572
Plugin Contributions:: 0

Re: weird error in Optimize Database

Would it not be faster in phpMyAdmin, to use the Select All link (for all Tables) then choose Optimize or Repair from the drop-down list near the page bottom?

That method usually works well for me.

10 Jan 2008, 07:51

#9

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: weird error in Optimize Database

Website Rob:
Would it not be faster in phpMyAdmin, to use the Select All link (for all Tables) then choose Optimize or Repair from the drop-down list near the page bottom?

That method usually works well for me.

If you have that option, then yes, that would be less laborious.

06 Oct 2009, 01:21

#10

emrico1

New Zenner

Join Date:: Mar 2009
Posts:: 55
Plugin Contributions:: 0

Re: weird error in Optimize Database

For anyone wondering how to do this.

- Backup your Database via Cpanel>phpMyAdmin
- "Click on the database you are working with on the left hand side frame (not the table, the database name)
On the right hand column your tables should be listed. Scroll down till you see the “Check all” link.
Click on that link, make sure all database tables are checked and then from the dropdown next to it, carefully select “Optimize table”.