• Oracle vs Mysql, how they implement concepts of database.

    I am confused between oracle and mysql how they implement databases philosophy. In oracle is user means database and in mysql why do we have only root password unlike oracle. Is database more secure in oracle compared to MySQL.

    Tech2rp15 pointsBadges:
  • Delete duplicate records in MySQL database

    One of our clients asked us to delete duplicate records in a SQL Server database and a MySQL database. We did it in SQL but MySQL is giving us issues. It says the format of the query is not correct. Does anyone know of a way to do this? Thank you so much!D

    ITKE1,101,740 pointsBadges:
  • Export image in the MySQL database through Excel?

    How can I export image in the MySQL database going to Excel? Please help.

    bituinseverino5 pointsBadges:
  • MySQL fails to install on Windows 10 PC

    Hi everyone, I'm trying to install MySQL on my Windows 10 PC. During the installation, I keep getting this error. It shows internal error - configuration system failed to initialize. What does that mean? What can I do to fix this? The installer goes every single time.

    ITKE1,101,740 pointsBadges:
  • On-Site Server for Small Business

    I'm looking to purchase a server but the quote's I'm getting from some local IT companies are astonishingly high, I understand that its business, but at the same time its not going to be anything crazy happening. So I was planning on getting a server off newegg or someplace but just trying to...

    mynameisjae5 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?

    ITKE1,101,740 pointsBadges:
  • MySQL database

    I want to create a matric number of student. I declare a matric unique and type varchar but when I put these matric number uil/ibs2015/0165 and uil/ibs2015/0166, it displays an error as duplicate matric number.

    Admin99635 pointsBadges:
  • MySQL server will not startup on Windows 10 machine

    For some reason, MySQL Server will not startup on my Windows 10 machine. It worked the last time I used it (roughly two weeks ago). I don't have any other processes running and I tried to use different ports but that didn't work. Any suggestions here would be awesome.

    ITKE1,101,740 pointsBadges:
  • Where can I find the SQL file after MySQL dump?

    After successful connection using SSH and entering right login credentials, I'm not able to find out the backup SQL file. Any help would be really appreciated.

    AjitK292,545 pointsBadges:
  • Stop Apache and MySQL from automatically starting up in Ubuntu

    For Ubuntu, I don't need Apache and MySQL to run automatically when I startup. When I boot up, they automatically startup. How can I stop this from happening?:

    ITKE1,101,740 pointsBadges:
  • MySQL Database: Tables for web application

    Can you help me find how many tables do I need for a web application that is going to be used for runners where they can log in and get their number for the run and print it out

    el334415 pointsBadges:
  • Backup MySQL database using CMD

    I'm trying to backup my MySQL database with this command: mysqldump -u root -p db_name > path to store It brings me to the password prompt. I add in my password but then it brings me right back to CMD. Why does this keep happening.

    ITKE1,101,740 pointsBadges:
  • Change the position of auto increment primary key in MySQL accordingly to Drag and drop in UI

    Is it possible to change the position of auto increment primary key in MySQL accordingly to Drag and drop in UI?

    Uday1235 pointsBadges:
  • Cannot connect to MySQL: Database server error message

    Over the past year, I've always used MySQL Workbench to my MySQL (using TCP/IP and SSH). I've never had an issue. But, all of a sudden, I keep getting this error message: Cannot connect to database server. I haven't made any recent changes. Why is this happening to me??

    ITKE1,101,740 pointsBadges:
  • How will you test and approve MySQL tables to Elastic Search

    In our e-commerce company, the DevOps engineer were facing a lot of trouble managing certain tables in MySQL namely logs_users, logs_actions which store logs of each visitor who comes to their e-commerce store. In an year's time the table size grew to 70GB. We hired a senior DevOps and when he...

    sarthak3130 pointsBadges:
  • Cannot install MySQL on Windows 7

    I've been trying to install MySQL on Windows 7. I'm getting to the reconfigure window, followed by the types and networking dialog page. But then the entire installation stops. I can't click the next button. What can I do?

    ITKE1,101,740 pointsBadges:
  • Remove MySQL from Windows 10 machine

    I'm leaving my job so I'm trying to remove all of the MySQL programs from my Windows 10 machine. But it still says I have a ton of services active. How can I remove everything? I tried sc delete MySQL but with no success. Can anyone help?

    ITKE1,101,740 pointsBadges:
  • Where to find the socket file in MySQL

    After a change of machines, I had to reinstall MySQL but I'm having a big issue. It keeps telling me that it can't find the socket. I can't either to be honest. This is on a Mac too. Where can I find the socket file? Thanks so much

    ITKE1,101,740 pointsBadges:
  • SQL: Find the column name

    I don't know the column name and table name. What I know is there is a column in database that stores weights of products.

    syslkiranmai5 pointsBadges:
  • Storing MySQL database in-memory

    Hello, Does anyone happen to know if it's possible for me to store a MySQL database in-memory? Do I have to create some specific query for this? My thinking is that this would speed up updates and inserts. Thank you very much.

    ITKE1,101,740 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