• Best way to backup our production database

    For the past several weeks, we've been looking at CouchDB for a CMS application. What's the best way for us for backing up our production database? Should we possibly clone the database (so we can use it in testing / development). What about just copying the files on a disk? Thanks for the help!

    ITKE371,720 pointsBadges:
  • How to insert row number using SQL

    When importing data from Excel into MS Access, how do you insert a row number using SQL?

    JimStAubin201515 pointsBadges:
  • Performance issue with MySQL database backup

    My friend and I have been trying to create a regular backup for a production database (large one, in fact). The database has both InnoDB and MyISAM tables. We have been using mysqldump but it keeps taking longer and longer each time. Sometimes, the server is even unresponsive when the dump is...

    ITKE371,720 pointsBadges:
  • Backup SQLite database to SD card on Android

    I'm trying to add a feature to one of my Android applications that would back up a SQLite database to my SD card. Is there a way to do this? Thank you very much!

    ITKE371,720 pointsBadges:
  • Add New Record in database form

    The form in my database will not allow me to add a record - the record functions are grayed out. I was able to add a new record. Then I was not. Probably user error, but not sure what to do.

    jsuddath5 pointsBadges:
  • How to restore single table my MySQL database backup

    We currently have a mysqldump that backups our MySQL database (which has a bunch of tables with roughly 440 MBs). We've been trying to restore one of the tables from the mysqldump. Would that be possible? Thanks so much!

    ITKE371,720 pointsBadges:
  • How to backup SQLite database to SD card

    Does anyone know if it's possible to backup our database to a SD card automatically in my Android app? After that's done, is there a way to restore it too?

    ITKE371,720 pointsBadges:
  • How can I backup a SQLite database to my SD card?

    I'm trying to add a feature in my Android application that would automatically back up a SQLite database to my SD card. Is there a way to do this? Thank you very much.

    ITKE371,720 pointsBadges:
  • SQL Script for monitoring backup progress of database

    I noticed that whenever I do a backup of a database using SQL Server Management Studio, I usually get this image of how the process is going / how much longer it will take. But if I do the backup with a script, is there some way I can monitor the whole process?

    ITKE371,720 pointsBadges:
  • Import and Export data from AS/400 using ODBC

    I imported data from AS/400 database file into an Excel sheet, using ODBC. I selected Microsoft query in order to retrieve data. How can I export data into AS/400 database file?

    Geek51180 pointsBadges:
  • Backup schema in SQL Server 2005

    Would there be a way to backup just the schema in a SQL Server 2005 database? I don't need records, just the structure. Thank you!

    ITKE371,720 pointsBadges:
  • How to automate SQL Server database backup

    I've been generating SQL Scripts on a daily basis so we can have a backup our SQL Azure database. But we're working to do this on an automated level. Is there a way to do this?

    ITKE371,720 pointsBadges:
  • Database design for the application with cloud capability

    Does it require/available any special DB design for the application with cloud capability? We need to design database for our new new project application. Any one please suggest if using DB Design especially for cloud capability.

    Muthuramalingam45 pointsBadges:
  • MySQL: Joining select counts from same table

    Please I want to join the statements below to get a single output Select count(*) TotalAccounts,Affiliate from realdb.tbl_logs group by affiliate Select count(*) TotalGen,Affiliate from realdb.tbl_logs where lastdate =curdate() group by affiliate Select count(*) TotalNotGen,Affiliate from...

    MaameBamfua5 pointsBadges:
  • How to backup a MySQL database daily

    As of today, I have a 20 GB MySQL database that I backup daily using mysqldump. But there's one problem with it: When I don't take down the web server, it takes forever to backup (only takes 5-10 minutes when I take it down). Would there be a better way to do a backup for this?

    ITKE371,720 pointsBadges:
  • Backing up H2 database engine when it’s running

    Hi experts, I have a question for all of you! I'm building a web application with a H2 database engine. But I'm having issues backing up the data when the database is running. Is it stored in the file system? Would I be able to backup the outputted files? Thanks so much.

    ITKE371,720 pointsBadges:
  • How to backup MySQL database automatically on Windows Server

    I've been searching everywhere to find an answer to my question but still can't find anything. Would anyone happen to know if it's possible to backup a MySQL database automatically during certain times of the day to a specific server / email attachment? Should we use the Windows Task Scheduler?...

    ITKE371,720 pointsBadges:
  • How to backup MySQL users and their privileges

    Is there a way to actually backup our MySQL users and their privileges? Would mysqldump work? Here's what I have so far: mysqldump -d -u root -p MyTable > Schema.sql Thanks so much!

    ITKE371,720 pointsBadges:
  • Store data in database in Hindi

    How can I store data in DB in hindi using django-model?

    sudhakar045 pointsBadges:
  • Query/400 not displaying column descriptions for DDL defined table

    We recently updated a file and converted it from DDS to DDL during the process. During testing no one mentioned the column descriptions were no longer displayed when using Query/400. Is there a way to make Query/400 display column descriptions for DDL defined tables?

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