Entry

How can I backup a MySQL database through PHP only?

Can I backup my database using PHPMyAdmin?

Is it possible to create a PHP script to backup a mySQL database?

Is it possible to create a PHP script to backup a mySQL database?

Jul 2nd, 2000 16:22
Philip Olson, Nathan Wallace, Kevin Edwards, Kevin Yank

Try phpMyAdmin: 
   http://www.phpwizard.net/phpMyAdmin/
As well as a great tool for administering your MySql database, it allows
you to download a dump of the entire database through your web browser.
To do it the old manual way, do this :
   mysqldump -u username -p dbname > dumpname.sql
it'll prompt you for your password & create a dump called dumpname.sql  
If you're not doing this locally then you wanted to do this :
   mysqldump -h source.host.name -u username -p dbname > dumpname.sql
Now, to put this back into a database, do this :
   mysql -u username -p dbname < dumpname.sql
And in case you're putting this in a new database, first create one 
like this :
   mysqladmin -u username -p newdbname
And remember, if you're not doing this locally, add the -h stuff.