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

    ITKE435,945 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.

    ITKE435,945 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.

    ITKE435,945 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.

    ITKE435,945 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.

    ITKE435,945 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.

    ITKE435,945 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.

    ITKE435,945 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!

    ITKE435,945 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.

    ITKE435,945 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.

    ITKE435,945 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.

    ITKE435,945 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.

    ITKE435,945 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?

    ITKE435,945 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?

    ITKE435,945 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.

    ITKE435,945 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?

    ITKE435,945 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!

    ITKE435,945 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.

    ITKE435,945 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?

    ITKE435,945 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