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

    ITKE347,520 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...

    ITKE347,520 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?

    ITKE347,520 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...

    ITKE347,520 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.

    ITKE347,520 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...

    ITKE347,520 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.

    ITKE347,520 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?

    ITKE347,520 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.

    ITKE347,520 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?

    ITKE347,520 pointsBadges:
  • How to fix a persistent connection error in Django

    I've been using Django with Apache, mod_wsgi and PostgreSQL (they are all on the same host) and now I need to handle a ton of dynamic page requests. But I've run into a problem with Django: It doesn't have a persistent database connection and keeps reconnecting for each question (which takes about...

    ITKE347,520 pointsBadges:
  • What’s the difference between create database and create schema in MySQL?

    For one of my projects, I'm looking to use a "information_schema" database and metadata but I'm still wondering if there are any actually differences between the "create schema" command and the "create database" command in MySQL. What are the differences (if there are any at all)? Thanks!

    ITKE347,520 pointsBadges:
  • What’s the best way to connect and query my database for a set of C# records?

    I need some big time help with my database. What's the best way to connect and query my database for a set of records in C#? Please note that this is for a SQL Server database. Thank you!

    ITKE347,520 pointsBadges:
  • Adding a new table to our SQLite database

    My team and I have already created SQLite tables but we're looking to add a new table to our database. Here's the DB version: private static final int DATABASE_VERSION = 2; We've also added this string to create the table: private static final String DATABASE_CREATE_color = "CREATE TABLE IF NOT...

    ITKE347,520 pointsBadges:
  • What’s the maximum MIMEtype length for storing type in a database?

    Would anyone be able to tell me what people are using for the length of a MIMEType field in their databases? The longest one that we use is 72 bytes but we're looking to see if there are longer ones. We've actually started using 250 now but is there anything longer? Thanks for the help.

    ITKE347,520 pointsBadges:
  • How to remote connect to a ClearDB Heroku database

    How would I be able to perform a remote connection my ClearDB MySQL database (on Heroku) using the MySQL Query Browser? Basically, I'm trying to get a URL, port, login and password. Thanks so much.

    ITKE347,520 pointsBadges:
  • How can I secure my database password using PHP?

    I'm using a PHP application for my database so obviously I need to pass a login / password to make a database connection. And I'm using a minimum-permission login for the application so PHP needs to know those credentials somewhere. Is that the best way to secure my password? I'm just worried that...

    ITKE347,520 pointsBadges:
  • Moving a Redis database from one server to another

    We have a Redis server that's running on a cloud instance but now we're trying to migrate it to a new cloud instance (and actually use it as our new Redis server). I know in MySQL that I would just need to export the database and import it to the new server. But how can we do this through Redis?...

    ITKE347,520 pointsBadges:
  • What’s the difference between horizontally and vertically scaling a database?

    I'm working with two different databases (NoSQL and MySQL) and we're looking to measure the scalability of each database. What's the difference between vertically and horizontally scaling each one? I would appreciate any help.

    ITKE347,520 pointsBadges:
  • How can I get the database username and password in Ruby on Rails?

    I'm currently using Ruby on Rails but I'm looking to do some outside database work. Is there an actual way to get my database info (username, password, host, etc.) for the current environment? I'm trying to get it so I can connect like this: con = Mysql.real_connect("host", "user", "pw",...

    ITKE347,520 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