Re: phpslash backup

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


-------------------------------------------------------
This SF.Net email is sponsored by Sleepycat Software
Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deliver
higher performing products faster, at low TCO.
http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3