Re: I haven't any hair left - Moving an MySQL DB from one server to another...

Try to ensure nothing is accessing your databases - then copy your database directories to a temporary location, archive them up, transfer them to the new server and unpack them in $DATADIR - often mysql/var or mysql/data. Make sure they have the correct file permissions, then bring up mysqld on the new server and begin using your databases. It's an incredibly simple procedure - you definitely should not lose any hair over it. jason ----- Original Message ----- From: "David Smith" <webmaster@indywebdesign.com> To: <php-general@lists.php.net> Sent: Friday, January 05, 2001 4:49 PM Subject: [PHP] I haven't any hair left - Moving an MySQL DB from one server to another... > > I have purchased a dedicated server and I am trying to download my current > DB from a hosting company and upload it to my new dedicated server. I have > MySQLAdmin and it's an awesome program but continuosly getting errors trying > to import with the querys it displays to import to the new DB. Anyone help > me here? I have telnet to both servers... > > > Thanks... > > David Smith