PhpDig.net

Go Back   PhpDig.net > PhpDig Forums > How-to Forum

Reply
 
Thread Tools
Old 03-03-2005, 12:42 AM   #1
ezytrak
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
ezytrak is offline   Reply With Quote
Old 03-03-2005, 09:11 AM   #2
Charter
Head Mole
 
Charter's Avatar
 
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.
Charter is offline   Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
No Digging on same server robertlyman Troubleshooting 1 07-05-2005 06:22 PM
changing (moving positon of) the results message. WebSpider How-to Forum 3 05-03-2005 11:57 AM
Hello, I use a Windows Server ClausBrell The Mole Hole 2 09-30-2004 05:35 AM
Test Server RaGe Mod Requests 0 05-10-2004 05:01 PM
Server Resources problems sid Troubleshooting 4 02-28-2004 05:23 PM


All times are GMT -8. The time now is 08:47 AM.


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