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

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

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

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

    ITKE828,900 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!

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

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

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

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

    ITKE828,900 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?

    ITKE828,900 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?

    ITKE828,900 pointsBadges:
  • MySQL database tables modified

    For my MySQL database, how can I figure out which of my tables have been modified / changed in the past hour? My tables don't have a timestamp column.

    ITKE828,900 pointsBadges:
  • How can I get the DDL of a column?

    How can I get the DDL of a column? Suppose I declared a column with varchar2(10). So I need to extract that length of varchar i.e 10.

    apsg112905 pointsBadges:
  • How to archive live MySQL database

    Our department has a live MySQL database and we want to archive the data daily so we can run different queries on it (without affecting the live database). How can we go about this? Would MySQL replication work for this?

    ITKE828,900 pointsBadges:
  • How to backup MySQL users

    Would it be possible for me to backup all of our MySQL users / privileges? Would something like MySQLdump work? Thanks!

    ITKE828,900 pointsBadges:
  • Setting MySQL row as read-only

    In my MySQL row, I have very important data that I don't want changed at all. Can I set that row to read-only so no one can update / change it? If that's not possible, is there another way I can make sure the data isn't changed? Appreciate the support.

    ITKE828,900 pointsBadges:
  • PostgreSQL to MySQL data migration

    I recently changed my database from PostgreSQL to MySQL. But how can I do a data migration from one to the other? Is there a certain command to migrate the database data?

    ITKE828,900 pointsBadges:
  • What’s the maximum MySQL concurrent connections?

    I work for a community college and I'm looking to revamp our social networking efforts (particularly the website). To do that - I have to setup a MySQL database. To start - the application can hold roughly 10,000 users. So my question is: Is there a maximum number of concurrent MySQL connections?...

    ITKE828,900 pointsBadges:
  • Export MongoDB records to CSV

    Could I possibly export my MongoDB records to a CSV file? I've tried this code: mongoexport --host localhost --db dbname --collection name --csv > test.csv But it keeps telling me to specify the fields that I want to export. Can I just export everything (not specify which fields)? Thank you.

    ITKE828,900 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