• How to find all occurrences of a URL in a MySQL database

    A friend of mine has been having trouble dealing with his MySQL database. He's been trying to locate all occurrences of a URL in the database but he doesn't know where to start. He wants to search all of the tables / fields. Appreciate the help.

    ITKE347,750 pointsBadges:
  • How can we check if a MySQL database exists?

    Can anyone tell me if it's possible to check if our MySQL database exists after we've made a connection? We already know how to check if a table exists in our database but now we need to see if the actual database exists. Thanks!

    ITKE347,750 pointsBadges:
  • Deleting and creating databases in Neo4j

    Would it be possible to delete / create several databases in Neo4j (like MySQL)? If I can't do that, would I be able to delete all the nodes / relationships of an existing graph so I can get a clean setup for testing? Thanks so much.

    ITKE347,750 pointsBadges:
  • How to duplicate MySQL database

    Would it be possible for me to duplicate my entire MySQL database on a Linux server? I already know I can export / import but the database has over 25 MB so it's not the best solution. Can I use "MySQLdump" or just directly duplicate the database files?

    ITKE347,750 pointsBadges:
  • Visual Basic app with MySQL .NET connector

    I built a VB app that uses MySQL connector for .NET. Do all of the users need the connector on their computer?

    yotam1805 pointsBadges:
  • Increase character limit in custom fields beyond 250

    We are a nonprofit that has OrangeHRM installed on a Servint VPS. We are running a standard Apache, PHP, MySQL stack and the web application is running well. We have an odd issue in that any custom fields are limited to only 250 characters. We have increased the character limit for custom fields...

    GOSCIENCE5 pointsBadges:
  • Security issues for MySQL in a cloud environment?

    Hi everyone! In general, I've been asked by my manager to find out about running a MySQL DB on a cloud -- has anyone done this, and what do you think are the security issues that can come up when doing so? More specifically, IT has questioned me about how auditing would work on a cloud, and what...

    MillyT5 pointsBadges:
  • MySQL Stored Procedures with Parameters in Crystal Reports 9?

    Hi, I'm using Crystal Reports 9 and the MySQL 5 DBMS. I have a stored procedure which accepts a parameter, Crystal Reports won't accept this stored procedure and cites 'Incorrect Number of Arguments; expected 1, got 0'. Im pretty new to MySQL and perhaps I shouldn't be creating stored procs the way...

    Les za30 pointsBadges:
  • What’s the best SQL Query Formatter tool?

    Hi experts, Is there any free SQL query formatter tool? I am using this free SQL Query Formatter Tool for small queries. It is very good tool. But I can not customize everything what I would like, like fonts and colours. Is there any other good free tool?

    sulica235 pointsBadges:
  • Performance management of databases

    Which tools do you use for database performance management? Does someone used enteros solution for managing performance of MySQL. and PostgreSQL? Please let me know if someone used Enteros Upbeat High Load Capture.

    Saeed54435 pointsBadges:
  • Should I use MEDIUMBLOB to store large files in MySQL database?

    I need to store user uploaded files to our database (and I can't use a file system). The files are all different types and I'm running into a problem deciding if I should use "MEDIUMBLOB" to store these as binary data. And this problem arises from the files having various file sizes. I understand I...

    ITKE347,750 pointsBadges:
  • How can I store large hashes in MySQL?

    I'm trying to store a bunch of 512-bit SHA-2 hashes into a MySQL table. In an effort to save space, I'm looking to store them in binary form, instead of a string of hex digits. I'm also using ORM so this will inflate them to any object / structure I choose. I know I could split them up using eight...

    ITKE347,750 pointsBadges:
  • MySQL: What’s the downside of storing images in the database?

    I'm looking at using MySQL for my database so I need some opinions on the disadvantages of storing images inside of it. Is it not as efficient as storing images on a server? Does it take longer for the images to download vs. disk storage? Thanks for all the input!

    ITKE347,750 pointsBadges:
  • How should I store large files in a MySQL database?

    We have a PHP script that we upload large files with (up to 500MB) and it's stored in a MySQL database. Here's the code we're using: mysql_query("INSERT INTO table VALUES('')"); $uploadedfile = fopen($_FILES['file']['tmp_name'], 'rb'); while (!feof($uploadedfile)) { $line =...

    ITKE347,750 pointsBadges:
  • What factors are there for MySQL database size estimation?

    We have an application database (which includes a table for users). Here's the setup: 1Kbyte of data per user that's based on counting fields * typelength and about 100 things of the same size that belongs to a user (about 0.5 Kbyte). This leads to around 51 Kbytes of data per user. Now, we're...

    ITKE347,750 pointsBadges:
  • What’s the best option for storing graphs in persistent storage?

    I'm wondering what would be the best way for me to store my graphs in persistent storage (for analysis, search, clustering, etc.). I'm considering NEO4J but I'm looking what other options are available to me. Would Cassandra or MySQL work for me? Thanks for the help.

    ITKE347,750 pointsBadges:
  • How can I determine by database size in MySQL?

    Does anyone know if there's a specific query or function that can determine the size of my database in MySQL? If there isn't one, what's the best way to go about it? I tried this and it came up with 474989023196466.25 MB (even though I know the database is 400 MB). SELECT...

    ITKE347,750 pointsBadges:
  • What’s the best network connection?

    Hello! I have and old client-server application written in Visual Basic 6. My database is MySQL 4.0. It has 10 concurrent clients under the same LAN. I need to make a new android application to run on tablets. The new app must connect via Mobile Internet to my old client-server application (or...

    Vfafou10 pointsBadges:
  • Database Migration code in MySQL

    Code to migrate database in MySQL (tables, triggers, stored procedures, functions and views) to Oracle, MS Access & vice versa.

    akashi5 pointsBadges:
  • How can I pass tablename as a parameter in MySQL stored procedure?

    my SQL stored procedure is like this.... ALTER PROCEDURE [dbo].[Sp_InsertDataMaster] @_ImageID int, @_Stat bit, @_tablename nvarchar(200) AS begin declare @strTemp nvarchar(max) set @strTemp = 'Insert into ' + @_tablename + '(ImageID,Status) values ('+ convert(nvarchar(5),@_ImageID) +','+...

    Minal45 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