it wouldn't let me do myisamchk -r /var/lib/mysql/*/*MYI since there
were so many files..
so I did this:
/etc/rc.d/init.d/mysql stop
for i in /var/lib/mysql/*; do
        for j in ${i}/*MYI; do
                myisamchk -r ${j}
        done;
done;
/etc/rc.d/init.d/mysql start

clayton



On Fri, 25 Mar 2005 14:39:38 -0600, fci <ces.fci at gmail.com> wrote:
> so I am going to be importing several mysql databases into a "fresh"
> server mysql install that already has 40 empty databases for some
> reason.
> my plan right now is to
> cp -R /var/lib/mysql /var/lib/mysql_backup (only in case the actions
> following this action fails)
> 
> then go into phpMyAdmin to drop all the databases while logged in as
> the root mysql user(including mysql db).
> then mysql -uroot < new_databases.sql
> 
> I'm just wondering if this will be okay.. my guess is that it might be
> okay.. but I usually second guess myself so I figured I would ask
> first.
> 
> clayton
>