mysqldump

[OwenTheSamoan]

I am using php and mysql. I have a website that is being hosted on a remote server. I want to copy EVERYTHING that is in my database and back it all up. I was told to use "mysqldump" to back everything up. My problem is this- I want to copy everything from my remote server to my computer at home but I am confused as hell how to do this. I've read a few books and the mysql manual. Does anyone know of a good tutorial on this.

Thanks in advance,
OwenTheSamoan

[snoopy13]

it is actually quite easy
i use PHPMyadmin - there you make a dump and you can choose to "copy" structure and data. then you either have it sent to your computer as a "zip" file or let mysql write it and you copy it and then paste the stuff into your database at home. all the tables and the content will be there.

[zcketcher]

Provided it's hosted on a linux box you could do the following:

Assume (for example purposes) your site is hosted in /home/www/mysite and you are in that directory.

Type:
tar -cvf mysite_07212003.tar *
gzip mysite_07212003.tar

then just browse to your site and put the file name in.

http://www.mysite.com/mysite_07212003.tar.gz

...you now have a full backup.

To restore just FTP the file back to the host in the site root dir and issue:
tar -xvf mysite_07212003.tar.gz

[OwenTheSamoan]

Thanks for all the help. I'll give it a try. Thanks! 🙂