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 >