Re: moving databases question...

2002-05-07 Thread Alexander Keremidarski
Hi, Richard Idalski wrote: I have before me what seems to be a very daunting task to someone with my limited SQL knowledge. I'm upgrading our ad server which runs on MySQL 3.22.32 to a newer machine and MySQL 3.23.39. Right now there are 16GB worth of databases that need to be transferred

Re: moving databases question...

2002-05-07 Thread Ron Beck
While I haven't tested this, you might try something like... mysqldump -h host -u userid -p database | mysql -h newhost -u new_userid -p database or, share out and NFS mount the new system's partition to the old system and do a dump that way. Just a few thoughts, Ron Richard Idalski

moving databases question...

2002-05-06 Thread Richard Idalski
I have before me what seems to be a very daunting task to someone with my limited SQL knowledge. I'm upgrading our ad server which runs on MySQL 3.22.32 to a newer machine and MySQL 3.23.39. Right now there are 16GB worth of databases that need to be transferred over, and the old server lacks