• 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 =...

    ITKE346,195 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...

    ITKE346,195 pointsBadges:
  • How to search for Access 2003 record using VB6

    How can I search for the last updated record in my Access 2003 database from VB 6, the code I'm using only returns the first record on the database. On Error GoTo err: Dim sql As String Set con = New ADODB.Connection con.CursorLocation = adUseClient con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data...

    Josemw10 pointsBadges:
  • Create a form/subform in Access 2007 that displays multiple records to be updated.

    I have an Access 2007 database that has 2 tables: 1st table is the Employee table that contains Employee ID, Employee Name, and the Location code they work at. 2nd table is the Work Log table that contains the Employee ID, date they worked, and 2 yes/no fields for paperwork received and paperwork...

    mjp126215 pointsBadges:
  • Can I use a Linksys print server as a bridge or access point?

    Can I use a Linksys print server as a bridge or access point?  I want to use it to connect a VoIP phone.

    4jbshere5 pointsBadges:
  • Will streaming media work in a motorhome?

    I am new to Streaming.  A couple of questions.  How are my computers, VCR, and TV connected to the provider.  We are planning to buy a motorhome and need to know if this is a good solution to use on the road? Rex Ralston netrex@aol.com

    Rnetrex20045 pointsBadges:
  • What’s the best option for storing graphs in persistent storage?

    I'm wondering what would be the best way for me to store my graphs in persistent storage (for analysis, search, clustering, etc.). I'm considering NEO4J but I'm looking what other options are available to me. Would Cassandra or MySQL work for me? Thanks for the help.

    ITKE346,195 pointsBadges:
  • Rumba AS/400 – limited library storage

    Hi! I'm very new to AS/400 Rumba. Working in a logistic group, we've got a shared library of products weight between two production site. We are limited to 8000 product weight for the two sites, when we try to write a new product weight, it erases an old one. This causes a checking issue. How could...

    davidmalta15 pointsBadges:
  • Restore a SQL Express 10.0 database

    How can I restore a SQL Express 10.0 database on SQL Express 10.5?

    sam4umore5 pointsBadges:
  • SQL Server 2008 database backup terminating abnormally

    I'm running this code for backing up and to have backup log: backup database adventureworks to disk = 'g:radvent6.bak' mirror to disk='g:radvent7.bak' with format,checksum,stop_on_error use adventureworks insert into HumanResources.department (name,groupname)values('dreee','reserch') backup log...

    Tablestructure15 pointsBadges:
  • How I can convert FXP to PRG? (Foxpro-2.6)

    I have lost of my Foxpro 2.6 .prg file. I have only .FXP foxpro file. I want to convert .FXP to .PRG. Remember I have long statement in PRG (above 255 characters). Give me a proper solution. Thanks & Regards Narayan Gadri.

    nagadri5 pointsBadges:
  • Date drop out of field in Microsoft Access

    Dates drop out of field....I processed the request and the required response date should appear in the field but it's coming up blank. Can you help?

    zgarth10 pointsBadges:
  • What is in-memory management?

    What is the restoration of in-memory management?

    ZECK99999999995 pointsBadges:
  • Field changes back to default in Microsoft Access

    Manage a large access database that is linked all over the placE, my question? I have an O & C field. Once C is typed in field, it should stay closed. Field is defaulting back to O. What would cause this change?

    zgarth10 pointsBadges:
  • How Would You Define Database Concepts?

    I am recruiting for a DBA for an ecommerce company and so far every candidate I have submitted to the HM has been rejected as they "do not understand database concepts". Circling round to the rejected candidates they all comment the HM is asking programming questions yet when I ask the HM and...

    tekhunter5 pointsBadges:
  • Should I use SQLite or Shared Preferences for data storage?

    For storage purposes, does anyone think there's more of an advantage using SQLite over Shared Preferences? My application data is currently small right now but it might rise quickly over the next few months. Is there any differences in speed between the two? In your honest opinion, which option...

    ITKE346,195 pointsBadges:
  • Eternus DX60 – Failing NL-SAS disks

    Hi, We are currently using a Fujitsu Eternus DX60 with NL-SAS disks as storage for our virtual machines. During the last 18 month 8 out of 12 disks had to be replaced because the system claimed them to be failing. Fujitsu Support told me that this is totally normal. Since our support contract...

    TimoWille15 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...

    ITKE346,195 pointsBadges:
  • Database structure and application outsource protocol

    When an application has been outsourced, Don't the software developer need to share the database structure with the client prior to development

    Bobharis5 pointsBadges:
  • Creating a new database using an MDF file

    My database saves as MDF. I want to know what are the steps to restore or create a new database using a MDF file? I tried to restore as usual but it shows an error. Please help.

    Thrstorm5 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