How to Automatically or Manually backup MySQL database?
I am looking for a way to backup a MySQL database.
Current Method: Using PHPMYADMIN I export all tables from 'HACW_V2' to the screen. I cut and paste the Statements to a WORD document and save. I also have the option to save as a file.
Goal: Be able to backup database automatically (by whatever means you can think of), or create a link on my intranet home page that will create a backup and save it to a predetermined (or manually specified location) with only one click.
Tools: I currently use PHP for my intranet site. My web server was compiled by XAMPP.
thanks for any help you are able to give.
Current Method: Using PHPMYADMIN I export all tables from 'HACW_V2' to the screen. I cut and paste the Statements to a WORD document and save. I also have the option to save as a file.
Goal: Be able to backup database automatically (by whatever means you can think of), or create a link on my intranet home page that will create a backup and save it to a predetermined (or manually specified location) with only one click.
Tools: I currently use PHP for my intranet site. My web server was compiled by XAMPP.
thanks for any help you are able to give.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://www.sixapart.com/movabletype/kb/databases/backup_mysql_da.html