Database Backup?

[EthanX]

I would like to create a backup script but don't know where to start really. I need the backup to be in my scripts so poeple can backup there data without phpmyadmin, and a restore also so they can restore from my scripts also.

Anyone have any ideas on how to do it?

[Spookster]

http://www.hotscripts.com/cgi-bin/search.cgi?bool=AND&query=database+backup&catid=2

[EthanX]

Um.... No.

I don't want to use a script to backup.
I want to have something built into my own scripts.

So I need to know how to make a script for backup and restore.

[Spookster]

Then why don't you integrate one of the scripts listed into your own scripts?

[EthanX]

I'd rather not use someone else script from hotscripts.
I'd rather be told how to do it and I do it :)

[Spookster]

What you are asking for is not just a few lines of code and is beyond the scope of these forums. You will need to start writing something for this and then ask more specific questions.

If you are new to PHP then I would suggest going through the PHP manual at www.php.net and the tutorials at www.zend.com. And of course you will need to learn how to work with MySQL at www.mysql.com

Other than that since you seem adamant about not using someone else's script I suggest you at least look at some of those scripts to get ideas on how to write something like this.

[IndyTim]

The other (hybrid) solution would be for you to go to say HotScripts and get ahold of one of the many "free" db backup scripts. Run the script on your d/b and look at the resulting sql to show you the protocol for writing db backup sql.

IndyTim:rolleyes: