• Is it possible to restore MySQL database from FRM MYI and MYD files only?

    I accidentally deleted  my database while testing mysql work bench. As its a relatively new DB on a new server, I had no back up running. Luckily I can see some FRM, MYI and MYD files. Afaik I had both innodb and Myisam tables and some stored procs. So is there any chance at all recovering the DB...

    FrankKelly5 pointsBadges:
  • How to use Data Replication features with using MySQL Replication

    How can I use Data Replication features with using MySQL Replication?

    Rahul235 pointsBadges:
  • How to implement middleware?

    We are building Android Mobile application and a server web application in PHP and Database in MySQL. We are going to host it online and release the app in Google store, since the number of users using the app is less at the begging, I’m confident that our client server model of implementation...

    vatsa133120 pointsBadges:
  • Free online practice exercises on SQL/Oracle

    I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti

    Kpatel0 pointsBadges:
  • Store MySQL query in Microsoft Excel

    I have a MySQL query and I need to store it in Excel. Here's the query I have: SELECT * FROM document WHERE documentid IN (SELECT * FROM TaskResult WHERE taskResult = 2429) How can I go about doing this? Thank you very much.

    ITKE407,405 pointsBadges:
  • How do I get to my MySQL server?

    I'm just learning "MySQL," and I understand that you have a server that I can use to practice with. Where is this server, and how do I get to it?

    kevbeard5 pointsBadges:
  • 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...

    ITKE407,405 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.

    ITKE407,405 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?

    ITKE407,405 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:...

    ITKE407,405 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?

    ITKE407,405 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?

    ITKE407,405 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!

    ITKE407,405 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!

    ITKE407,405 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!

    ITKE407,405 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.

    ITKE407,405 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