Arne-Christian
Sep 16 2006, 10:13 AM
| | 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:
CODE
Header("Content-type: application/octet-stream");
Header("Content-Disposition: attachment; filename=$file_name");
?? |
Reply
jlhaslip
Sep 16 2006, 10:47 AM
I assume you are asking about the php code for that? and not using phpadmin? or the cpanel backup system?
Reply
Arne-Christian
Sep 16 2006, 10:50 AM
jlhaslip
Sep 16 2006, 11:01 AM
Suggestion: try doing a search on the keywords +download +php +mysql here (or maybe try over at the Astahost Forum (http:www.astahost.com)). The Astahost Forum is more technical than the Trap and may have the information you are seeking.
Reply
Arne-Christian
Sep 16 2006, 12:04 PM
Didn't found anything specific, and btw the script must not use "mysqldump".
Reply
farsiscript
Sep 16 2006, 07:11 PM
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 : CODE
$dbusername = "root"; //write Database username
$dbpassword = ""; // write database password
$dbname = "famp3"; //write database name
mysql_connect("localhost","$dbusername","$dbpassword") or die(mysql_error());
mysql_select_db("$dbname") or die(mysql_error());
CODE
mysql_query("Put Your Query here ");
Example : CODE 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
Reply
Arne-Christian
Sep 16 2006, 09:09 PM
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 
Reply
Similar Topics
Keywords : create, mysql, backups, php
- Mysql Hacks
(1)
Creating A Php Login System Using Mysql
I need help in creating a login system, what I want is a login system (10) Hey everyone! I am helping someone make a login system using MySQL databases and a PHP login
form. I have a fair bit of experiance in HTML and some javascript too. I have virtually no
experiance in MySQL or PHP. Anybody know of any good PHP login systems that allow you to creat a
personalised page for each user and when they login the system transfers the user to their page.
Another thing that the system MUST have is a way of stopping unwanted users entering someones page.
CODE For example lets say I register and my UN is jesse123 and my personalised pages a....
How To Create Pdf Files Using Free Tool
Introduction to use a free tool to create PDF file (0) Now, that you don't need to have expensive software like Acrobat to create PDF. All you need is
Microsoft Office and a software name doPDF. You can download the freeware from
http://www.dopdf.com/download.php After downloading dopdf.exe, follow the instruction below 1.
Double click to install it, as display at image 1.jpg, choose a language and click OK 2. You will
see 2.jpg click next 3. Click I accept the agreement see 3.jpg, click next 4. Now you will see
4.jpg, select the folder to install it and click next 5. When seeing 5.jpg, This is the folder group
in Star....
Create Dynamic Html/php Pages Using Simple Vb.net Code
Taking your application data, and creating a webpage for others to vie (1) This example will show you how use a string in VB to create PHP code. In order to do this, you need
a string to store your PHP page and a function that I will list at the bottom of the page for you to
put in a module. This code is written in VB.NET Public Sub CreatePage(ByVal HTMLTitle As
String, ByVal HTMLText As String, ByVal HTMLFileName As String) Dim strFile As String '
---------------------- ' -- Prepare String -- ' ---------------------- strFile = "" '
-------------------- ' -- Write Starter -- ' -------------------- strFile = " " ....
Mysql Database Not Working
(3) well i'm getting an error message(a databass connection warning) for all of the parts of my site
that connects to a mysql database i check my database users pertmissions and i try to do the repair
database thing and it's still not woeking. am i the only person having this or is it an overall
trap17 issue and how do i fix it.....
The Only Reason I Choose Ms Sql Server Rather Than Mysql
(0) The only reason i choose ms sql server rather than mysql is, MS SQL has more security
features!! MySQL is lacking a lot in my opinions - Lack in wide char, like nvarchar, I
developed some application to support chinese letter, and dont know how to build one in mysql - Lack
in t-sql syntax, like query in query is not fully supported - Does not have today SQL features like
BI support (today really required) And compare MS SQL to MySQL, the only reason why mysql is
favourable is - it is free! Dont u guys agree?....
Need Advice On Setting Up Mysql Database.
I have a huge amount of daily data updates to be inserted. (4) First of all, to get the idea of what I am trying to achieve here, please have a look at my
idea thread, entitled Idea For Using A Cron Job To Grab Daily Travian Map.sql Updates . This gives
a prelude to the project, what it is for, what it is supposed to do, etc. Now, what I need is
specific advice on setting up the mySQL database(s) to implement this idea. There is a useful FAQ
file for how to make use of the map.sql data located on the help.travian.com website, which also
gives an example of the CREATE TABLE instruction that matches the data in the map.sql fi....
Mysql Db Is Down Getting Following Error
(2) My Mysql is Down can I get some help please? Appreciate it. Patrick Domain: patrickcurl.com Error:
phpMyAdmin - Error #2002 - The server is not responding (or the local MySQL server's socket is
not correctly configured)....
How To Create A Torrent
For legal/leanring purposes only! (4) Hello. I have searched the tutorial section and have seen many great tutorials. One which I have not
seen is how to create a torrent. For this, I will be using uTorrent, the best torrent client, in my
opinion. ( Windows Only ) ( I'm sure that Azureus/ABC/etc.. would not be much different. )
Steps: 1. Have uTorrent open, and go to File >> Create New Torrent
http://i8.photobucket.com/albums/a1/Shadowcode/step1.jpg 2. Click " Add File " or " Add Directory
" and select WHAT YOU WANT PEOPLE TO DOWNLOAD . Add a tracker in the Trackers field. ( You can get
this by....
How To Create Cool Image Buttons
(7) Hi guys ... I m making a personal site thats for me a nd my friend group. What I need is a tool
which can make cool image buttons to use in my HTML pages. Is there any site which offers such
software or the buttons itself for free. I would like to make them on my own, I just need to know
the tool.I can't go for an expensive tool like photoshop or corel. So please suggest me a free
tool. Thanks.......
It Went Well For A While
MySQL problem back in all its glory. (5) Some time ago I had a stubborn problem when trying to access one of the interactive pages on my
website and getting the following error: QUOTE Warning: fopen() : open_basedir restriction in
effect. File(include/errors.xml) is not within the allowed path(s):
(/home/mrdee:/usr/lib/php:/usr/local/lib/php:/tmp) in
/home/mrdee/public_html/admin/include/commonfunctions.php on line 682 Warning:
fopen(include/errors.xml) : failed to open stream: Operation not permitted in
/home/mrdee/public_html/admin/include/commonfunctions.php on line 682 Cannot open XML data file:
incl....
Phpmyadmin
Create new database: No Privileges (7) i can not make a sql for diff srcipt, but the sricpt i have is php, DJ-cpanel.. all tho i can not
install it the error is like this Creating Database Tables No database selected there a mysql
database is made, but i can not use it for othere stuff... plz note that this is Free script and not
for paid.. is there a way that the myqsul can not use sql other scripts? or it maybe not working...
but i am not sure if the script not working or it can be the server may be down on mysql...? ....
[help]create P Server
(2) Hello There, First of all I would like to explain fews I'm not a programmer and nothing. Just
wanted to find people who can help me code private server games, as like
http://www.perfectworld.com.my/ , http://ms.runup.com.my/ ( dark story online) , Warcraft III -
Frozen Throne Server(Could be exclude). As the member of my cyber cafe has asked me to create a
private server of those game, unfortunately I'd have no experiences in any of these so I need
help from other who is an expert can help me out and I need the sources and guide /smile.gif"
style="vertical-....
What Is Your Dream Naruto Character
create your own naruto character (20) Basically all you have to say is your name, your jutsus (Gen, Tai, and Nin), any special abilities
and maybe a bit about his or her backstory. this is my character: Name: Nightmare also goes by
Shadow. No last name Jutsus: I think he would have Drunken fist style tai jutsu, Shadow shuriken tai
jutsu, Shadow leaf dance. my nin jutsus would be; Air slicing blast, Armor of sand, Demonic soul
stealing technique, Desert coffin and desert graveyard, Fire dragon flame blast, Grand fireball,
phoenix fire, Chidori, Rasengan, Shadow clones, Water prison, Genesis of rebirth, deser....
Fruity Loops Tutorials-trance Style Songs
How to create and use a profesional trance style bass mellody (11) Creating a bass mellody tutorial Software / fruity loops VST Plugins / Nexus,VANguard Song Style
/ Trance Tutorial Level / Beginner files needed to download bellow. ok to start I am going to
teach you how to create what's sometimes referd to as a bass mellody. A bass mellody is used in
most trance songs as its primary function is to fill out the song by this I mean make the song sound
a bit fuller to add depth to it. a bass mellody is never made of more than a few note styles. see
below In the above image you can see that I have use in all a total of t....
How To Create A Song In Fruity Loops Using Vanguard
but you can use outhers (1) ok i began by trying to create individual tutorials for the creation of a song in general but as i
make songs in fruity loops i thaught it better to teach you how to create a song inside fruity loops
using anumber of efects and plugins. this is the bit of song we are going to learn how to create
(note this song is copryrited to me so dont try claim it as yourown, i do give permision for you
to remix it aslong as the title is displayd in this way in its entierty DJ StarSkream, solar
flare(your name REMIX)) ok step one once you have downloaded the song snip abo....
Toufee.com - Create Free Flash Movies Online
very good site (3) Toufee.com allows you to create free Adobe Flash movies online. There are no ads on your movies
and you can use a wide variety of features to enhance your presentations like text effects and
speech-engines that read your text aloud. In fact, I still to get what the catch is. Here's
what you can do free: http://www.toufee.com/demo/create-flash.html And here is a test signature
I created using the service: http://tinyurl.com/ysosxj/flash.swf It must have taken me all of
ten to twenty minutes to create that once I knew what I wanted to do and how to do it. Th....
Private Server Ro .
How to create your own private Ragnarok-Online server !!! (159) I saw that there are a lot of people asking for how to create a private Ragnarok-Online server . so
now i decide to make this tutorial to to help these people ... i didn't have a server but my
friend had server and ihelped him to find pros and some tutos so , i learned with him how to create
a server ...stop making introduction ...let's go ... first you have to have minimum
requirements : ----Software :---- i think any windows should work, but i recommend Win Xp i
think you have alredy a Winrar *- Korean Ragnarok client *- Sakray patch (*i recommend the las....
How To Create Embed Image Mail In Gmail
(56) Hi to all ! Anybody can help me to create an email with embedded image so that mail reader
automatically see that image. Moreover I wont attached that image as it appears small in size in on
gmail. Thanks in Advance. ....
Quick Question
Is there a limit on the size of the MySQL database? (10) Question's in the title!....
Subquery In Mysql
(5) Is there anyway to make subqueries work in MySQL? I'm pretty certain someone out there knows
how. /smile.gif' border='0' style='vertical-align:middle' alt='smile.gif' /> Can anyone help?
CODE Select * from ITEMS where ID="Select Max(ID) from ORDERS"; This works
for MSAccess and SQL Server but why not in MySQL? I'll be writing some reports and I've
shifted database from MSAccess to MySQL. Help! Thanks.....
Mysql Database Size
related to the free database space (7) hi all! this is my first post /biggrin.gif' border='0' style='vertical-align:middle'
alt='biggrin.gif' /> and i have a doubt, how much mysql space i am allowed to use... i mean how
much is available for my free account....
Import From Excel File Into Mysql Database
(11) Has anyone tried using the excel import function that comes with phpmyadmin
http://www.phpmyadmin.net/home_page/ - it does not require any additional plug-ins or scripts and
is fairly straightforward to use. In phpmyadmin, if you click on the database table which you wish
to import the data to , there is a link on the bottom left corner which says "insert data from a
text file into the table" - although it says text file it still can be used to import an excel file.
When you click on this link you will be taken to a page where you will be asked for the file name
(the....
How To Create Java Button Or Frame
to be customized (14) hi to all!!!! just like to ask if it would be possible if i could make a custom
button or frame in java. i got tired of using the build infeatures in java. i would like to create
my own dessign of button or frame.. can it be possible!!! /biggrin.gif' border='0'
style='vertical-align:middle' alt='biggrin.gif' /> thank!!!! /laugh.gif'
border='0' style='vertical-align:middle' alt='laugh.gif' /> New Help In! is NOT a descriptive
topic title. Next time you decide not to follow the posting rules, you will be issued a w....
How Can I Create A Gui Using C++
I need easy steps! (5) can someone tell me how to create gui using c++... thanks!!!! /biggrin.gif'
border='0' style='vertical-align:middle' alt='biggrin.gif' /> Questions do not belong in the
tutorial section. Moved. Topic names and descriptions are VERY important. Changed that too. Issued
warning. ....
Increment A Mysql Column
how to increment a MySQL column one unit (7) Hi, I have a column in a MySQL table which contains a counter of the views of the object described
by this table. I would like to increment this value by one everytime the object is viewed. Obviously
came into my mind the possibility of retrieving the value of this field, store it in a variable
increment this value by one and perform an UPDATE query again with this new value. My question is if
there is a MySQL option to update the field with its actual value plus an unit increment. I hope you
understand the issue.....
How To Create A Forum?
(18) I want to create a forum after getting a host on this site,but i cant find a propper program for
it.Also i want to know how to have polls and other stuff on the side. P0ZzZ! Post moved to the
right section ....
How To Create Virtual Drives
A complete guide on how to create virtual drives (20) I'm planning to format my computer tonight, and I need some sort of reference about this when I
get back. What is a virtual drive? A virtual drive is a shortcut to a folder hidden deep inside
Windows. Instead of having an icon for the shortcut (virtual drive), you will see a drive icon with
a letter that you chose when you go to My Computer after you create the drive. After completing this
tutorial, you will be able to turn a long path
(C:\directory\directory\more\directory\oh\my\gosh\this\
is\a\long\direc....
Complete Login System
With PHP + MYSQL (57) Its an complete login sistem made and tested by me and I think itwill be very usefull for people who
are tryn to learn PHP. First, let's make register.php: CODE <?
include("conn.php"); // create a file with all the database connections
if($do_register){ // if the submit button were clicked if((!$name)
|| (!$email) || (!$age) || (!$login) ||
(!$password) || (!$password2)){ print "You can't let
any fields in blank....
Mysql Database Setup : Setting Up Mysql Database
Guide to use MySQL database in your site (6) A SMALL INTRODUCTION TO DATABASE ============================= I have seen that many members have
problems with Database. Here is a small INFO which should give you the IDEA. mySQL is a DATABASE
server. You can access it using the link in Cpanel. Cpanel can be accessed by
"www.YOUR-SITE.com/Cpanel" There you have 4 Main Options :- 1> CREATE A DATABASE 2> CREATE A USER
3> ADD USER TO DATABASE 4> PHPMYADMIN CREATE : IT ALLOWS YOU TO CREATE A DATABASE CREATE USER
: IT ALLOWS YOU TO CREATE A USER. USING THIS, YOU CAN ACCESS THE DATABASE. A DATABASE CANNOT BE....
Looking for create, mysql, backups, php
|
*RANDOM STUFF*
*SIMILAR VIDEOS*
Searching Video's for create, mysql, backups, php
*MORE FROM TRAP17.COM*
|
advertisement
|
|
