Changing Servers -- Question

[Jim O]

I'm changing from a Windows based server where I do not have telnet access to a Linux server. I have read the manual on creating a dump using telnet and then uploading, etc. What I was wondering was whether I could use phpMyAdmin to create the dump and then import it on the other end the same way. I also have Navicat MySQL which I use for ODBC with a MySQL database for another application. That also can backup and restore. Is there any reason why that would not work?

Thanks in advance...

[Colin F]

If you don't have SSH access, then I recommend you use something like mysqldumper (http://www.mysqldumper.de/en/index.php)to backup the database.

[Jim O]

Sorry if this is a dumb question but will it also move attachments that are stored in the db?

[Colin F]

Yes.

[Jim O]

Many thanks!