in reply to Perl and MySql

I got it... here is how I did it:

from shell:
cd /var/lib/mysql ls -las # That listed all our databases... tar -cf databases_to_move.tar database_name database_name2 #once that finished I made sure it was there: ls -las mv databases_to_move.tar /home/path/to/public_html # make sure it moved: ls -las cd /home/path/to/public_html ls -las # Ok it was there now go login to the new database server at the new d +atacenter: cd /var/lib/mysql wget http://www.ourdomain.com/databases_to_move.tar # Make sure the tar file was transferred #(it was 7.82 Gigs so I had to do it in a bunch of files # that were about 800MB each) ls -las # once I made sure it was there I extracted the databases: tar -xf databases_to_move.tar # Remove the tar file rm -f databases_to_move.tar # make sure it was removed ls -las # all done.
That did it...

Thank you for all the information. I did a lot of reading on the links and information you provided.

Thanks again.
Richard