• Can I do a MySQL dump by a SQL query?

    Can I do a "mysqldump" by a single SQL query? What I basically mean is that I want to dump the whole database. Thanks so much!

    ITKE344,855 pointsBadges:
  • How to rename a MySQL database quickly

    How would I be able to rename a MySQL database quickly? Most of the time, I usually just dump the database and re-import it with a new name. But since this is a huge database, this isn't possible. Can anyone help me here?

    ITKE344,855 pointsBadges:
  • How can we check if a MySQL database exists?

    Can anyone tell me if it's possible to check if our MySQL database exists after we've made a connection? We already know how to check if a table exists in our database but now we need to see if the actual database exists. Thanks!

    ITKE344,855 pointsBadges:
  • Best database option for a .NET application

    My team is has been developing a small application with C# in .NET and we're looking to use a small light weight database (that doesn't use a ton of resources). What would be the best option for us?

    ITKE344,855 pointsBadges:
  • Importing a web page to a database

    How we can import a web page (the full content of the web page) into the particular database? That means you create your own search engine and storing the web page in to the created search engine database.

    ptnaveenraj20 pointsBadges:
  • What’s the best way to create flat file database structures?

    Would anybody be able to share some of the best ways / practices for creating flat file database structures in PHP? From what my partner and I have learned, these frameworks are more of ways to implement SQL-like query syntax. We were also told SQLite is the way to go here. Is that true? Thanks so...

    ITKE344,855 pointsBadges:
  • Deleting and creating databases in Neo4j

    Would it be possible to delete / create several databases in Neo4j (like MySQL)? If I can't do that, would I be able to delete all the nodes / relationships of an existing graph so I can get a clean setup for testing? Thanks so much.

    ITKE344,855 pointsBadges:
  • How to store images in a MongoDB database

    Would it possible to store images in a MongoDB database rather than just text? Should I create an array of images in the database? If that's possible, can I do the same for videos?

    ITKE344,855 pointsBadges:
  • Convert XML to DB2 file

    We still use the command to convert DB2 file to XML (RUNXML) and need a verse option to convert an XML document to a database file.

    UWeber5 pointsBadges:
  • How to duplicate MySQL database

    Would it be possible for me to duplicate my entire MySQL database on a Linux server? I already know I can export / import but the database has over 25 MB so it's not the best solution. Can I use "MySQLdump" or just directly duplicate the database files?

    ITKE344,855 pointsBadges:
  • How to rename a MongoDB database

    I just realized there's a typo in my MongoDB database name and I need to change the name ASAP. I've tried to copy and delete it like this: db.copyDatabase('old_name', 'new_name'); use old_name db.dropDatabase(); Would there be a command to rename it?

    ITKE344,855 pointsBadges:
  • VB.NET code to search if a record already exists or not

    Hi! I need a fresher..I want a VB.net code to search record from SQL database table by using two fields of table as a condition i.e client name and client code before saving any new record and if record already exist in table it give me message for that. I'm sending you the code. Please help...

    Sachinm10 pointsBadges:
  • Would I be able to merge multiple SQLite databases?

    I currently have a large number of SQLite databases (that all have the same schema). Is there a way I can merge them altogether so I can perform a query on all the databases? I thought I could use "ATTACH" but I found out it has a limit of 32 / 64 databases (depending on the memory system). Can...

    ITKE344,855 pointsBadges:
  • How to drop a table in Ruby on Rails database

    In my database, I've added a table that I thought that I was going to need but I don't need to use it anymore. Is there a way to remove that table? I've run several migrations already so the table is in my database. I thought this would handle it but I'm not sure: rails generate migration...

    ITKE344,855 pointsBadges:
  • Can I version my SQL Server database?

    I'm trying to get several of my SQL Server databases under version control. Would anybody have some advice on how I should do this? Basically, I'll want a large collection of generated test data for performance management. Thanks so much!

    ITKE344,855 pointsBadges:
  • What is a data warehouse and how can it benefit organizations?

    I need to know how do I create a star schema for the data warehouse to accommodate the information below: A data warehouse is required to accumulate information on the rental market in London. It will hold information on landlords and tenants (names), houses (no of rooms, type of housing (e.g....

    josenunes5 pointsBadges:
  • Moving SQL Server database without affecting VB 6 code

    I am using VB 6 code with Microsoft Access database. Now I want to move to SQL Server 2008 database without affecting my VB 6 code. Any suggestions?

    vikasjains20 pointsBadges:
  • Cascading combo boxes in Microsoft Access database

    I am a Continuing Education Teacher and I have been asked for help in building a function in a Microsoft Access database. I must say I have not yet found a solution. So, here what is needed: “I have constructed a contacts and networking database that I use to gather information on my professional...

    lawantyson5 pointsBadges:
  • Do all versions of Microsoft SQL Server 2005 support database mirroring?

    Do all versions of Microsoft SQL Server 2005 support database mirroring?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to access multiple records at a time in DBMS

    I want to access multiple records at a time in DBMS.

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

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following