Migrate to different server

Hi...

How should I transfer mysql data in a server to another one. Both servers has no Phpmyadmin installed .

Please do advice

thanks

If you have command-line access try using mysqldump which generates a sql file that will completely recreate your database.

Hadley

hello.. i'm new here.. i hope i can learn something from here..

You can install phpMyAdmin on your own. It has a pretty simple installation, or write your own PHP / Perl program to execute the queries to mySQL server.

Using mysqldump -u <username> -p -h <hostname> <database> [<tables>] and redirecting the output to a file is the easiest way to get the data. To pull it into a new database, you'd use the mysql command line tool, create the database, use the database, and issue "source <filename>" to slurp the results of your file into the database.

Yes thats the best way to do, but that requires Command Line Access.

True, but so does installing phpMyAdmin (to the shell, if not to mysql, but chances are that if you've got shell access, you've got the mysql cli).