|
You would have to use mysqldump in order to dump the data and the structure, and mysql to import the database from the .sql file created on your new server.
telnet or ssh into your box, and you would need to execute this line from your command line
mysqldump -u username -p --opt databasename > backup-file.sql
You will be asked for your password, then, move the backup-file.sql to your new server, and create a new database , then use the mysql command to import the file into your new database
mysql -u username -p databasename < backup-file.sql
HIt me up via icq at 118997859 if you have any further problems.
Midnight
|