FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Easy script to backup mysql database, and can attached to ow





phicha
is there Easy script to backup mysql database, and can attached to own php program ?
I find some usefull script but It a little bit doesnot user friendly.

thanks,
jmraker
You can use phpMyAdmin. It has a feature that lets you export tables in your database which is a backup that contains the commands to create the tables and all of their records.

Just click on the "export" tab and select the tables (if you're not in a specific table), use the SQL format and the defaults are usually ok (except the "Add AUTO_INCREMENT value" checkbox)

It'll generate a file or a page with a bunch of SQL commands, you can put the output in your program in one or more mysql_query() commands

http://www.phpmyadmin.net/
http://drupal.org/node/81993
Nemesis234
jmraker wrote:
You can use phpMyAdmin. It has a feature that lets you export tables in your database which is a backup that contains the commands to create the tables and all of their records.

Just click on the "export" tab and select the tables (if you're not in a specific table), use the SQL format and the defaults are usually ok (except the "Add AUTO_INCREMENT value" checkbox)

It'll generate a file or a page with a bunch of SQL commands, you can put the output in your program in one or more mysql_query() commands

http://www.phpmyadmin.net/
http://drupal.org/node/81993

this is done through a gui and so cannot be set to be done automatically and cannot be attached to another php file and run with 1 click.

read the origional post properly before posting.
Related topics
script backup database
Cron Job to Backup MySQL Database
Mysql database problem
Need help how to move a forum - Offer 100 frih$!!
PHPBB MYSQL Database Question.
MySQL database for a forum
Mysql database size?
A very good PHP MySQL Tutorial
insert data to mySQL database problem
Problem connecting to MySQL database with PHP [RESOLVED]
How to search in a MySQL - database
Connecting to 2 different Mysql database and tables?
Is there a better way to restore mysql database?
Connecting to a MySQL database using Python
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.