• How can I my MySQL database file working?

    I was recently given a MySQL database file and now I need to restore it as a database on Windows Server 2008. I've been trying to use MySQL Administrator but I keep getting this error: The selected file was generated by mysqldump and cannot be restored by this application. What should I do to get...

    ITKE345,950 pointsBadges:
  • Can we have multiple primary keys in a single table on a SQL Server database?

    For our database, is it possible for us to have multiple keys in a single table? We're using an SQL Server database.

    ITKE345,950 pointsBadges:
  • Visual Basic 2012 time format for label link to database

    I am new to programming and i was trying to figure out how to display a label i have as 12 hour format from the current 24 hour format. currently the label pulls the data from a Mysql database but display as 24 hour format since that's how Mysql stores it. all i want to do is have the label display...

    jafranklin775 pointsBadges:
  • Clustering in SQL Server 2005

    What's the steps to use (Clustering ) in any SQL Server 2005 System??

    ScorpionSQL10 pointsBadges:
  • I want to parse data from one field into two based upon criteria.

    I have lots of data with disparate information in one field and I need to take all information to the right of any * that might appear into a separate field? There will be an * about 10% of the time. Examples of the field in question. Example 1: CKD Stage I ****250.40/585.1 Example 2: /Prosthesis...

    JohnSouthFlorida5 pointsBadges:
  • Access 2007 setting up repetitive entry form

    I'm doing a database for our transportation company. How can I set up multiple expenses for multiple vehicles? How can I set up a form for data to be entered by choosing a vehicle, a month during the year, and multiple expenses on a single form?

    Net201015 pointsBadges:
  • How to search for a local file programmatically using C/C++

    HOW, I develop a c/c++/java program for searching a file on my Personal computer

    Vivekagar65 pointsBadges:
  • Add to Excel spreadsheet from System i

    I want to add data from a DB2 file to an Excel template that has a header row and totals certain columns without overwriting the header row or the totals.

    ljjk1225 pointsBadges:
  • How can I run a mysqldump without locking up the database?

    I'm trying to copy a live production database onto my development database. Would there be a way to do this without locking up the live database? I've been using this: mysqldump -u root --password=xxx -h xxx my_db1 | mysql -u root --password=xxx -h localhost my_db1 The only problem is that it's...

    ITKE345,950 pointsBadges:
  • How to do auto-increment values in PostgreSQL

    My department is switching over from MySQL to PostgreSQL and we need some help with auto-incrementing values. We saw in the PostgreSQL document that the datatype "serial" should work but we keep getting errors. Thank you very much.

    ITKE345,950 pointsBadges:
  • MySQL: How to restrict certain tables from mysqldump

    Does anyone know of a way to restrict certain tables from the mysqldump command? I'm using the following syntax that only dumps table1 and table2: mysqldump -u username -p database table1 table2 > database.sql Would there be way that I can dump all the others, except for table1 and table2? Would...

    ITKE345,950 pointsBadges:
  • How we can import a SQL dump into a PostgreSQL database?

    We're in the process of switching hosts and our old host provided a SQL dump of the PostgreSQL database of our site. Now, we're looking to set it up on a local WAMP server to do some testing. But we're running into an issue with importing that database in the PostgreSQL 9 that we have set up. We've...

    ITKE345,950 pointsBadges:
  • SQL Server database: How to interpret precision and scale of a number

    We have this column in our SQL Server database: decimal(5,2) but we're not sure how to interpret this. When we're looking at it through SQL Server Management Studio, we can see what it means: decimal(Numeric precision, Numeric scale). What does precision and scale mean in real terms?

    ITKE345,950 pointsBadges:
  • Can I import a single MySQL database using a mysqldump?

    Does anyone if it would be possible to actually import a single database from an all databases mysqldump? I've already tried modifying the file manually but it didn't work. Are there any command line options to do this? We're removing a ton of databases but we need the option to restore one if need...

    ITKE345,950 pointsBadges:
  • How to list the tables from a SQLite database file

    What SQL can I use to list all the tables in a SQLite database file (along with the rows inside those tables)? Thank so much for the help.

    ITKE345,950 pointsBadges:
  • SQL Server database: Inserting a table using the input from another table

    I've been trying to insert a table using the input from one of our other tables. I know this is possible but I'm having trouble with the correct Syntax for the SQL engine of the day. Would anyone know of a silver-bullet syntax coming from a SQL standard that would allow us insert the values without...

    ITKE345,950 pointsBadges:
  • Deleting a MySQL database through a Linux shell command

    For my MySQL database, I constantly update the schema files and then delete / recreate the database so our new schema is created. I do this by MySQL Query Browser, login and then delete the database. Now I'm looking to delete the database through a Linux shell command in Ubuntu.

    ITKE345,950 pointsBadges:
  • What’s the better database option: MySQL or SQLite?

    Our organization is deciding to use either SQLite and MySQL for our database. We understand that SQLite is a single-file database and MySQL is just a normal database. But in your opinion, what's the better option?

    ITKE345,950 pointsBadges:
  • How should we be careful with a live database?

    For one of our clients, we work with them on their live database when they come up with a problem or they have bad data. Similar to Unix root access, it's pretty pretty dangerous. What would be the number one thing that we should learn about operating with live data.

    ITKE345,950 pointsBadges:
  • Why is NoSQL better than traditional RDBMS?

    I'm relatively new to the database world and I'm just getting into NoSQL. I want to know what makes NoSQL better than traditional RDBMS?

    ITKE345,950 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