PhpDig.net

PhpDig.net (http://www.phpdig.net/forum/index.php)
-   How-to Forum (http://www.phpdig.net/forum/forumdisplay.php?f=33)
-   -   Moving to a new server (http://www.phpdig.net/forum/showthread.php?t=1895)

ezytrak 03-02-2005 11:42 PM

Moving to a new server
 
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 03-03-2005 08:11 AM

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.
Code:

# 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



All times are GMT -8. The time now is 06:33 AM.

Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.