|
03-02-2005, 11:42 PM | #1 |
Green Mole
Join Date: Feb 2005
Posts: 4
|
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
|
03-03-2005, 08:11 AM | #2 |
Head Mole
Join Date: May 2003
Posts: 2,539
|
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
__________________
Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension. |
Thread Tools | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
No Digging on same server | robertlyman | Troubleshooting | 1 | 07-05-2005 05:22 PM |
changing (moving positon of) the results message. | WebSpider | How-to Forum | 3 | 05-03-2005 10:57 AM |
Hello, I use a Windows Server | ClausBrell | The Mole Hole | 2 | 09-30-2004 04:35 AM |
Test Server | RaGe | Mod Requests | 0 | 05-10-2004 04:01 PM |
Server Resources problems | sid | Troubleshooting | 4 | 02-28-2004 04:23 PM |