Re: [phpslash-users] phpslash backup

[Joe S. <joe...@us...>]

On Tue, May 11, 2004 at 10:13:44PM +0300, yo2lux wrote:
> Exist any way to backup the phpslash posts ? i copy /var/mysql/phpslash to other pc that run phpslash but not work..
> 

mysqldump -uroot -p --complete phpslash > dbdump.sql

This will back it up to a text file.

You probably want to gzip or bzip2 it to compress.

To restore from this backup:

mysqladmin -uroot -p create phpslash

mysql -uroot -p phpslash < dbdump.sql

Joe