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

    ITKE977,835 pointsBadges:
  • Cannot store data in MySQL database using Python

    I've been trying to store my data into a MySQL database using Python but I keep getting this odd error message: mysql.connector.errors.ProgrammingError: Failed processing format-parameters; Python 'list' cannot be converted to a MySQL type What does this mean? And how can I fix it?

    ITKE977,835 pointsBadges:
  • Network is not connecting to MySQL database

    I'm sorry for the confusion but I'm having a networking / MySQL issue. Our software works with Visual Basic and uses a MySQL database. Our app works in our local network but one person is running into an issue. Whenever he does something in the app, MySQL is taking way to long to search. Sometimes,...

    ITKE977,835 pointsBadges:
  • What to burn in CD during the connection with database

    What do I burn in a CD during the connection with a database? Is it necessary to install software too?

    85580972785 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

    ITKE977,835 pointsBadges:
  • Connect to MySQL on different machines

    I recently installed MySQL on a Windows Server on our domain. But we're having issues connecting to it from our other machines on the domain. I just opened the MySQL administrator panel to change the connection but it's still not recognized. What should we do?

    ITKE977,835 pointsBadges:
  • Fix MySQL error 2003: Can’t connect to server

    On MySQL, I keep getting this error message: Error 2003 - Can't connect to MySQL server on 'server name'. Has anyone gotten this before? If so, how do I fix it?

    ITKE977,835 pointsBadges:
  • MySQL features and benefits

    What are the features and benefits of MySQL?

    sweetpeajd120 pointsBadges:
  • Connect DBI to MySQL database without password

    In DBI, I'm trying to connect to our MySQL database as a user without a password. Is that possible? Basically - I just want to grant access to myself without having to put in a password.

    ITKE977,835 pointsBadges:
  • Check dropped MySQL database connections

    One of our clients uses PHP to connect to MySQL. Now, for security reasons, both the PHP scripts / MySQL DB are on two different Linux servers. Now, they're saying that the database connections keep dropping out / timed out. Is there a way to see in MySQL if that's true? We already checked the...

    ITKE977,835 pointsBadges:
  • Uploading CSV file data into MySQL database automatically

    Would I be able to upload my data, that's in a CSV file, into a MySQL database automatically? I need this because the database has to get updated from a path folder. Can anyone help?

    ITKE977,835 pointsBadges:
  • Connecting MySQL database to another computer

    I recently created a MySQL database and it's using localhost as the host. Now I need a co-worker to do some testing but I'm not sure how we can connect to it from another machine. This is also on Windows 7.

    ITKE977,835 pointsBadges:
  • Connect Android application to MySQL Server

    I recently created an Android application and I'm trying to connect it to my MySQL server. Is there a way to do that? Someone told me to use JDBC - should I go that route? Thank you very much.

    ITKE977,835 pointsBadges:
  • How to find MySQL username

    I need to figure out what my MySQL username is. Whenever I'm using the command line client, all it asks for is my password. That's it. And I can't remember it at all. Can anyone help me out?

    ITKE977,835 pointsBadges:
  • Import Microsoft Access database into MySQL

    I'm currently on a Windows machine with a Microsoft Access database. I need to import that into MySQL on another Linux web server. Here's what I'm doing right now: Exported as text file Copied with FTP Loaded into MySQL Is there a better process for this? Any help would be appreciated.

    ITKE977,835 pointsBadges:
  • How to check if a table exists in MySQL server

    Hi, To connect to my MySQL server, I've been using an ODBC connection. Is there a way to check if a table exists in my database? And if it's not there, how can I create one?

    ITKE977,835 pointsBadges:
  • How can I escape all CRLF chars in all column values when doing a select?

    Let's say I want to do: SELECT * FROM tableName But some columns' values have linebreaks, so in my MySQL console it breaks the formatting of the table. I know I can circumvent this by explicitly REPLACE()ing CLRF chars, but this requires me naming each column and is not very quick to type out, eg.:...

    hazzlewis5 pointsBadges:
  • Storing PDF files in MySQL as BLOBs

    Experts, Can you please help me? I need to store several PDF files into MySQL as BLOBs. How can I do that using PHP? You are the best!

    ITKE977,835 pointsBadges:
  • How can I load CSV files into MySQL Workbench?

    I have several CSV files that need to be added into my database in MySQL Workbench. Is there a way to load them in? Is there a specific command I should use? Any help is appreciated.

    ITKE977,835 pointsBadges:
  • Is MySQL table supports both foreign keys and partitions?

    I have one table like employee (emp_no,emp_name,dept_id). This table contains the foreign key relation with deportment table (dept_id). Now I want to do partition on emp_no field in employee table. Is it possible or not?

    lakshmilogica15 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