weird error in Optimize Database

[saman]

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-

[saman]

come on guys, please anyone?

[DrByte]

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.

[saman]

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

[Website Rob]

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.

[saman]

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

[DrByte]

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.

[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.

[DrByte]

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.

[Emrico1]

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”.