• How to import MySQL database dump file in Java

    Is there a way for me to import my MySQL database dump file programmatically in a Java program? I've tried the below code but nothing is working. Connection conn = dbConnectionSource.getConnection(); Statement stmt = conn.createStatement(); stmt.execute(FileUtils.readFileToString(new...

    ITKE828,350 pointsBadges:
  • How to encrypt my database

    With all these hacks going around, I need my database to be very secure (particularly my hard disk). But I'm not sure which databases support encryption. Can someone help me out? If it's not possible, are there other ways I can encrypt my database. Thanks!

    ITKE828,350 pointsBadges:
  • Compact Microsoft Access database in VBA

    My apologizes for the brief question but, in Microsoft Access, can I compact my current database using VBA? Thanks!

    ITKE828,350 pointsBadges:
  • SQL Server 2012 error message when restoring database

    I keep getting this odd error message in SQL Server 2012 when I'm trying to restore a backup that was made from a previous version. Here's the error message I'm getting: System.Data.SqlClient.SqlError: Directory lookup for the file "C:\PROGRAM FILES\MICROSOFT SQL...

    ITKE828,350 pointsBadges:
  • MS Access 2007: 15 years of contract

    Hello, I'm a student in an intern program right now. My organization give me a MS Access file that contain information of contract workers. They asked me to separate which of the workers that almost work for 15 years and make a reminder for user 6 months before due date. My department scope is...

    Vencro25 pointsBadges:
  • MySQL: Get last deleted ID

    In MySQL, is there a way for me to get the actual last deleted ID after a row has been deleted? Perhaps a command / query that's similar to getting the last inserted ID. Thanks.

    ITKE828,350 pointsBadges:
  • How to get list of tables in Microsoft Access database through C#

    I just opened a connection to a Microsoft Access file through C# but would there be a way for me to retrieve a list of tables that exist in the Access database? I appreciate the help.

    ITKE828,350 pointsBadges:
  • DB2: Decrease column length

    Can I decrease the column length in DB2? In one of my columns, it's currently defined as VARCHAR(80). I want to move it to VARCHAR(60). How can I do that?

    ITKE828,350 pointsBadges:
  • Error when accessing MySQL database through web admin console

    For the past week, I've been trying to access a MySQL database through the web admin console. But I keep getting this strange error message: SQL select table_schema,table_name from information_schema.views where table_schema = ? failed : Got error 28 from storage engine. What should I do?

    ITKE828,350 pointsBadges:
  • Can two foreign keys reference the same primary key that is team table and fextures table having team a and team b referencing the team table primary

    Can two foreign keys reference the same primary key on another table. That I have team table attributes (Team_id, Team_name, Team_captain) and fixtures table having this attributes (Fixtures_id, fixture_time, fixture_date, fixture_venue, 1team_id, 2team_id). My question is this: Is it possible for...

    jupake15 pointsBadges:
  • Loading image into MySQL database from Excel file

    I have an excel file that contains an image in the first col. When I save it to an csv format, the excel program creates two images ( 1 small, 1 large) for each line in the excel file. How do I load both the file data and the large image into my mysql database?

    Wlm49hv5 pointsBadges:
  • Partition MySQL database by date automatically

    My colleague and I have a MySQL database that we need to partition by date (especially the month / year). But when we add new data, we don't want to update the database manually. How can we do it automatically? What's the process? Thank you.

    ITKE828,350 pointsBadges:
  • Incremental backup of MySQL log files

    We're currently using MySQL and several of our tables are InnoDB. This is followed by a replication to a slave server. Now, here's what we need to do: Backup our MySQL log files on a daily basis. What's the best way to do an incremental backup? Thanks!

    ITKE828,350 pointsBadges:
  • Issue Exchange 2013 error mount database

    Server exchange can't mount database. Error failed an active manageroperation failed, disk or controller issues may cause slow mount, failed due to timeout 300 seconds on server. I need help with this urgent.

    Wmorales5 pointsBadges:
  • Database connectivity from Oracle Forms

    We are having a legacy running running on Oracle Forms and Reports. I want to change the database connection to point to a different database, how do I do that? P.S: I am pretty new to forms and reports

    Ms123115 pointsBadges:
  • Add comment to SQL code in MySQL

    One of my co-workers sent me a SQL code and I need to add a comment to it. Is there a way to do that? This is currently for MySQL. Thank you so much.

    ITKE828,350 pointsBadges:
  • Creating Microsoft Access database in C#

    We have to create a Microsoft Access database using C#. What's the process to do that? Is there an API that we can use for the creation? Thanks.

    ITKE828,350 pointsBadges:
  • See if column exists in MySQL table

    Would I be able to see if a particular column / field name exists in a MySQL table? What's the best way to do that? Appreciate the help.

    ITKE828,350 pointsBadges:
  • Convert MySQL database to SQLite

    Our department has one small MySQL database (roughly 6/7 tables) that we have to convert to a SQLite database. We're not sure of the process but are there any tools out there that can do this automatically? Thanks so much.

    ITKE828,350 pointsBadges:
  • Connection limit on PostgreSQL database

    On our PostgreSQL database, my partner and I need to find out if a connection limit has been set on a per user basis. We figured out how to set the limit. Now we just need to know if such a limit was set. Thank you.

    ITKE828,350 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.

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

Following