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

    ITKE439,630 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?...

    ITKE439,630 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.

    ITKE439,630 pointsBadges:
  • Migrate MySQL database to MongoDB

    I'm looking to change databases for development purposes. I'm thinking of going from MySQL to MongoDB. What's the best way to do this? Thanks!

    ITKE439,630 pointsBadges:
  • Macro in Microsoft Access

    What is a macro in Microsoft Access?

    ajmeeljujju5 pointsBadges:
  • What is the difference between logical data modelling, conceptual data modelling and physical data modelling?

    Can anyone tell me what is the difference between conceptual data modelling, logical data modelling and physical data modelling?

    Abusadat5 pointsBadges:
  • Ipnat.sys related error on Win2003 Server

    Happy 2006 to you all! One of my customers is getting a strange error since someone disabled (deleted actually!!) the Terminal Server service on their Windows 2003 Server SP1. The error that pops up is: "Windows Firewall cannot run because another program or service is running that might use the...

    Hedgehog0 pointsBadges:
  • Do we have too many records in our MySQL InnoDB?

    We currently have a MySQL InnoDB that has millions of records. We're worried that it's too much for the database. Would you agree? Can the database handle this? Just because we noticed that several of our queries are much slower now. Thank you.

    ITKE439,630 pointsBadges:
  • How to merge SQLite databases

    Our department has a bunch of SQLite databases (they all have the same schema). Can we merge several of them together so I can do a query on them? Thanks!

    ITKE439,630 pointsBadges:
  • Find biggest tables and rows in SQL Server database

    I'm using SQL Server and I'm trying to find the biggest objects in my database. Basically - I have to find the largest tables, followed by which rows (in that table) are the largest. Is there a tool to do this? Can I run some sort of query?

    ITKE439,630 pointsBadges:
  • Add downloadable, member-protected files on website

    I'd like to build my own website so I can upload content to my website for "members only" can download .mp4 files and .zip compressed pictures. What are the steps I would need to learn? Database? PHP? How do I upload content for others to download etc?

    Felixx5 pointsBadges:
  • What is the role of the DBA in the database management system?

    What is the role of the DBA in the database management system?

    NOORMOHD5 pointsBadges:
  • MS Access Query: Plan Summary

    I am trying to update a query that I have currently. I have a field named "Plan" and I have another field that is not in the query yet named "Plan Summary". I would like the query to show me the "Plan Summary", but when the "Plan Summary" is blank I would like it to show the value in "Plan". Is...

    queryquestioner30 pointsBadges:
  • adding partition to existing non-partitioned table

    Hello all! I have a tables without partitions and I now want to partition it. How do I go about this? I tired alter table ... add partition... but it errors with "ORA-14501: object is not partitioned " So I tried to re-create the table with partitions: create table quote_header_test as select *...

    Skovac0 pointsBadges:
  • Error message when importing SQL file: MySQL server has gone away

    I recently tried to import one of my large SQL files through phpMyAdmin but this odd error message keeps popping up: MySQL server has gone away. What does that mean? What can I do about this?

    ITKE439,630 pointsBadges:
  • How do I upload an image or images at runtime in Visual Basic 6

    I have designed an interface by which users are soppose to UPLOAD their thier pictures but they cannot do that at RUN TIME. Please help me with the CODE. am using VB6. It is a library registration form with Name, Index, Picture. we are able to update the name and index but unable to UPDATE the...

    Okappaw55 pointsBadges:
  • Writing a program in FoxPro 2.6

    How can I write a program in FoxPro 2.6?

    felixdaniel5 pointsBadges:
  • Create flat file in AS/400

    Is there a sample code in RPG to create a flat file?

    Niteshradven5 pointsBadges:
  • Database Admin…

    Will the real DBA please standup! Is there a forum just for DBAs? I got started in 1995 when a recruiter asked me if I wanted to be a DBA on an AS/400? Was I surprised! However, the shop that hired me did not understand what a DBA on AS/400 really did... nor did I. Well, I ended up doing security,...

    Znason460 pointsBadges:
  • What is the the candidate key in my database?

    What does the candidate key look like in my database?

    Chalahani5 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