• MySQL database export using Command Prompt

    I have a pretty large MySQL database and I need to export it ASAP. Can I use the Command Prompt to do this? Or is there another way?

    ITKE434,585 pointsBadges:
  • What data type should I use for storing currency values in MySQL?

    I'm using MySQL and I'm wondering what's the best data type if I want to store currency values in it. Is there a certain command?

    ITKE434,585 pointsBadges:
  • See indexes on MySQL database

    Specifically for MySQL, can I see if my database has any indexes? If not the database, can I see on a particular table? Appreciate the help.

    ITKE434,585 pointsBadges:
  • Select all MySQL columns except for one

    Is there a statement in MySQL that would select all of my columns (except for one specific column) in a table? Please note that there's roughly 50 columns in total. Thanks for the help!

    ITKE434,585 pointsBadges:
  • Trace MySQL queries on Linux server

    I'm using my Linux server and I was hoping there's a way to trace all of my live MySQL queries. Is that possible? I have a listener set up already (if that helps).

    ITKE434,585 pointsBadges:
  • Show last MySQL queries on servers

    How can I show the last queries executed on all of my servers in MySQL? Is there a specific query to do this?

    ITKE434,585 pointsBadges:
  • Replace MySQL word string

    For MySQL, I currently have a column that contains URLs. In the URLs, I need to change a word - from update to news. How can I do that? Using a script?

    ITKE434,585 pointsBadges:
  • 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.

    ITKE434,585 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...

    ITKE434,585 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.

    ITKE434,585 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?

    ITKE434,585 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:...

    ITKE434,585 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