• Issues connecting to MySQL database server

    I'm having an issue with connecting to my database server (This is in MySQL). I'm looking to query my database in MySQL workbench and I keep getting this error message: Cannot Connect to Database Server Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306:Can't...

    ITKE983,175 pointsBadges:
  • Database error message when deleting it from MySQL

    I'm having a ton of trouble deleting a database from MySQL. Here's the error I keep getting every time I try: ERROR 1010 (HY000): Error dropping database (can't rmdir '.\oro', errno: 41) So I'm not sure what to do here. I tried to using phpmyadmin but I'm getting the same error.

    ITKE983,175 pointsBadges:
  • Web project setup

    I am new the Linux servers but will be using CentOS servers. I have a web application that was created in Java using a NoSQL database. This application will give users the ability to create there own drag and drop web sites. Very similar to , Web.com, wixs.com, suarespace.com and weekly.com. We...

    sstepky60 pointsBadges:
  • Access client’s WordPress database

    I scanned my customer's site for vulnerability in his site and I found the WP-CONFIG backup which contains all info about the site and database username and password. So how can I access my client's database using that username and password?

    mrchat5 pointsBadges:
  • How to do a full outer JOIN in MySQL

    I'm fairly new to MySQL but I'm wondering if I could do a full outer Join in it? Does anyone know if that's possible? Is it actually supported?

    ITKE983,175 pointsBadges:
  • MySQL or PostgreSQL for block storage volume

    I was wondering if I could have 2 VP MySQL servers and one SQL database located on a block storage volume. Then I can mount the same volume on both servers reading and writing to a singe database so I can have two VP MySQL machines access and running one database. Thanks

    sstepky60 pointsBadges:
  • MySQL 1093 error message

    In MySQL database, I have a table that have corrupt entries. Here's the query that returns the entries: SELECT * FROM story_category WHERE category_id NOT IN ( SELECT DISTINCT category.id FROM category INNER JOIN story_category ON category_id=category.id); So, here's how I tried to delete them:...

    ITKE983,175 pointsBadges:
  • MySQL server syntax error

    I have this SQL query below: INSERT INTO user_details (username, location, key) VALUES ('Tim', 'Florida', 42) But it keeps saying I have a Syntax error - it relates to the MySQL server version for the right syntax. What should I do?

    ITKE983,175 pointsBadges:
  • How to reorder MySQL auto increment primary key

    I'm using MySQL and in my table, I have an auto increment primary keys. I already deleted several rows in the middle of the table. Now, I need to reorder the keys but I'm not sure how to do it. Can someone help me?

    ITKE983,175 pointsBadges:
  • Which tool is preferable to test and evaluate the MySQL and MongoDB databases?

    I have developed a small case study online application using Hibernate that can communicate with both MySQL and MongoDB database. Now I need to test the performance of both the databases against each other by supplying a large dummy test data to the developed application on various scenarios such...

    gunasingh105 pointsBadges:
  • Removing MySQL rows from a table using SQL Query

    In MySQL, I have a table that currently holds the following topics: id url title company site_id So I have to go in and remove the rows that have the same title, company and Site_ID. Can this be done using a SQL Query? Thank you!

    ITKE983,175 pointsBadges:
  • How do I connect to a MySQL database in Java?

    I apologize if this is a simple question but can anyone help me with connecting to a MySQL database in Java? Thanks so much!

    ITKE983,175 pointsBadges:
  • MySQL: Threads showing in freeing items state

    I've been running SHOW PROCESSLIST in MySQL and there are a bunch of threads in the 'freeing items' state. A friend of mine told me that this is because of the query cache. But mine is set to zero so it should be disabled. What's happening here? Thanks!

    ITKE983,175 pointsBadges:
  • Export / import database in MySQL using command line

    Can I import / export my database in MySQL using the command line? I already have MySQL system configured and WampServer is installed. Thank you so much.

    ITKE983,175 pointsBadges:
  • Monitor progress of SQL file

    I'm trying to import a pretty large SQL file (roughly 6 GB) to my local database. Here's what I'm using: $ mysql -h localhost -u root 'my_data' < foobar.sql $ mysql --version /usr/local/mysql/bin/mysql Ver 14.12 Distrib 5.0.96, for apple-darwin9.8.0 (i386) using readline 5.1 So, I'm wondering if...

    ITKE983,175 pointsBadges:
  • Moving MySQL database to another server

    We have a MySQL server that is using a InnoDB table and the size is right about 30GB or so. Now, we actually need to move to our new server. How can we go about doing this?

    ITKE983,175 pointsBadges:
  • Disable replication on MySQL database

    For the past month of so, I've been running dual master MySQL replication but now I need to move to just one database that doesn't have a replication. Is there a way to completely disable replication on each database? Thank you

    ITKE983,175 pointsBadges:
  • Can I mysqldump specific tables in my database?

    In MySQL, is there a way I can dump a specific table / tables without including the remaining database tables? I would appreciate the help.

    ITKE983,175 pointsBadges:
  • MySQL: Reduce size of ibdata

    We have several production servers that have IBDATA files. These files are increasing daily. Actually, it's almost taken up 300 GB in space. The tables in the servers are InnoDB (most are read and write requests). Also, log file size is going up too. So basically, data continues to rise. Is there a...

    ITKE983,175 pointsBadges:
  • How to install Apache with MySQL and PHP on Linux CentOS?

    Hello, How can I install Apache with MySQL and PHP on Linux CentOS? Thank you!

    isophiawilson155 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