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

    ITKE434,245 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!

    ITKE434,245 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.

    ITKE434,245 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.

    ITKE434,245 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.

    ITKE434,245 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.

    ITKE434,245 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.

    ITKE434,245 pointsBadges:
  • Copy PostgreSQL database or schema

    Does anyone know if it's possible to create an actual copy of a PostgreSQL database? Or even the schema? We're looking to do some testing on a particular schema (which has a lot of updates) and we need to copy it because we want to compare it to the original.

    ITKE434,245 pointsBadges:
  • PostgreSQL to SQL Server database migration

    Our department has a PostgreSQL database that we need to move over to SQL Server. That includes both the schema and all the data. It's becoming a very slow process manually and we need something automatically. What should we do here? We're currently moving over the tables one-by-one.

    ITKE434,245 pointsBadges:
  • Recover MySQL deleted rows

    On MySQL, all of my data was deleted accidentally and I'm hoping there's a way to recover all of it? Is it possible? Thank you so much.

    ITKE434,245 pointsBadges:
  • Transfer data between two MySQL databases

    Is there a way for me to transfer my data between two different MySQL databases? I'm looking to use a code not a tool. Thank you very much.

    ITKE434,245 pointsBadges:
  • Create MySQL database with a dot in name

    Would MySQL allow me to create a database that has a (.) in its name? Several collegues told me that it is not possible but I wanted to check with you experts. Thanks!

    ITKE434,245 pointsBadges:
  • What queries are running on my PostgreSQL database?

    I'm running a PostgreSQL database and one of my applications runs queries on it. Is there a way I can see which queries are running on it? The computer I'm running it on is a Linux.

    ITKE434,245 pointsBadges:
  • Expiration date for Redis database key

    For my Redis database, is there some way to get the expiration date of a key. Is there a certain command I have to use? I want to see how many seconds are left.

    ITKE434,245 pointsBadges:
  • Backup MySQL database on Windows Server

    Would I be able to backup my MySQL database automatically (throughout each day) to my designated Windows Server? If that's not possible, how about a email attachment? Thanks for the help.

    ITKE434,245 pointsBadges:
  • How to clone a MySQL database

    We currently have a MySQL database on our server and it has roughly 100 tables. We have to clone the entire database but it needs to have a new name / copied data. What's the process for this? Thank you.

    ITKE434,245 pointsBadges:
  • Maximum size for MySQL table

    Does anyone know the maximum size for a MySQL table? Is it close to 5-10 million for 80GB. If that's the case, should I compress all of my data? Or should I split the table instead?

    ITKE434,245 pointsBadges:
  • Finding SQL Server database string

    In my SQL Server database (which was given to me by a co-worker), I have to find one, specific string. Here's the issue: I have no idea where it is (don't know the name of the table / column). How can I go about doing this?

    ITKE434,245 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