• How should I start my data analysis?

    I have a database which has machine data (tables like: machine cycles, machine phases and many more ) and I am suppose to analysis this data. Meaning, with the data present in different tables, I have to filter out or rather define standard machine cycles, standard machine phase etc. Hence, can you...

    rakeshmurthy5 pointsBadges:
  • Conversion of Microsoft Excel formula to Access

    How do I convert the below given formula of MS Excel to MS Access for the following data: ID Level Session Gender Regular/Plus Shift Programme Section 13 INTERMEDIATE 2013-2015 MALE REGULAR MORNING FSC ENG FSC B-4 14 INTERMEDIATE 2013-2015 MALE REGULAR MORNING FSC ENG FSC B-3 15 INTERMEDIATE...

    MUHAMMADYOUSAF10 pointsBadges:
  • Table that has multiple records for one field

    I have made a database for a school that has Students info, teachers info, parents info, and some other tables. My problem is that I want a table that has subjects that are shared by all students that I print out a report that has students info, teachers info and that table for performance with...

    VinBagz20 pointsBadges:
  • Force replace when backing up SQL database

    We're trying to back up our database using this code: sqlcmd -S servername -Q "BACKUP DATABASE [DBName] TO DISK = 'C:\backup.bak'" It's been working but there's one little issue: When the backup file already exists, the data gets appended to the file. We need it to replace the file. Is there a way...

    ITKE361,585 pointsBadges:
  • MySQL backup option for Windows Server

    What would be the best MySQL backup option for Windows Server? I need to only backup my data. Also, the backup needs to be done somewhere outside the the server and I would prefer a free option too. Thank you!

    ITKE361,585 pointsBadges:
  • Backup stored procedures in MySQL

    With MySQL, I've been using mysqldump to back it up daily. But how do I store stored procedures? Is it backed up with everything else?

    ITKE361,585 pointsBadges:
  • How to run a MySQL database backup during the day

    We're trying to backup a MySQL database but we need it run during day (so there is a load on the server). We can't have it impact Apache and our other databases that are running on the same server. Can we use the mysqldump command? Appreciate it

    ITKE361,585 pointsBadges:
  • Best way to backup a MySQL server

    Hi experts! In everyone's opinion, what would be the best way to back up a MySQL server? Is there a way to do it that wouldn't bring down the server? Should we just use the MySQL Administrator tools? We appreciate the help.

    ITKE361,585 pointsBadges:
  • Restore SQL Server 2005 database backup over network

    I apologize that it's old software but we're using SQL Server 2005. Does anyone know if we can restore a database backup using Server 2005 over our entire network? We would appreciate any help.

    ITKE361,585 pointsBadges:
  • Backup database in MySQL

    We currently have a 4 GB database that's in MySQL. What's the best way for us to back it up? We have had a few times that we almost lost all of the data. In another question, would there be a way to speed up the backup process in the event we need to recover? I appreciate the help.

    ITKE361,585 pointsBadges:
  • Cascading combo boxes in Microsoft Access database

    I am a Continuing Education Teacher and I have been asked for help in building a function in a Microsoft Access database. I must say I have not yet found a solution. So, here what is needed: “I have constructed a contacts and networking database that I use to gather information on my professional...

    lawantyson5 pointsBadges:
  • Automatically backup PostgreSQL database on Linux

    Does anyone know how to automatically backup a PostgreSQL database that's on Linux daily? Thanks so much!

    ITKE361,585 pointsBadges:
  • How to restore MySQL database Windows tool?

    Hello, I have a database already created. Now, I would like to restore a backup copy. Does the commands MySQL -<id> -p <database> < backup.sql delete the existing database and then create a new one or do I have to do the following: Delete the existing DB Create the database Restore...

    9rudolf5 pointsBadges:
  • Microsoft Access: Reports in Custom Groups vanish

    I have a couple different groups under Customs Groups in Access, and more than once now, when I open a Group there is nothing in it?

    Jaljets5 pointsBadges:
  • What database program should we use for our big data?

    We have a bunch of text files , which range between 300 - 400 GB. Here's the format: key1 value_a key1 value_b key1 value_c key2 value_d key3 value_e .... So each line is composed by a key and value. I'm trying to create a database that would let us query all value of a key. But we're having issues...

    ITKE361,585 pointsBadges:
  • Paste records in OLE Unbound Excel Object in Access Form

    Ok so I have built a database that is used to house and manipulate records that I get from a monthly report that is posted online. Basically I work for the Army and we have over 50 units. Each unit has anywhere from 10 to 1000 soldiers in it. I initially had tried to build a database with a table...

    Brianaaskew40 pointsBadges:
  • Access PivotTavle View field level events not firing

    I have created a PivotTable view in Access 2010. I want to allow the user to double-click on a field and trigger an event that updates the underlying data and refreshes the view. This is a no brainer in VBA, but when I go into Design View and try to add code to an event, the event doesn't work. For...

    eswirkal5 pointsBadges:
  • Database that’s not limited with RAM size

    For a project we're about to start, we're looking for this type of database: Non-persistent Keys of database need to be updated once in 3-6 hours Quickly select data by key DBMS Not in-memory Java support We were looking at MongoDB but it has high fragmentation costs. Redis looks good but our data...

    ITKE361,585 pointsBadges:
  • Output results of Hive query into CSV file

    We're trying to put the results of a Hive query into a CSV file. Here's the command we came up with: insert overwrite directory '/home/output.csv' select books from table; So, when it's done, it says completed but we can't find the file. Where is it? Or should we extract it in a different way?

    ITKE361,585 pointsBadges:
  • Big data: How to get started

    We've been using R for several years and now we're starting to get into Python. We've been using RDBMS systems for data warehousing and R for number-crunching. Now, we think it's time to get more involved with big data analysis. Does anyone know how we should get started (basically how to use...

    ITKE361,585 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