MySQL Database Forum

Hello. I have got a MySQL 4.1 that we use wit vBulletin.... We had a crash last week and I've been able to restore the data up to September 2005 as it stands. Now, I'm under the impression I could rebuild the data from the logs but I cannot seem to figure out how to do that based on the tools and instructions posted.

Hello, I am looking for any opensource package for "appointment system" for doctors, please let me know. This is just o take Name/Phone/time, incase if there is not any opensource, then is it hard to implement using web/php/mysql?. Please let me know. GS

Hi! I succesfully exported my locally stored db using the following syntax: mysqldump -u root --password=111 finance > sqlbk.dump Now I created another empty db finance2 (on the same Mysql server) and try to restore their my finance db: mysqldump -u root --password=111 finance2 < sqlbk.dump

Hi! I imported some table (about 1500 records) using "LOAD DATA LOCAL INFILE..." (command line console). No warnings, no skipped, no deletes - all the recored are written to be imported. However, in MySQL Administrator UI tool I see completely different number in the "Rows" column. Making a SELECT query shows that the actual number of...

I am getting myOdbc error 518 Sqlstate- HY001 Invalid application buffer type when I try to retrieve all table names. I am using version mysql Ver 14.12 Distrib 5.0.19, for Win32 (ia32) with Odbc driver 03.51 on Windows XP Home. I have googled the heck out of this and would like a clue. The trace file is below. The query dies looking for a...

$if1 = "IF(s.student_ethnicity_interest_other IS NOT NULL AND s.student_ethnicity_interest_other != '', " . " CONCAT(s.student_ethnicity_interest_other, ', ', GROUP_CONCAT(e.ethnicity_name ORDER BY upper(e.ethnicity_name))), " . ' GROUP_CONCAT(e.ethnicity_name ORDER BY upper(e.ethnicity_name))' . " ) AS ethnicity_name \n\n"; This...

Hello I have the following sql string to run as a command in my VB6 project to update mysql table strSQL = "LOAD DATA INFILE " & ImportFile & " INTO TABLE tPupils FIELDS TERMINATED BY ',' ENCLOSED BY ' " ' LINES TERMINATED BY '\n';" Problem is the double quote at position ......" ' LINES...... causes the command to fail thinking the...

I'm wondering if something like this can be done in mysql... I have two tables I want to pull data from. One table will contain a unique user_id which I could pull out like: select user_id from table; that's basically all I would need from that table. The second table contains a user id field, but can have several duplicate user_id's in...

I am running version 4.1.13a-log on a Mac XServe. How can I receive a 'duplicate entry' error for an UPDATE? An update isn't creating an entry, so why this error message? ____________________________________________________ 060427 11:57:23 Slave SQL thread initialized, starting replication in log 'kiosk1-bin.000006' at position 7233,...

Thanks for the help in advance, It has been over 5 years since I have messed with FreeBSD and I have never messed with MySQL until now so forgive me if my issue is trivial and I thank everyone for the help. The hospital I work for is finally getting off of Micrisift IIS to server the Hospital website. i built a FreeBSD server with Apache...

Hi, I am having a problem getting into a database. The user who normally access it just received a new machine and does not remember his connection info. The database is on a linux box, and I have root access to it. I managed to log into the database as *root* and look at the mysql user table. Two table entries are shown below

Hi Forums, I have a frustrating problem on my Stored Procedure. It can only proccess about 100 records in 10 minutes. I have 2 million initial records that need to processed. Meaning that with this speed i will around 200 days to finish all of them. To make it worse, the data itself grows at least another 100 records per hour. Really...

Hi, I'm learning the ropes with PHP and MySQL at the moment, and I've run into a puzzle. I'm using PHP to process a form and insert some simple information into a table. The code doesn't have any glaring errors, and the mysql_query() doesn't error out, but the info never gets inserted. And if I run the same query inside the mysql client the...

I'm attempting a query that gathers product data for a particular product id. One of the items is designer(s) which can be more than one. The product table has comma separated id's of the designers in the designers table (which has fields like: id, fname, lname). How can my select return the possibly several designers for a product,...

I have 2 virtually identical tables and wish to move data between them. Basically one table is called "live_table" and the other is named "suspended_table" and the only difference is that the primary key in the "suspended_table" is an auto incremented integer where as "live_table" primary key is just a standard integer. Here's the...

Hi, I'm trying to change the value of max_connections variable but mysqld doesn't accept that. I use mysql 3.23.54 and my config file /etc/my.cnf looks like: .... .... set-variable max_connections=200

Newbie questions here... Reading the MySQL manual regarding InnoDB databases, can someone confirm that: 1. if the server is rebooted, AUTO_INCREMENT reverts back to 1? 2. what happens if the field is specified as or PRIMARY KEY or UNIQUE? Cheers Phil

Can i make multiple inserts into a table using one statement. the statement: INSERT INTO table1 (UserName) VALUES (SELECT DISTINCT UserName FROM table2) Basically, i want to take out all the UserNames from table2 and insert them into table1. It doesnt work, why? Thanks Wes

Dear Mysql-ians, I want to calculate the standard deviation of data that are in multiple columns. I know how to calculate the STD of 1 column (e.g. X1 of table_X) using: SELECT STD(X1) FROM table_X; but I want to calculate now the STD of the union of data of columns (e.g. X1, X2, ..., X100 of table_X).

Hello all, My database has a single table with a single column of the type VARCHAR(20). I insert one record into this table through the command line and then I try to retrieve this record through ODBC API. I bind a wchar_t structure to this column with the type as SQL_C_WCHAR using SQLBindCol. But when SQLFetchScroll returns, the buffer is...

Hi, in a shell script of mine I'm executing a mysql SELECT in batch mode. I want to use the return value for other sql statements. The problem I'm facing is that the tabs, which seperate the columns from each other, are missing in the output. What am I doing wrong?

Hello, I have query which work in mysql 4 In mysql 5 I have error 1054. this is this query: select count(p.products_id) as total from

Hi all Can someone help me with the syntax to my stored procedure? Every time I try to run it I receive the error code 1064. I checked my syntax against the documentation on mysql.com and it seems to be correct, but of course I could be wrong. Here's my SP: delimiter | CREATE PROCEDURE `Universal`.`InsertCustomer`

Hey! I need to dynamically create an SQL statement within a MySQL 5.0.20 stored procedure. -- PSEUDO CODE create procedure DynSQLTest ( in sTable varchar(45) )

SELECT ip FROM db1.table1 WHERE ip IN ( SELECT ip_network FROM db2.table2 WHERE name = <value> ) Basically, the way the data shows up in the first column 'ip' is x.x.x.x (full ip). However, for ip_network, it is x.x (only the first two octets). My question is, are there any ways to do some sort of wildcard search so that I could match...