• MySQL: What’s the downside of storing images in the database?

    I'm looking at using MySQL for my database so I need some opinions on the disadvantages of storing images inside of it. Is it not as efficient as storing images on a server? Does it take longer for the images to download vs. disk storage? Thanks for all the input!

    ITKE54,755 pointsBadges:
  • How should I store large files in a MySQL database?

    We have a PHP script that we upload large files with (up to 500MB) and it's stored in a MySQL database. Here's the code we're using: mysql_query("INSERT INTO table VALUES('')"); $uploadedfile = fopen($_FILES['file']['tmp_name'], 'rb'); while (!feof($uploadedfile)) { $line =...

    ITKE54,755 pointsBadges:
  • What factors are there for MySQL database size estimation?

    We have an application database (which includes a table for users). Here's the setup: 1Kbyte of data per user that's based on counting fields * typelength and about 100 things of the same size that belongs to a user (about 0.5 Kbyte). This leads to around 51 Kbytes of data per user. Now, we're...

    ITKE54,755 pointsBadges:
  • How can I determine by database size in MySQL?

    Does anyone know if there's a specific query or function that can determine the size of my database in MySQL? If there isn't one, what's the best way to go about it? I tried this and it came up with 474989023196466.25 MB (even though I know the database is 400 MB). SELECT...

    ITKE54,755 pointsBadges:
  • GROUP BY mysql

    Hi I have started working with a mySQL databse. I need a query that will either make use of "DISTINCT" or "GROUP BY" but that selectes the record that has the highest 'VersionNumber' Can anybody suggest how I would achieve this? Thanks in advance.

    LewisT5 pointsBadges:
  • SQL TAGS

    Why am failling when am using mysql to create database and am using the exactly tags?

    Abcdefg071541520 pointsBadges:
  • Pass table name to procedure including fields

    I want to do the following with a procedure: I have per user that has the same structure. The only difference is the table name. I need to be able to pass the table name to a procedure and retrieve data for that table. At the moment I have this: sp_getdata(id, givendate datetime,tablename...

    Sonyadba5 pointsBadges:
  • Security issues for mysql in a cloud environment?

    Hi everyone, in general, I've been asked by my manager to find out about running a mysql db on a cloud (like this one) -- has anyone done this, and what do you think are the security issues that can come up when doing so? More specifically, IT has questioned me about how auditing would work on a...

    MillyT5 pointsBadges:
  • MYSQL database high availability

    I have cent os based LAMP system. My question is that, what is the best way to make mysql database high availability. As per me database clustering is a good option can you please suggest me.

    Chetanm145 pointsBadges:
  • Creating Views in MYSQL via Sysdate

    Hello Guys, I can create simple views for MYSQL Database tables but I am unsure on how to create a view for the following requirement: I want to create a view which restricts staff user access to a specific table between working hours of 13:00 - 14:00. I have been told that this can be implemented...

    Help1235 pointsBadges:
  • MYSQL DATABASE!!!

    Hello everyone! please help me about transfering MYSQL DATABASE from one computer to another..... I am a student and got to show a project on JDBC. I am using Windows 7 os and Mysql server 5.1.. Thank you.

    Shagy5 pointsBadges:
  • Letting users upload pictures MYSQL Database

    What is the easiest way in DW to allow users to upload a picture to my website. I don't know much coding so ...how can it be done using the functionality of DW. I am using a MYSQL database.

    PBen5 pointsBadges:
  • How to Join MySQL database box to a Windows Server 2008 DNS

    How do I add a Mysql database server to my win 2008 r2 domain. Firstly do I install the Mysql on another Win 2008 box then join to DNS. I also need to add a Apache web server which will be in the DMZ. I need to install the followingMySql database on a seperate server from my DNS server then join...

    Jasonjlewis45 pointsBadges:
  • PHP Datagrid

    Hi! I m new to php and MySQL database. I want to know how whether php provides any class for datagrid

    Fatema10 pointsBadges:
  • How to import simple spreadsheet into mysql database?

    I have a simple spreadsheet (only 2 columns) that I need imported into a mysql database. I can convert the spreadsheet into whatever format I need to (comma delimited), but I need the mysql commands that will import it. Does anybody know how to do this?

    Ingram871,285 pointsBadges:
  • Upgrading for database structure

    hello everyone  Maybe my previous question was not the correct question to ask. I am in the middle of making an application upgrade which includes DB structure upgrade with keeping Data "data loss is not accepted here". I have a complex DB structure in my application which depends "in some...

    Mshafie70 pointsBadges:
  • Free IT Book: Next-Generation Data Center Architectures from Cisco

    This week's free IT book is your complete guide to planning, configuring, managing and troubleshooting NX-OS in enterprise environments: NX-OS and Cisco Nexus Switching. For your copy of this great resource for Next-Generation Data Center Architectures, simply answer one of five questions below and...

    MelanieYarbrough6,345 pointsBadges:
  • Question on achieving ultimate network security

    Hello I would be grateful if you could advise me on a security issue I have on my network security. I have a web application on linux with my data stored on a mysql database on the same server (actually it is a sugarcrm) The sugarcrm which contains information about my clients is used by my...

    It4all5 pointsBadges:
  • Put date time into 15 interval value in MySQL

    does any one know if mysql have a function where I can convert datetime value into : 15 mins interval for example : 03NOV2010:00:00:02 --> 0-15 03NOV2010:00:16:02 --> 15-30

    Iamjeannie30 pointsBadges:
  • Migrating MySQL hosts

    We need to migrate a MySql database from one host to another. Will a simple backup and restore work? Are there references to the database inside itself? Will this work?

    NewnanIT1,110 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following