MySQL Database Forum

Hi, Is there a piece of open source software that will run on win98 that will document a database graphically. Something like DBDesigner 4, but for after the fact. -- God Bless you, Al Kolff "There is a God we want, and there is a God who is. They are not the same

Hi I have made several website using MS Access and asp. Now I need to upgrade from Accesss to MYSQL - I got my website working with MYSQL on my local PC - but now the problem is how I get it working on my webhost . I have the right connecting string ( according to webhotels supporter) but how do I transfer my SQL database from local pc to...

Trying to install MySql 4.1 to our Linux server that already has version 4 installed. I created a my.cnf file and set the following params: datadir = /usr/local/mysql-4.1/data/ port = 3304 socket = /var/run/mysql4.1/mysql4.1.sock pid-file = /var/run/mysql4.1/mysql4.1.pid log =...

Friends, We have created a good web site for various resources related to the process of knowledge discovery in data. The site is in its early stages right now, however we expect it to mature over next few months. Please visit us at http://www.eruditionhome.com/datamining Hopefully, this site will serve as a good resource for you....

Is it possible to restore a mysql server if all that you have is the data files. This database uses innodb tables.

mailing.database.mysql - I'm trying to update a "parent" table with the sum of data in a "child table". To illustrate, let's say our database was modeled around a book: book -> chapter -> page -> attachment (pictures)

Hello, I'm a starter on the MySQL area, I have MS SQL Server experience. I want to create a web application for showing logged information. It concerns logged vehicle information. The system should be available for several customers looking at their own vehicles. Is MySQL suitable to perform this task?

In mysql 4.1, there are new ways to save different index files into different key_cache segments. The idea is to remove problems with key_cache locking if another process is accessing it. As this involves maintenance, etc.... Question: Has anyone seen any measurable improvement in doing this, vs. just creating a huge key_cache and being...

can anyone tell me whats wrong with the following from my.cnf? innodb_data_file_path =...

"PHP" and "MySQL Command Center" recognize correct greek letters from MySQL tables. But "MySQL Query Browser" and "MySQL Administrator" does not recognize anything greek correct. And vice-versa. What I can do?

Hello, The following code grabs the url of a file location on the net from a db on my server for a file download. // connection to grab url of the file mysql_select_db($database_local, $local); $query_dllink = sprintf("SELECT dllink FROM software WHERE swid = %s",$colname_dllink);

Hello, We are using mysql v4.0.24 on Linux machines. I'm trying to set up replication with a master and only one slave database. The syncronization seems to work well, the relay file on slave is wrote correctly (Read_Master_Log_Pos and Relay_Log_Pos are updated) but the information on slave database is not updated. Master and slave are...

Somewhere there is a column called blogs - type TEXT with a FULLTEXT index. Most entries would be in English, but few might be in any other language. Now, if I make it UTF8, it will be a waste of space to use 3 bytes for each character since most entries, say 99% are in English. What should be my approach here - to somehow enable...

Hi Folk I need to limit the number of emails send within a half our period. Every time an email is send, it is recorded in my log table (LOG) using NOW() as entry. The field-type is a timestamp and the name of the field is NOW How do I rephrase the SQL below to make it work --- count(`LOG`.`ID`) FROM `LOG` WHERE NOW > x

Hey all, I have a query that pulls data based on the month. I'm using MONTHNAME(CURDATE()) to get the current month. I need to get the previous month. Is there a way to do this using MONTHNAME? thanks in advance

Is there a way in mysql to discern when the last date/time a field, row, or table was been updated or inserted? Thanks, ike

I've a backup from my database running on mysql 4.1.12 Now i want to restore this to an old machine running 3.23. How to do this. I get several errors. Kees

Hi, When I try to pull out all my data out, the DB appears to be timing out before I get all the data. There is not a where clause in the select. Is there a way I can speed up the query? it is pretty simple

This is a tough question to ask. I need to pull up a report of all the orders in our e-commerce site, that has more than one item attributed to it. orders.ordernum, orderitems.itemnumber orderitems.ordernum is shared with the same field in the orders table. In PHP I could just do a querey of all ordernumbers and within the WHILE do a...

I have a single instance of MySQL package installed on FreeBSD. I run 2 servers. The second server is run with this command: shell> mysqld_safe --defaults-extra-file=/root/my2.cnf & some /root/my2.cnf file entries: port = 3307 socket = /tmp/mysql2.sock Both servers co-exist peacefully except:

Hi, I have the following sql statement written for a Flight center. Can anyone please help me to find out whether they are correctly written? Case: There is a database table named flight that contains the following columns: Identifier, Date, Time, FlightNumber, SSRCode, Runway, OperationType, Airline, AircraftType

Currently i store the chinese character in unicode decimal format (&#<number>;). In this way, I can display and search the chinese character correctly. However, this will take more storage space. Is this the most optimize way? Thank you.

Unfortunately when I was installing FreeBSD, its handbook told me that /var should be around 256 MB or so. Now, since /var is near to the edge of the hdd, it is fast and now I can't store my 2 GB+ mysql data on /var. I'm storing the mysql data on /usr partition which is 60 GB big. Are there any performance implications on my approach ?

this question is cross-posted to 3 unrelated ngs. Please followup only to 1. Hi, How can I do this: select g_name from goods order by g_priority where sum(g_value) < 500 I.e., I want to orderly pick from table goods so that the total picked value is less than a defined value.

I need to import into mysql data from DB2. One of the DB2 table columns is of the TIMESTAMP type, which, unlike its MySQL counterpart, supports fractions of a second, up to 6 digits, i.e. it is of the form 2005-07-13-23:45:32.000000 ....whereas the MySQL timestamp type is of the form 2005-07-13 23:45:32