Moving to a new server

[ezytrak]

Would some explain the best way of transferring my phpdig database to a new server ie what file to i need copy database of urls ie

[Charter]

If you have access to shell, you can use the following commands. See http://dev.mysql.com/doc/mysql/en/mysqldump.html for more info about mysqldump. Capitalizations represent your database information. Add your table prefix to the table names if needed.

# make backup
shell> mysqldump -h LOCALHOST -u DBUSER -p --opt DBNAME clicks engine excludes includes keywords logs site_page sites spider tempspider > phpdig187backup.sql

# install backup
shell> mysql -h LOCALHOST -u DBUSER -p DBNAME < phpdig187backup.sql