MySQL Database Forum

I hv a mysql 4 run on RH linux server , the default apache service is running , now I want to install the httpd rpm to the server because the ARCserve backup software need to install it first , I just want to ask if I install the httpd to the server but not start it , will it affect the setting / o peration of the web server , I am afraid the...

When executing multiple queries, which return a result set, must mysql_free_result be called after retrieving each result set using mysql_store_result? My concern is that if the result was not freed after each retrieval, that perphaps it may impose a memory leak. Or, does MySql reuse previously allocated memory for subsequent result sets? ...

Hi I am just about to import a txt file to mySQL and am wondering about the automated numbers created in my Access database - I have created a column 'etc_id' with mediumint as the type and I see that it begins with 0. Will the numbers created in Access populate this column? or am I going about this the wrong way. Would appreciate...

I have a database of movie titles, with about 78,000 records, and a database of related people (directors, writers, actors/actresses etc.) with about 141,000 records. I display a random movie out of this database on each hit to my website's homepage. This worked fine when I had only a couple thousand movies, but now that the DB has grown,...

Hi I have two tables: T1 --------- sequence start end T2 --------- id pos

Hi all, I've just converted the tables in a big database (approx 27 million records) from MyISAM to InnoDB. When I was using MyISAM I backed up the database by stopping MySQL and then copying the MYI, MYD, frm files in the database directory, and restored the database in the same way. Is there a similar way to backup and restore InnoDB...

I have an initial setup of Postfix pushing all mail from a domain to Dbmail using dbmail-lmtp. There are no mailboxes setup on Postfix. How or what program is going to sort the messages into each users mailbox once they arrive from the internet? Sorry, but I am a little confused about the process. Thank you. Kell Jemison

Hi 2 years ago i managed to set up my PC to be able to upload semicolonseparated database-files to my mysql-database on a webhost-server which also contain my website (from where one can do search in the database). I had installed some mysql-programs and learned the upload-procedure (with heavy help from others). 3 weeks ago my HD broke down....

Hi, I have a database with about 60.000 rows that contain in total 500MB in one TEXT colum. Now I need do so some searches in the TEXT fields. I use the following code: SELECT * WHERE DATE_FORMAT(pubdate, '%Y%m%d')<='20041111' AND (tekst LIKE

I'm trying to set-up replication following a book and on-line guide. This is over SSH with a tunnel (not sure if the tunnel's required). The master appears to be set-up OK (easy enough). The slave however isn't behaving. I've got a my.cnf with the following: master-host=127.0.0.1

Hi I have two tables TABLE1 t1_id int not null t1_other stuff blah blah TABLE2 t2_id int not null

Hello! I need to operate MySQL database via LabWindows environment which is basicly C language. Can you give me a short info how to start and what files do i need to attach to my projects to make it work (headers, libraries, other?), and where can I find them. I'd also appreciate that if you could give me an example of program operating...

Hello, Hi am trying to use the --defaults-file with a compiled version of mysql on a Feodra Core 2 based on Linux-2.6.5 I type the following command : /usr/local/mysql4src/libexec/mysqld --basedir=/usr/local/mysql4src --datadir=/usr/local/mysql4src/data --user=mysql4 --pid-file=/usr/local/mysql4src/data/mysql.pid --socket=mysqld.sock...

I want to setup a database symbolic link within Windows XP to a network drive which has significanlty more space available and can't seem to get it working. Here is my setup.... - I am running MySQL 4.1.7 - I have tried this with both the 'mysqld-max' and 'mysqld-max-nt' servers - Per the MySQL manual (section 7.6.1.3) I setup a...

Database Normalisation Advisor Designated Contact: thox, xpl2 Status: Open Open Date: 2004-10-26 11:53 For Project: Lands of Myths & Legends (http://sourceforge.net/projects/lamyle/) Long Description: Our project requires someone to advise us on the database structure for a game that we are planning to create. The key requirements are

I hv a mysql db in my RH linux , there is a very large table in the db , the file size is about 2G , how can I split the file into two files - two files physically and one file logically ? is there any tools to do it ? thx

Hi all, I 'm trying to set character_set_connection variable in my.cnf with no luck. Does anyone know how to do it? Thanks, Gvre

Hi, new to mysql, php, designing a membership type of database, potentially many members. Essentially I am faced with a design choice; have an oft run (modifiable) query run every time any user wants to run it, comparing criteria againt each and every user in the table and delviering list OR saving that list (user/user/) so the next time...

System Info: RedHat Linux 9 (text only) Mysql 3 When I execute mysql from the command line I receive an error: "error 2002: Mysql cannot connect to socket /var/lib/mysql.sock" (or something similar) - the socket was definately not "/tmp/mysql.sock"

hi, does anyone have a perl example of loading blobs from either a bin file or an input stream? much thanks, peter

I'm scrolling by Order_# where I find and display on screen the < (lesser then) value of Order_#. Here's the syntax: "Select * From Orarchd Where `Order_#` < " & lngOrderNumber & " Order By `Order_#` Desc".... Order_# is the primary index. lngOrderNumber is the current value of Order_#. Here's the problem ...it takes forever to find the...

Hi, I have a web app running from our MySQL db. A form pops ups & sometimes a user will have to enter seven zeros (0000000) in the field for a specific reason. Which datatype do I need ? Thanks in advance

I wish to access the embedded MySQL through ODBC calls. Is it possible to do it. If someone has tried it, please throw some light on this. Thanks, Raman

I saved my website databgase to my home computer. I am setting up a local version of the site, and need to import the database. I have mysql and everything set up. But when I try to run the sql script that I exported from my site's control panel, I get an out of memory error. What is the proper way to import this database? Do I need to...

Can you have VARCHAR() and CHAR() columns in the same table? Will itaffect performance (speed)? What about on non-varchar searches? SQL , Query , mySQL .