Export/Import database with large blobs in MySQL
Hi, we are having trouble exporting and importing databases with blobs in mysql. We have a development environment and a production environment both running mysql-5.0.45 and want to dump databases with blobs from one to the other. We have tried with many options but nothing works. When importing the databases mysql partially imports data and [...]

Answer Question   |  March 18, 2013  6:59 PM
blobs, Database, MySQL, mysql import, mysqldump

Which config file does MySQL use?
Hi, I’m having trouble with MySQL. My OS is IBMi V7R1. We are using MySQL 5.0.45 with zend server 5.6.0. The problem is that the MySQL server works fine in qp2term(shell) but ends immediately after start with zend server. Also, when I check the defaults config file for MySQL I get this message: Default options [...]

Answer Question   |  March 5, 2013  2:55 PM
MySQL, MySQL 5.0, Zend, Zend Server

Problem to storing records at SAP DB from MySQL
I’m using JCO for connecting SAP through jsp-Servlet. I want to store all MySQL Records to SAP DB. What will I Do?

Answer Question   |  September 17, 2012  6:45 AM
MySQL, SAP

GROUP BY mysql
Hi I have started working with a mySQL databse. I need a query that will either make use of “DISTINCT” or “GROUP BY” but that selectes the record that has the highest ‘VersionNumber’ Can anybody suggest how I would achieve this? Thanks in advance.

Answer Question   |  June 22, 2012  8:10 AM
MySQL, MySQL Database, MySQL query

Pass table name to procedure including fields
I want to do the following with a procedure: I have per user that has the same structure. The only difference is the table name. I need to be able to pass the table name to a procedure and retrieve data for that table. At the moment I have this: sp_getdata(id, givendate datetime,tablename varchar(200)) BEGIN [...]

Answer Question   |  May 16, 2012  5:55 AM
MySQL, MySQL Database

Get MYSQL data on iSeries
Datas are on a Linux server = mysql database and I want to transfert some datas to a DB2 database on iseries. At this time, I go throw Excel but sure we can do better !!…

Answer Question   |  May 14, 2012  8:10 AM
AS400 iseries, Linux, MySQL

SQL TAGS
Why am failling when am using mysql to create database and am using the exactly tags?

Answer Question   |  May 27, 2012  6:54 AM
MySQL, MySQL Database

Creating Views in MYSQL via Sysdate
Hello Guys, I can create simple views for MYSQL Database tables but I am unsure on how to create a view for the following requirement: I want to create a view which restricts staff user access to a specific table between working hours of 13:00 – 14:00. I have been told that this can be [...]

Answer Question   |  March 27, 2012  8:58 PM
MySQL, MySQL Database, Oracle

Java CSV reader (+charts)
Hello there, I’m trying to create a Java web application which will do the following: -upload .CSV files -store them in a database -will display charts depending on the content of the .CSV file Any ideas? It HAS to be in JAVA! Thanks in advance, Peter

Answer Question   |  May 15, 2013  12:03 AM
.CSV files, Eclipse, Java, MySQL

vb.net development environment
I am coming out of retirement and have a couple of projects I was going to do in VB6. After doing a little research it became clear that I needed to migrate my development environment from VB6/sp6 to VB.Net. My question is very basic,, what do I need to start VB.Net development? I do not [...]

Answer Question   |  February 28, 2012  2:53 PM
MySQL, Visual Basic 6, Visual Studio 2010

Question on Database Development Options
Our organization is going to build a database program where there will be millions of entries. Data entry will be done from around the country. The central server will be located in the capital city. Presently we use Windows OS, planning to migrate to Linux OS in next 4-5 years. I’d like to know the [...]

Answer Question   |  March 7, 2012  7:02 PM
Database, MySQL, SQL

MYSQL database high availability
I have cent os based LAMP system. My question is that, what is the best way to make mysql database high availability. As per me database clustering is a good option can you please suggest me.

Answer Question   |  March 31, 2012  8:45 AM
CentOS, LAMP, MySQL, MySQL Database, MySQL functions

A question about system integration testing
I have two development teams looking at integrating testers / test developers from traditional QA team. How should we best handle system wide integration testing that would include devices, firmware, and web software? Most books are written for software only teams. Our integration and regression testing touches hardware, firmware, and software.

Answer Question   |  March 31, 2012  8:04 PM
Integration testing, Java applications, MySQL, System integration testing

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 (like this one) — 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 [...]

Answer Question   |  March 31, 2012  3:54 PM
Database security, MySQL, MySQL Database, SQL Database Security

MySQL Replication I think!
Hi, I have a local Access Database that is the management system for a business. They now want to take some feature online so customers can do some functions themselves. What I am thinking is migrate the data to MySQL and use a local install of MySQL as the backend and point the Access front [...]

Answer Question   |  May 5, 2011  8:35 PM
Access Database, MySQL, MySQL Replication, MySQL Restore

Adding a MySQL user when no MySQL users have admin rights?
I’m working on a MySQL installation that has a user already created (“admin”), but that user doesn’t have a password, and doesn’t have any permissions, so I can’t create new users or even reset the password of that user. I’m using Ubuntu Server, and after looking through the help files I still can’t find a [...]

Answer Question   |  April 28, 2011  6:33 PM
Database administration, MySQL, SQL, Ubuntu

MySql Select multiple columnsfrom distinct rows based on one column
I am building one sql query based on 5 select statements unioned all together. Each select is built as a variable with where clauses based on filters selected by the users. All 5 selects are concatenated together to build the one dynamic query. The one select below needs to be changed to select rows only [...]

Answer Question   |  March 28, 2011  6:35 PM
iSeries V6R1, MySQL, SQL statements, V6R1

What wiki software do you recommend?
Just as the title suggests, what wiki software (DokuWiki, MediaWiki, etc…) do you suggest to run?  The purpose of this is nothing more than to make a remote note-taking sort of scenario, so it’s not something for anyone but me to be used.  I know I could do my own thing and stuff, but I’d [...]

Answer Question   |  March 19, 2011  3:02 AM
Linux, MongoDB, MySQL, MySQL 5.0, PHP, Wikis

Web development course and Microsoft qualifications
I recently left my job in the UK as a project manager from a niche organisation that provides business services to public service bodies. I am thinking of sharpening my skills by doing some web development training and getting certified with some Microsoft and Adobe products and moving into Web Development project management. I have [...]

Answer Question   |  March 1, 2011  12:04 PM
Apache, Flash CS5, HTML, java script, Linux, MySQL, PHP, Project Management Methodology, SQL Server 2008, Visual Studio 2010, Web development

How to import simple spreadsheet into mysql database?
I have a simple spreadsheet (only 2 columns) that I need imported into a mysql database. I can convert the spreadsheet into whatever format I need to (comma delimited), but I need the mysql commands that will import it. Does anybody know how to do this?

Answer Question   |  February 12, 2011  2:49 AM
Linux databases, MySQL, MySQL Community Edition, MySQL Database