PhpDig.net - View Single Post

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