How To Create Mysql Backups Using Php

Does anyone here on this forum got any idea how to create backups of MySQL Databases using PHP then download the backup to the user, using:

Header("Content-type: application/octet-stream");Header("Content-Disposition: attachment; filename=$file_name");

??

I assume you are asking about the php code for that? and not using phpadmin? or the cpanel backup system?

True

Suggestion: try doing a search on the keywords +download +php +mysql here (or maybe try over at the Xisto Forum (http:http://forums.xisto.com/)).The Xisto Forum is more technical than the Trap and may have the information you are seeking.

Didn't found anything specific, and btw the script must not use "mysqldump".

Dear Arne-Christian if you want make one mysql tabel with php use this :

After all you must connect at your db
use this code :

$dbusername = "root"; //write Database username$dbpassword = ""; // write database password$dbname = "famp3";  //write database namemysql_connect("localhost","$dbusername","$dbpassword") or die(mysql_error()); mysql_select_db("$dbname") or die(mysql_error());

mysql_query("Put Your Query here ");

Example :

CREATE TABLE album (id tinyint(4) NOT NULL auto_increment,name text NOT NULL,country text NOT NULL,image text NOT NULL,cat text NOT NULL,date text NOT NULL,artist text NOT NULL,artistabc text NOT NULL,rate int NOT NULL,PRIMARY KEY (id)) TYPE=MyISAM;

You can use this code to make one tabel in mysql by php
if you want make one mysql database , you must create one db at your cpanel ( with one username and password )

You can use backup (export) query

have good time
Edited September 16, 2006 by farsiscript (see edit history)

1) Thanks for responding...2) ...Do you think i didn't knew that before? i have been working with mysql for months, anyway i have created a class now for creating backups, Thanks to google and you can create databases with "CREATE DATABASE $dbName" there is no need for cPanel if you know basic stuff, just had to say that, anyways no more respondes needed