How can I move a database?

[bdunning]

I have a whole bunch of databases on a number of different PW accounts. I am about to move everything over to ****. What's the easiest way to download a whole database into some format that can be easily uploaded to my new server -- would it be to use the Export function in phpMyAdmin?

Thanks for any suggestions.

[BerksWebGuy]

Most likely a dump would be the best.

See this thread to get a start:
http://forum.powweb.com/showthread.php?t=60555

Even if you can't "put" the dump into your new host, you can still easily modify the script to only "get" the dump, then download it. You can also do this via http://phpmyadmin.powweb.com

[bdunning]

I like that script. Where would I download that dump from? I'm not clear where it puts it.

[BerksWebGuy]

The dump file will be in your root home directory (with htdocs and cgi-bin).

[agunther]

Actually, if you use the script the way it is right now, the DB will end up in your home directory:
$filename="/www/u/username/dbbackup_$day.sql";

Andre
http://www.aguntherphotography.com