Anyway 2 Store Files On Mysql?
anyway 2 store files on mysql? liek a text file something?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
MySQL Store Multimedia Files
I am hiring a programmer to build an application that will serve and store multimedia content. It will need a database backend and I am wondering if MySQL can store multimedia (audio and video) files or if it is not powerful enough. Also, are other database options better suited to this need?
How To Store Large Files In MySQL (Eg. 12MB)
What are the configuration changes I have to do for storing large files in the mysql databases. I want to store large files of size 12MB to 20MB. I am using MySQL 4.0.18 in SuSeLinux 8.2. I tried to do changes in /etc/my.cnf file such as to increase max_allowed_packet size to 21MB but I don't find that file.
Store Files To Database Or To Filesystem?
I need to store and retrieve files from HTTP server. I created table in the database with MEDIUMBLOB being one of the columns. Now I have second toughts weather I should store files in database, or store only meta data in database while keeping the file content on the disk. If I store all data in the database it should be easier to maintain. I'm worried about performance. If I store file content on the disk it should be easier to make partial backups but more care should be taken when syncronizing. Here are the numbers: I expect that 80% of files will be 10 kB - 100 kB in size and there should be 10000 - 100000 files. I am reading articles on this topic, but they are all inconclusive. I would like to know, from your own experience, what do you find better: to store it all in a database (would you use MyISAM or InnoDB) or would you store file content on the disk? (I am using foreign keys but decided to go with MyISAM because of the performance gain; extra caution is taken in the PHP to keep data integrity)
What Is The Best Way To Store XML File In MySQL?
I would like to store XML files in MySQL. What is the best solution: 1. Convert it to string and store it as CLOB/text 2. Serialize it and store as byte array 3. Flatten it out and create one column per element, each column is VARCHAR
Mysql To Store File
If i use mysql to store the file. How can i make a link for the user to download that file?
MySQL With Store Procedure...
How to create Store Procedure on MySQL 5A ? When I try to create the SP, but always error "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ....." But it very simple like, CREATE PROCEDURE test1(OUT) BEGIN USE Mysql; SELECT * FROM db; END And how to execute from sqlquery analyzer(like SQL Server)..
What Is The Best Way To Store A Date In MySQL DB?
I have a table (contacts) with a list of people I know. It holds info like email address and birthdays. Right now, I have the birthday saved across three fields- day, month, and year. The day and month fields hold values like '02' and the year field holds a four-digit number, like '2007'. I know MySQL has a 'DATE' field type, and I would feel that is probably the best way to store the information I have. My question is this: I have some PHP code that checks to see if any of my contacts has a birthday today (as seen below) $today = date("d/m"); $query = "SELECT * FROM `contacts` WHERE CONCAT(DAY,'/',MONTH) = '".$today."'"; How could I do this if I stored the date in a single, YYYYMMDD field?
Store Collection In MySQL
I have the following objects: Article - Name, CreationDate, Auther, URL. Users - FirstName, LastName, email, BirthDate. I would like to create a favorite folder - so that each user can have a list of articles that are his favorites ones. Each time the user login to the site he should see the list of his favorite articles. In java I will save this list in a collection (e.g. Vector or Array). What is the best way to save it in the MySQL DB? Which data type should I use?
Can MySQL 4.0.14 Store HTML
You need the following: Database Web Server Server-Side Scripting Language I would suggest using AMP (Apache, MySQL & PHP). If you want to know more about how these work in conjunction I would suggest the excellent book: "Web Database Applications" by Oreilly. It is the perfect beginners guide for this area.
Store Images In MySQL
I've looked around a bit before posting this, and overall I've discovered the means to store an image in a table via blobs, and take it back out and use it with PHP. I've discovered many users giving detailed descriptions as to why this is not a good idea, and overall I agree, BUT! I've been having the PHP problem where if I upload a file and store it onto my server with a form, the permissions are set such that nobody can delete those files aside from the superuser. I suppose this is more a PHP question, in that I am asking how I should store a file such that I can have access to delete this file later, or if I should just try to store the file in SQL?
Store Images In MySQL
I'm new to MySQL and wanted to know if I could store the images in the DB...not the location but the images. How can I do it? I need this info. urgently.. using the blob or mediumlob column type is fine but how do I transfer the images to tables?
Store Chinese Character In Mysql
My site is 90% english, however there are some pages that i need to display in chinese character. In fact, arabic, russia, spanish. In mysql, i try to use collation utf8_general_ci . So when i input the data using phpmyadmin, i type chinese character e.g •ź(lucky) into the record, save it. Unfortunately when i use php to get the data from mysql database and present it on the web, it appear as '?' (question mark). How do i show it on the web correctly ?
How To Use Trigger And Store Procedure In Mysql?
I am using mysql 4.0.20. Based on my knowlegdge, trigger and store procedure feature is not avialable for this version. However, I really need them to fulfill a task, which is to automatically export data to a file when there is new record instert. Is there a way to do it in version 4.0.20? Need your help urgently!
Trying To Store A Password In Mysql Table
Not certain if thats the right way...i changed the function to PASSWORD and it encrypted it, but when i'm trying to match the password with the encrypted one, it doesn't work. i've been looking online and see that the password function in mysql may not do what i need. i'm looking for extra security, that's why i wanted it.
How Do I Store Variables In A MySQL Table?
I want to create a table that has a newsletter that will get emailed out to clients. In the table, I want a field for the Subject, and one for the Body. In the Subject line, I need to include a personalization variable, such as "$firstname". In the Body content, I need to store several personalization variables. How do I store the variable name when I insert the newsletters into the table? For example, the Subject line may be: "$firstname, Here is the info I want to send you". In the body, I may have something like: "Presented to: $name" "From: $my_name" "$company_name" "$company_phone" etc... When I load the newsletter, I just want to store the variable names, not any content. When I open the table to load the newsletter, I need to then substitute the variable names with the true names and other content.
Best Column Type To Store A C Structure In MySQL ?
I want to know the best column type for storing the data of a C structure variable. I am using C API for creating table and inserting the rows. If at all there is a one such type, if query the database inside the MySQL then how that column displays.
Is It Good To Store Html-formatted Data In Mysql Tables?
I always thought it is best to keep as much html as you can out of your stored data, in order to have flexible data. I am working now on a user friendly news-editor where the user can add news and format the text as wished (put links, bold/underline/italic etc..). I am however a bit struggling with how I should proceed with this data. Do I just store it in the appropriate Mysql table and let it come out on the appropriate front-end news page? And not bother about the html in it? What if a user messes with the html? Should I strip all tags before storing it in the database and add them again while retrieving it on the news-page? If so, I know how to convert a few things, but not everything (like links, bold/underline..). Or are there other solutions? Thanks!
MySQL & Files
Does anyone know how I can store files (mostly pictures) into a mySQL table? I have tried the load_file function but it seems to not work. i just get NULL as the value. Any examples would be most appreciated. I am using RH9 and the latest version of mySQL. I know I should be storing the links on disk and the save a pointer in the table but I want to put the files actually in the database.
What Are /var/lib/mysql/www-bin.nnn Files?
There are about 30 /var/lib/mysql/www-bin.nnn files in my system, where nnn is a running number (001...030). Some of them are >1GB in size and the timestamps are old. What are they and what is the correct way to get rid of them?
MySQL & Files
Does anyone know how I can store files (mostly pictures) into a mySQL table? I have tried the load_file function but it seems to not work. i just get NULL as the value. Any examples would be most appreciated. I am using RH9 and the latest version of mySQL. I know I should be storing the links on disk and the save a pointer in the table but I want to put the files actually in the database.
Getting .myd And .myi Files Into Mysql
I was given raw .myd and .myi files that need to be exported into access (or something readable, excel, etc). I downloaded mysql, but how do I get these files from my hard drive into mysql so I can do the export? I have the server up and running, but I dont see anywhere to put existing data?
MySQL Files
In error I deleted my ibdata files and log files. Someone told me I needed to delete my .frm files to correct my problem and start MySQL. I did... can anyone tell me what I need to do from here?
Can These Mysql Files Be Deleted?
I'm trying to do some house cleaning on my server. I run a few mysql db's, for forum software and just starting a link directory. In the mysql dir I see: -rw-rw---- 1 mysql mysql 25088 Oct 7 2005 ib_arch_log_0000000000 -rw-rw---- 1 mysql mysql 5242880 Mar 12 20:23 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 Oct 7 2005 ib_logfile1 -rw-rw---- 1 mysql mysql 18874368 Mar 12 20:23 ibdata1 I'm trying to reclaim some space and wonder if these are all log files and if I can delete them without harming my system. I'm not brave enough to just move them to find out if my DB's complain.
/var/lib/mysql/base-bin Files?
I run a hsoting company and we have a dedicated server. Our server details are at below: OS: CentOs 4.5 Recently I have discovered server disk usage is getting bigger with no reason. I have googled the issue and find out exim temp files were getting very big. I have deleted them. Also I have figured out /var/lib/mysql/ directory is another large directory. In the directory there are base-bin files. Can you tell what these base-bin files for. I do not think they are neccessary for server but I did not want to delete them without knowing what they really are.
MySQL 5 Is Generating BIG Files
I've installed MySQL 5 in my linux box (gentoo), it's working ok, but it is generating big files in the database directory (in my case, /var/data/mysql). The files has the format "pcname-bin.000001",000002,000003...000060 . I have 60 files with 1 GB of space per file in my hard disk. What can I do??? Is possible to limit this files?? Can I delete it?
MySQL Replication Log Files
I have a MySQL 4.1 running on a SLES server (SuSE), and the DBA has left the company. The mysql/var directory is filled with large MySQL Replication logs from the past two months. Its filling up the 64GB filesystem, using 60G of the space. How can I clean this up? Can I just delete the old log files, or will that break something? I don't believe any replication is even happening with another server so I'm not sure why this is even turned on.
Mysql Development Files?
Where would I find mysql development files for mysql 4.1 and red hat 7? I know red hat 7 is old but that all I have for right now... I need the developer files specially those that deal with headers. I am just quoting from instructions I have for this application.
Backup Mysql From Files
Is it sufficient if I just backup (copy) the whole data deirectory of my mysql installation somewehere else? If something happens and I want to restore the databases, is it as simple as copying the backed up files, back to the original location? Do I need to backup something else (eg an sql script) for the sructure of the tables and the databases, or the whole "data" folder is the only thing I need?
VB App For MySQL Backup Files
how I can create a VB app to connect to a remote MySQL server at a set time and backup a remote db to local file? Although a lot of the tools I have seen backup to a text script file, a more compressed binary version would be better.
Mysql Temp Files
I have a problem with mysql server version 3.23.41 Some temporary files are created and named #sql1b5_1868c3_0.MYD. The size is about 130 GB and they are continuosly updated by the mysql server. I tried to stop the mysql server. In this way the temporary files were deleted but the the databases were corrupted.
FRM Files In MYSQL Are Invisible
I am using MYSQL 4/ RHL7.2 when i installed mysql all are the types (frm,myi and myd ) are available there. but when i untarred some files downloaded from the infected machine(missing frms there also) our server also affected. This is in our what i got from our server: shell# ls -l users.* -rwxr-xr-x 1 mysql mysql 6908 Jul 16 19:44 users.MYD -rwxr-xr-x 1 mysql mysql 3072 Jul 16 19:44 users.MYI shell# ls -l users.frm -rwxr-xr-x 1 mysql mysql 9312 May 22 18:40 users.frm when u access this thru php_admin, i can' see any tables showing. mysql> show tables; Empty set (0.00 sec) But actually the tables are present which is shown below. mysql> select count(*) from users; +----------+ | count(*) | +----------+ | 78 | +----------+ 1 row in set (0.00 sec) CAn anybody come up with a solution for this?
Include Files In Mysql
I have downloaded the free version of QT and build a graphical shell with QT designed. This runs fine after a compilation with VC++ 6.0. Now I want to add mysql-functions by linking with a mysql lib-file. But this didn't work at all. When I include mysql.h without any mysql-code in my program I get this errormessage: c:mysqlincludemysql_com.h(116) : error C2146: syntax error : missing ';' before identifier 'fd' This seems normal as the compiler didn't have a clue what my_socket is in line 116 mysql_com.h. my_socket fd; /* For Perl DBI/dbd */ After some research I found this in my_global.h that now is included: typedef int my_socket; /* File descriptor for sockets */ But now this errormessage appears: c:mysqlincludemy_global.h(420) : error C2040: 'pchar' : 'int' differs in levels of indirection from 'char *' Why aren't all include-files independent of each other and include the files they need? This was how it works when I made programs for Amiga and it works great.
Necessary Files Required To Run Mysql DB
When installing the application into clients machine i want to install mysql 5.0 also. But i don't want to install full mysql5.0 onto clients machine.Is it possible to copy some dll files and register it and able to connect to the MySql from java application.
MySQL And Video Files
Would mySQL work well as a media repository for video files? For instance if I am adding 20MB-120MB Quicktime files as binary data would anyone see any objections or downsides? It would be delivered via a web app and hosted on a standard off the shelf box.
60 Gb Of Mp4 Files In MySQL Database
I have a client who wants to store around 60 Gb of mp4 files for download on his website. Can MySQL store mp4 files? Would it be better to store all the videos in a zip file for bulk download also in a table in MySQL database? How do I finish these tables to store Mp4 files and how do I create a table to store Mp4 files? CREATE TABLE `mp4s` ( mp4ID INT(10) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`mp4s`) ) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE TABLE `zipped_mp4s_courses` ( courseID INT(10) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`courseID`) ) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
VB App For MySQL Backup Files
Has anybody got any pointers or examples on how I can create a VB app to connect to a remote MySQL server at a set time and backup a remote db to local file? Although a lot of the tools I have seen backup to a text script file, a more compressed binary version would be better.
|
TRACKER
