Variablez
Oct 17 2008, 06:27 PM
| | Hey im trying to add a file to my My SQL Database, Any idea how I can do this? Any help would be appriciated. Thanks! |
Comment/Reply (w/o sign-up)
Evolix
Oct 17 2008, 07:23 PM
What do you mean you want to add a file to your MySQL database? Do you mean importing a file into it via phpMyAdmin?
Comment/Reply (w/o sign-up)
galexcd
Oct 17 2008, 10:01 PM
Although not advised for storing large files, you can include files directly into mysql by using the BLOB type. Unfortunately mysql databases normally don't have very much space allocated to them because they mostly store text so you might find that it is easier to upload files to a directory on your website and reference them from sql. If you are still sure you want to do this, and if you are trying to do this from php, this tutorial might help you on your way.
Comment/Reply (w/o sign-up)
jlhaslip
Oct 17 2008, 11:29 PM
I am Alpha testing a CMS that stores the Template file and the CSS file in a Database and allows changes to be made to them via the Admin Panel for the CMS instead of using an FTP program and an editor. How cool is that? So, storing files as a Database record is easy enough to do. Here is the SQL for the Templates Table. You can add Templates and select whichever one you have added as the displayed Template via the Admin Panel. The CSS files are handled the same, except in a different Table. CODE CREATE TABLE IF NOT EXISTS `templates` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL,
`template` longtext,
`main_temp` char(3) NOT NULL default 'YES',
`css` varchar(8) default NULL,
PRIMARY KEY (`id`)
); The 'template' element of the Table stores the actual, full html as type=longtext.
Comment/Reply (w/o sign-up)
Similar Topics
Keywords : add, files, sql, database
- Mass Transfer Files
(9)
Troubles Extracting Zipped Files
(15) Well I haven't been able to extract any sort of archived files. Everytime I do, no matter what
size they are, I seem to get a fairly big error. I forgot to copy the error, so I don't have
the exact writing of it. But, it has happened with .zip files and .rar files. ( I tried .rar just
to see if it would give the same error.) Has anybody had the same problem? I mean I could easily
just use an FTP and import file by file, but uploading by archiving the files is easier.....
How To Transfer Files Directly From My Computer To The Trap17 Account
(8) Hi! I've been hosted in trap17 for almost 4 months now. In the beginning, I tried to setup a
WebDisk to directly transfer files from my computer to my hosting account, but I didn't manage
to make it work. It might have been from my Vista's weird firewall settings, or my ISP settings,
I have no idea. Anyway, I used the File Manager since, as I don't have a lot of files on my
site. Needless to say, it is really annoying when I do just some little changes and I have to go
again through CPanel, FileManager, UploadFile... pffff So my question to you... How....
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.....
Ips Installer Database Details [resolved]
It wont accept localhost... (6) CODE Access denied for user 'skyed211_central'@'localhost' to database
'skyed211_centralgaming' I get this error message when trying to install my IPB. It will
not accept localhost, nor mysql. Can I get any help please? I've tried many times to get past
this part, but it's not happening /sad.gif" style="vertical-align:middle" emoid=":(" border="0"
alt="sad.gif" />....
Is The Database System Gone Again? [resolved]
Errors on PHPMyAdmin again (12) I wonder if there is a problem with the PHPMyAdmin system again? When trying to get into it, I once
again get the following: QUOTE Warning: session_write_close() : SQLite: session write query
failed: database is full in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42
Warning: session_write_close() : Failed to write session data (sqlite). Please verify that the
current setting of session.save_path is correct
(/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb) in
/usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42 Warning: Ca....
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...? ....
I Need Help Transferring Sql Database?
(3) ok so i am trying to transfer mediawiki's but i am having trouble with exporting importing the
database. I am using phpmyadmin on both sides of the hosts. When i do the import i get this.
QUOTE SQL query: -- -- Database: `apolopedia` -- CREATE DATABASE `apolopedia` DEFAULT CHARACTER
SET latin1 COLLATE latin1_swedish_ci; MySQL said: Documentation #1044 - Access denied for user
'jaenagle'@'localhost' to database 'apolopedia' I tried to give my user
all rights, but it gave me this also. QUOTE SQL query: GRANT ALL PRIVILEGES ON....
Css Problem On Website
I've uploaded the html/css files but the css isn't working/ (8) Help? I've uploaded all of the html files and css files into the public_html folder , but the
css isn't taking effect. I've checked both the css and te html files , nothing wrong with
them. Halp me? www.genesis.trap17.com/home.html /sad.gif" style="vertical-align:middle" emoid=":("
border="0" alt="sad.gif" />....
Where Do I Upload My Ftp Files? [resolved]
As in, which directory? (2) I recently got approved for hosting. I have an account right now, but I don't know which
directory to post my FTP stuff in. (I don't know if this is in support or not; the search
results didn't return anything.) I remember with my last host that had CPanel that you had to
upload it into the "public_html" folder. So I do that, or do I just upload it into the root
directory? Thanks in advance! (EDIT: Oh, never mind, it is /public_html.)....
Changes In Phpmyadmin
Access to my database from program not working anymore. (0) I was wondering if something has changed in the MySQL or PHPMyAdmin section of Trap 17. (Hope I am
explaining this correctly). I run a newsletter system on my website and the details of the people
who subscribed are in a MySQL database. To get those data from the database and to send the
newsletter to all subscribers I use a program called "Qios Pelican". Up to now it always worked
perfectly, but now it cannot seem to retrieve data anymore, yet I have not changed anything to my
setup. I use the MySQL OLEDB Provider driver to connect, and in case it helps, here are the ....
Transferring Files From One Host To Another
Take my site to trap17 (9) As I said, I had to move my web site away from Trap17 temporarily because I had ran out of disk
space. Now, when my upgrade is finalised, I would like to ask for a little assistance. The provider
I will be moving my site from, back to Trap17 also uses Cpanel, and the admin let me know to do a
backup and that backup could be simply transferred via FTP to my new provider. The backup includes
all my files and MySQL data, in other words, the whole web site. It is in a .tar.gz format. How do I
get all this across? Do I 'unzip' the file and then transfer them bit by bi....
Ftp Trap17 Account Help Please
cPanel issues and can't upload files (14) A few days ago I tried to log into cPanel on my site ( www.liamssite.trap17.com ) and it didnt work.
Also, whenever I try to upload a file (I use filezilla) I get this: QUOTE Status: Resolving
IP-Address for liamssite.trap17.com Status: Connecting to 64.69.46.210:21... Status: Connection
established, waiting for welcome message... Response: 220---------- Welcome to Pure-FTPd ----------
Response: 220-You are user number 2 of 50 allowed. Response: 220-Local time is now 11:31. Server
port: 21. Response: 220-This is a private system - No anonymous login Response: 220-....
Can't Find My Fantastico Installation!
Where is the files I installed (2) Before anyone points it out, I searched this forum for similar topics and couldn't find any, I
checked the FAQ's and couldn't find any one of them that addresses my problem: I just
installed joomla in a sub directory (public_html/Joomla) and I wanted to change some stuff so I went
into my FTP program and connected to my account, I checked, doubled checked and triple checked all
the public html/FTP/WWW folders and I couldn't find the joomla installation, the site come up
fine in browser but I can't seem to find the directory of where it is located, t....
Need Help With My Database
I cannot transfer my old site's database (19) I Couldn't import my database info via Import from php my admin and i got the .sql file from the
php my admin of my old hosting and every time i try to import it give me an error that i don't
have the permissions to do.... /sad.gif" style="vertical-align:middle" emoid=":(" border="0"
alt="sad.gif" /> What shall i do?? I need Help Please....
Help! I Deleted All My Files!
(5) Hi guys, i got hosted yesterday and i loged on to my file manager and deleted all the files in there
i replaced them with my site including the index.htm page and now when i try to view it it says no
page found!!! i dont no why this is as with my site when i payed for hosting from one.net it was as
simple as using the run program and typing in mt ftp:\\ account copy the index.htm file and i was up
and running! Can anyone help with what i have done wrong please thank you. /sad.gif"
style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> Changed topic ....
Need Help Installing Smf
It's not finding the files I upload. (5) I downloaded the zip version of the SMF, from www.simplemachines.org I am using SmartFTP, to upload
the files. I created a folder, named Forum, and uploaded all the SMF files there. On the
simplemachines site, it tells me to type my site url followed by /forum/install.php, or whatever the
directory I installed it on is called. I tried that, and I come up with this on the page. Not
Found The requested URL /forum/smf1.1/install.php was not found on this server. Additionally, a 404
Not Found error was encountered while trying to use an ErrorDocument to handle the re....
Installing Phpbb
database problem (0) Hey guy's, ive done as you said and tried to install my phpbb without fantastico. I have got to
the the install page then i get a mysql error QUOTE Warning: mysql_error(): supplied argument
is not a valid MySQL-Link resource in /home/tdm/public_html/forum/phpBB2/db/mysql4.php on line 330
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in
/home/tdm/public_html/forum/phpBB2/db/mysql4.php on line 331 phpBB : Critical Error Could not
connect to the database Im not sure why this has happened as i have never really used mysql for
....
Database Connection Problem
phpBB2 installation error (5) *edit* Ok well the original problem has been solved. I have installed phpBB2 on my new how here.
Transfered all of the database files over. On my new forums all of the old posts and everything
shows up right. The problem is when I click the "Go to administration panel" at the bottom it links
me to log into my ACP on my old forums. It changes the url and all. If I hover over the link it
says that it will be directed to the right way, the way I want, but it doesn't. Does anyone
know anyway to fix this?....
Database Errors!
Started after HDD change.. (5) Hello, I am having database errors. They started after yesterdays HDD change. Its all fine when i
refresh site, they not that often but still i get them. It says "could not connect to database". And
i also received mail from gamma.xisto.com which says: QUOTE There has been a problem with the
database! This is a notice email to let you know that SMF could not connect to the database, contact
your host if this continues. so i am contacting my host......
Accidentally Deleted Pre-set Files
(3) I made a bo-bo lol I've accidentally deleted those pre-set files that are in the file manager
when you first register, you know those _vti thingy magiggers, well i accidentally deleted them, so
i was wondering if an admin can re-insert them for me /biggrin.gif" style="vertical-align:middle"
emoid=":D" border="0" alt="biggrin.gif" /> or re-set my hosting whatever you have to do.... thanks
/biggrin.gif" style="vertical-align:middle" emoid=":D" border="0" alt="biggrin.gif" />....
Problems With Deleting Files In My Account
blendergalactica.com (3) Suddenly all my file permission aren't writable in the Joomla directory. Furthermore, when I go
to delete old files or overwrite them, I get a varity of errors both in my FTP programs and using
the Cpanel flie manager. When I checked the needed directories file permission they read 777
(which is needed for installing components) yet when I got to access them they are unwritable. This
has just happened in the last day or so and the not being able to delete files mannual in the past
week. I get this error on changing file permissions: QUOTE FTP Error: Could ....
Upload Script To Transfer Files From Laptop To Desktop
(3) Would it be allowed to have an upload script to transfer text files (homework) from laptop to
desktop? Because my printer is set up from my desktop, and most of my homework is done on my laptop.
So would this be allowed? Thanks.....
How To Crate Mysql Database?
urgent help (7) Hi everyone!
I'm trying to make in my site a page system that allows me to create users
account (with a foto for every user)...
I'm doing that in PHP, I learned all I have to
know about PHP and MY SQL. I know how to make new array and querries in the data base, only 1 think
is messing: ....
How To Upload Zip Files?
(6) Hello.. I want to upload MSN emoticons packs on my site.they are in zip file... I want to upload
that zip file , ,and i made an index page and made the gif file of the emoticon pack and then i put
hyperlink of that gif file to zip file , but when i uploaded the site , and it doesnt work , when i
click on the gif image , instead of the zip file start to download , i get this page
website.com/emoticons.zip/ Index of /emoticons.zip Name Last modified
Size Description -------------------------------------------------------------------------------....
Help Moving Mysql Files To A New Host
IPB files (2) Well, my partners on my forum has decided to move our site to a newer host. A paid one to be exact.
And we did that already. Now all we need to do is move our forum over to the new host. We want to
do this without losing all of our posts and other data. I know it has something to do with the MySQL
files but I don't really understand it. Some help would be appreciated. We are running Invision
Power Board 1.3.1 final Also, we're thinking about upgrading our board to a newer version of
IPB because we heard that its better in more ways than one. But then again, it....
Mysql Database Setup : Setting Up Mysql Database
Guide to use MySQL database in your site (7) 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....
Restore Database Have Bug ?
I restore and have errors ! (4) I tried restore a database as type : username_forumname.sql ! After restore , check in cpanel ,
feature mysql datase , I seen a new database is : username_usernameforumnamesql ! Have anything
wrong ?....
Uploading Files And Connecting To Ftp
using WsFtppro (27) The fastest, most reliable way to upload or download files is through FTP. If you don't already
have your own Web page, read our reviews of over 80 free Webhost. If you don't have an FTP
client, Download WS_FTP Pro now. Step 1 - Connect your computer to the Internet. Step 2 - Launch
WS_FTP Pro by clicking on the WS_FTP Pro icon that's on your desktop. If you do not have a
WS_FTP Pro icon on your desktop, click on the Start button and then select Programs, then WS_FTP,
and then WS_FTP Pro. Step 3 - Connecting to an FTP site: When you open WS_FTP Pro, you&#....
Problems with PHPBB & my Access to files :S
(4) Ok another problem i'm having.. prolly my fault but ok.. i go to uploud my avatar on my forums
and it says this after i click submit Warning: copy(./images/avatars/486273215410e356f445f1.jpg):
failed to open stream: Permission denied in /home/zipmc/public_html/Forum/includes/usercp_avatar.php
on line 227 Warning: Cannot modify header information - headers already sent by (output started at
/home/zipmc/public_html/Forum/includes/usercp_avatar.php:227) in
/home/zipmc/public_html/Forum/includes/page_header.php on line 474 Warning: Cannot modify header
information - h....
Looking for add, files, sql, database
|
Searching Video's for add, files, sql, database
See Also,
|
advertisement
|
|
