Toggle navigation
Dashboard
Dashboard Tracker
Add / Edit My Forums
System Announcements
Discussion
Active Thread Feed
Top Threads Today
Top Threads This Week
Top Threads Library
Go!
View All
View All
Login
Logout
Home
Forums Index
Server Side
/
PHP Server Side Scripting
11:43 am May 21, 2026
This page requires javascript.
Forum Moderators:
coopster
Message Too Old, No Replies
upload and download a file from sql table using php
bablu
Msg#:4280766
6:19 pm on Mar 12, 2011
(gmt 0)
we want 2 upload file into database and also download it from mysql database using php..please help us..
rocknbil
Msg#:4281462
3:46 pm on Mar 14, 2011
(gmt 0)
look into mysqldump, to create the backup:
$command = "mysqldump -h $dbhost --user=$dblogin --password=$dbpass $dbname > $yourdirectory/$file";
$result = system($command);
.... will give a backup file with filename $file, be sure $yourdirectory is writable by PHP. Also be sure to read the result if it doesn't work:
if ($result) { die("could not make backup: $result"); }
To download it you open it and generate download headers, then just do readfile($file) (be sure to use full system path, NOT URL.)
Then to upload, you build a standard upload routine that ends with something like
$command = "mysql --user=$dblogin --password=$dbpass $dbname < $yourdirectory/$file";
$result = system($command);
where $file is a cleansed version of the uploaded filename. Note > and <, they should be familiar. :-)
Join The Conversation
Register
For Free! -
Become a
Pro Member
!
See forum categories
-
Enter the Forum
Moderators and Top Contributors
Moderator List
| Top Contributors:
This Week
,
This Month
,
Apr
,
Mar
,
Archive
,
Top 100 All Time
,
Top Voted Members
Hot Threads This Week
May 2026 Google Search Observations
AdSense Earnings and Observations - May 2026
AI visibility audit
Adsense / Personal Manager / Support
Hacker spoofing as GoogleBot
Page indexed but live url test gets 500 error
Link collaboration strategies
in case you missed it .
Microsoft, AS8075. Google, AS396982.
Bad actor claiming to be OpenAi
Home
Forums Index
Server Side
/
PHP Server Side Scripting
11:43 am May 21, 2026