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

ITKE1,067,865 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.

ITKE1,067,865 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.

ITKE1,067,865 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.

ITKE1,067,865 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!

ITKE1,067,865 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...

ITKE1,067,865 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...

ITKE1,067,865 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?

ITKE1,067,865 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...

ITKE1,067,865 pointsBadges:

Comparing Blob file size

Hi, I have a table where the file is stored as a blob in one column and the size of the file in another column. I need to fetch each blob from the blob column and find the size of that blob. And I need to compare the size I got to the corresponding size mentioned the table. Please provide me a...

prathyusha5 pointsBadges:

Can you accept or decline task in Microsoft Access?

Can task be forwarded to a person among group of persons in Access?

ahonutere5 pointsBadges:

ODBC connection

Is there is anyway I can know the remote IP that connecting to my server (AS/400 server) via ODBC? The AS/400 log dose not show any details about the IP it only tell me that the connection happen but without any details. Also some time the connection failed without report any info. Please, I need...

osamah205 pointsBadges:

Sorting of students strength on one form in Microsoft Access

I have a table named Students with the following fields and data ID Level Session Gender Regular/Plus Shift Program 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 2013-2015 MALE REGULAR MORNING...

MUHAMMADYOUSAF10 pointsBadges:

Issues deleting records in SQL database

I'm having issues deleting records in a SQL database. What should I do?

rockquery45 pointsBadges:

Updating forms in Access

I have updated a form with membership information, adding several new fields. How do I get Access to update previous entries to include the new fields?

lmack15 pointsBadges: