MySQL Database Forum

Hi, Although I'm gradually getting the hang of working with MySql, can do a pretty mean query!! I realise I know nowt about security. Is security basically done outside MySQL ie with https:// and is it necessary/usual to have the database itself on a https server or just the code accessing it? Is there any level of security that can actually...

Hi All, Last night I upgraded my MySQL install from 4.0.20 to 4.1.7. All seemed to go well -- i stopped and removed the 4.0.20 service. Installed 4.1.7. Then copied my MYD etc files from the data directory of my 4.0.20 installation to the new installation and can now use the mysql client to access the data in my dbs and tables. However,...

Well.... just wanted to know if the people at the MySQL.org site ever look at the posts in this group. If they do, they can possibly us a little constructive criticism from a slightly irritated customer. Seems to me that if someone installs Redhat 9 with MySQL from the original CD source which is version 3.23.54a and then follows the...

I'm an independent contractor in Toronto and happened across this web site www.itgta.com. Does anyone out there know who they are and if they are for real? It sounds like a good idea. Does anybody have any information about them or know of someone who registered with them? ....Thorton

hi, please correct my terminology if it is incorrect but i am trying to create a number of tables by writing an sql script/batch file and using the command: mysql -D myDB -u myname --password=myPass < scriptname.sql > err.sql 2>&1 and i am getting errors. the book i am using doesnt seem to cover this topic well but i think i must be...

I have a table with 3 colums: Date (datetime) End (datetime) Sys_id (INT) What I need to do is write a query that will do a calculation and return the diffrence in hours between date and end. I though that maybe a DATE_SUB would work but I can't seem to get it to do as I want. Hope someone can help.

I have a database that keeps records on the issue and failure of an item. Currently, the database is poorly desisned; therefore I'm performing queries to break the data into normalized tables and attempting to perform a "left join" query to build a cross-reference table. The left join query is currently taking nearly 2 hours for MySQL to...

Have two tables "abc" and "xyz", where "xyz" is a superset, column-wise, of "abc". Is there any simple way to inject all the rows of "abc" into "xyz"? Tried "insert into xyz select * from abc" but got a complaint of "column count doesn't match value count at row 1", which of course is true. Any way to tell SQL to simply set defaults for...

Hi, I was wandering. Does the query speed also depend on the colums that you don't use in the query (so not in the where and not in the select part). I have a lange unused backup field in every row. I only put the backup information into that field once. But never use it on my live database.

mySQL 4.0.20a WIN32 Need help with backslash syntax/like queries.. Query1: select * from dbtable1 where Filespec like 'http://www.10291.com/%' returns : http://www.10921.com/sikhnet/register.nsf/ram/radioG2/\$File Query2: select * from dbtable1 where Filespec

Has anyone used MySQL in a public web site environment that receives 1 - 1.5 million sessions/day? Sessions are mostly content and light commerce. Site spikes to 3 million sessions/day about 4 times/year. Trying to find a good example of MySQL holding up under this kind of load. Thanks!

Hi All I understand that the basic principles to create a TCP/IP backup program for a remote MySQL DB are: a) Query/retrieve the schema. b) Query/retrieve each table and create inserts for each row of data.

My mysql (mysqld) processes were 10M each 4 days ago. Now, each process is 74M! How is that? How can I stop it? Server is 1.3 Celeron 1G RAM RHEL Unix

This is a newbie question. I have installed MySQL 4.1.7-Standard in MacOS X (10.3.5). I have ONLY database test. According to the manual there should be TWO. test and mysql. I have re-run mysql_install_db several times with the same result. Can some mysql guru explain or point me to the right page to have this mysql database in my system? ...

I am trying to reinstall MySQL on a Win XP pro box. After uninstalling MySQL 3.x, a 'MySQL' service is left in the list of services. I can't figure out how to delete it, and installation of MySQL 4.1 fails during configuration. The old service may not be the problem, but can anyone suggest how to get rid of it? Thanks.

Hi, I want to get my images from my MS-SQL server and put them in my MySQL server or generate them at filelever. It must be fully automated via an interface. How can i acomplish this?

Is there a mysql version for Montavista/PPC44gx? If not how hard will it be to port to that target? Thanks in advance, Konda

Hi all, I'm working on a project in which we use MySQL as a database and i've come across something i find strange but which me be completely correct. When i type SELECT "\c"; the mysql returns c instead of \c, why does mysql manipulate the data I put into it??? Normaly you would expect mysql to just take the data and store it, because with...

Hi all, I am using mysql C API in my C++ project. I am using mysql-4.1.4-gamma and gcc 3.2.2. Problem with this code is that when add_data(i) is called second time SEGMENTATION FAULT occurs at mysql_real_query(). First time it executes the add_data() function successfully.

1) I have mySQL 3.23 installed. I have a record with two date/times fields in YYYY-MM-DD HH:MM:SS format. How do I find the difference between those two date/times? (I would also like to know it with seconds left off.) 2) Let's say I have two records each with a date/time field in YYYY-MM-DD HH:MM:SS format. How do I find the difference in...

Have two tables "abc" and "xyz", where "xyz" is a superset, column-wise, of "abc". Is there any simple way to inject all the rows of "abc" into "xyz"? Tried "insert into xyz select * from abc" but got a complaint of "column count doesn't match value count at row 1", which of course is true. Any way to tell SQL to simply set defaults for...

I have an sql statement to setup a few tables and it runs in mySQLcontrol and even PHPMyAdmin, but it fails to run when starting it in php. The error I get is "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '" it then lists part of the begining of the...

I'm wondering if there is a way to retrieve Foreign Key declaration information on both MyISAM and InnoDB tables. Of course, I understand that MyISAM doesn't support Foreign Keys, however, it does still parse FK declarations within a CREATE TABLE statement, and moreover, it even creates an index on the column that is the Foreign Key. So...

I can't get the WHILE statement to work in MySQL. The version of MySQL that I am using is: Ver 12.16 Distrib 4.0.6-gamma, for Win95/Win98 (i32) running on Windows MX. Here is the relevant section from the manual: 20.1.9.7 WHILE Statement

Hi all, The database farm I've set up works great as a single master and two slaves, provided nothing unusual happens to the master machine ... it seems that if logrotate kicks in or the machine reboots, that the mydbhost.001 file in /var/lib/mysql/ increments to 002, 003, etc., but the slaves never update /var/lib/mysql/master.info to...