sql backup problems

[TF-Host]

Hello all..

i seem to be having issues with my sql databases. for some reason i dont seem to be able to take a complete backup.... None of my clients can take a backup. nor can i take a full backup...

is there any possible way i can root a complete repair on all the databases or check/optimize them from my root login?

 

[floyd]

You can analyze, optimize, and repair databases from phpmyadmin.

If the databases are large then you will have to do it from the command line using mysqlcheck.

 

[TF-Host]

You can analyze, optimize, and repair databases from phpmyadmin.

If the databases are large then you will have to do it from the command line using mysqlcheck.

well there is quite alot hosted on the server. so checkin them all would be great. would it be possible for you to show me the way to this command line? ive only ever done a repair/optimize through phpmyadmin, and this wont allow me to select all the databases under each user name

thanks

 

[floyd]

and this wont allow me to select all the databases under each user name

It does if you login as da_admin.

would it be possible for you to show me the way to this command line

Google is your friend.

The first link for searching mysqlcheck is http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html