Moving to a new server

ezytrak · 03-02-2005, 11:42 PM

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

03-02-2005, 11:42 PM	#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

03-03-2005, 08:11 AM	#2
Charter 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.

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