How To Create Mysql Backups Using Php

[Arne-Christian 0]

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");

??

[jlhaslip 4]

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

[Arne-Christian 0]

True

[jlhaslip 4]

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.

[Arne-Christian 0]

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

[farsiscript 0]

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)

[Arne-Christian 0]

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