MySQL Database Forum

Hi, When installing the mysql4 binary it works fine. When installing the mysql max4 binary I get the following message when I try to run mysqld_safe. I am running linux redhat 9.1. Would anyone know why this is happening? 030728 23:54:57 mysqld started 030728 23:54:58 bdb: /usr/local/mysql/data/log.0000000001: Permission

can someone please tell me how to get the install script to work? i also have problem with the user permission. how do you set it up so i could login with a user name and password. i am running Mandrake 9 and the lastest version of MySQL thanks

Any progammers looking for a killer app to develop? How about a voice enabled forum? One of the most powerful, exciting, and engrossing experiences on the Internet is the Forum. The first great Internet forums were the Usenet newsgroups. Usenet is still a powerful force, but many different types of forums are also very popular (such as...

Lese selbst: http://www.npd.de/npd_info/deutschland/2005/d0405-13.html Neue Dokumente: http://www.rp-online.de/public/article/nachrichten/politik/deutschland/87647 Botschafter in Kiew beschwerte sich noch 2004: http://www.rp-online.de/public/article/nachrichten/politik/deutschland/85735 Traumziel Deutschland:

I have a very small db of only like 15 files, and with 120 records. If I do a query from the page, via a php file it seems to take 2-3 seconds for the results to come up. I'm anticipating having a lot more records, upwards of 300-800 records. I'm looking for the best way to create my indexes for fast response times. I think right now that...

Hello In order to perform a hetrogeneous join (I think that's what they're called) between MySQL and another database, I've created an Access database containing linked tables from each datasource. I create the linked tables without any problems, clicking on "save password" before selecting the desired tables. I can then access both...

DEAR FRIEND, COMPLIMENTS, MY NAME IS MR.F.S.SOBANDE,HEAD, INVESTMENT BANKING AND TREASURY OF STANBIC BANK OF NIGERIA PLC LAGOS STATE BRANCH. I AM WRITING IN RESPECT OF A FOREIGN CUSTOMER OF MY BANK(MR.PHILLIP MORGAN)WITH ACCOUNT NUMBER SB1022002-109 WHO PERISHED WITH HIS FAMILY IN AN AUTO CRASH IN ABUJA EXPRESWAY,IN NIGERIA, ON THE 30TH...

Hello, I have a simple, but very general problem with MySQL using InnoDB tables. I am sure you experienced folks can give me a solution... Using foreign keys I want to delete a row in the table T_Child with WHERE T_Child.Parent_ID=x when ALL ROWS in the Parent table with ID=x are deleted. (This behaviour is very useful

Parse error: parse error, unexpected T_STRING in C:\Apache2\Webpage\test_mysql.php on line 44 I receive the above error when trying to insert data into a database. The statement used for insertion is: LINE 44: INSERT INTO ad_data ('website') Values('w'); The database and table is working..

I am writting a webmail client using mysql as the backend. I wrote the scripts using a table for each separate user. I am thinkig about putting all users in one table. the table structure now is pk, msg, folder. i am thinking about adding a separate field called user are there any advantages or disadvanges for doing this. I think some...

Hi, I'm currently using the following mysql statement to perform a search. Right now it is only returning the results which are found in the description field. How do I modify this statement so that it is searching the following fields: company_name, product_name, description. SELECT product_id, company_name, product_name, url, description...

Hello all, I've been using sql and mysql in particular for several years now, but I'm having some trouble coming up with a query that will pull the data that I need from a mysql table without using multiple queries. Here's what I'm attempting to do: Table1 column1-a, column2-a, column3-b, column4-b, column5-c, column6-c in this...

All=20 If you use .NET which DbProvider do you use as I am having a lot of = performance issues with MYSQL and ASP.NET with the providers I have = used. Thanks in advance Aidan Gill --

Hello, I have aproximately 1,000,000 rows and I would like to do some query. The first one is to get the number of row so I do : mysql> SELECT COUNT(*) FROM `Log`; +----------+ | COUNT(*) | +----------+ | 969129 |

Hello! I have a litte problem with my sql-database! I have to update all UA-fields in the table idrz_kennzahl with primary key idrz, where the same idrz in the table per_verwaltung with the field Amt=12 is. I designed following statement but it doesn't work: update idrz_kennzahl set UA=1234

Complements=2C Dear Sir=2C I am Mrs=2E Patrika Kovac a Yugoslavian and company secretary to YUKOS OIL South Africa owned by Mikhail Khodorkovsky =28M=2EK=29 one of the richest men in Russia and owner of the following companies=3A Chairman CEO=3A YUKOS OIL =28Russian Most Largest Oil Company=29 Chairman CEO=3A Menatep SBP Bank =28A well...

Hello, All I installed mysql server on my suse box. I am trying to connect to it through java jdbc application. The program does connect to suse server when I run it on localhost. But when I run this program from outside it gives me "java.sql.SQLException: Invalid authorization specification, message from server: "Access denied for user:...

Hi all, I'm developing a simple computer helpdesk system with MySQL as the backend and Apache/CGI/Perl as the user interface. I've sucessfully set up the part where a user enters an issue via HTML form and "submits" it to the MySQL database. My question is: I have it set up where the user posts the issue to the database, the database...

I've spent the last 2 days trying to begin using mysql. I've purchased 3 books and read huge chunks of the documentation provided with the mysql zip file. I've downloaded 'mysql-4.0.18-win.zip', unzipped it, run the WinMySqlAdmin program, and everything seems fine. I'm trying to use it on WindowsXP on a new machine. I'm trying to learn...

When I open MySQL Control Center, it shows "server properties" window when the server is selected on the left pane. One of the property is "date created". I have not found this variable in server and status variables .... Does anyone know how to read this variable using MySQL SQL query or MySQL API (not file system, etc. ) ? Martin

--=_81DF9BED.E485C8BC Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Hello gang, This may be a very simple question and possibly could have a very simple solution to it. Since I have been using mysql for less than 2 months, I still consider myself a newbie.... I still cannot execute certain commands from my...

SWNoIGJpbiB2b20gMDUuMDguMjAwMyBiaXMgMjguMDguMjAwMyBhdd9lciBIYXVzLg0KDQpJY2gg YmluIHZvbSAwNi4wOC4wMyBiaXMgZWluc2NobGll32xpY2ggMjguMDguMDMgYXVmIFVybGF1Yi4N CkluIGRyaW5nZW5kZW4gRuRsbGVuIHdlbmRlbiBTaWUgc2ljaCBiaXR0ZSBhbiBtZWluZSBLb2xs ZWdlbiBpbiBkZXIgTVBTLg0KRnJhdSBKdXJpYywgRFcgMjEyDQpGcmF1IFNvbW1lcixEVyA2MzEN...

Greetings. I was running PHP Nuke on a Win2k box using Apache2Triad. Fortunately I backed up the drive using windows backup prior to the hard drive failure. Now I have installed Apache2Triad on another machine and wish to reimport the mySQL database that PHP Nuke relies upon. If anyone can tell me how to do this I would be very...

I have a DB of Users of my wish list site. The tables I have are User ----> info about the users UserKey is the key Gift ----> list of gifts each user has on thier wish list foreign key is UserKey Event --->gift giving events for users. foreign key is UserKey Emails ----> email addresses users have sent a message to about their wish...

--=_9EC08B1B.CCADE08C Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Hello gang, This may be a very simple question and possibly could have a very simple solution to it. Since I have been using mysql for less than 2 months, I still consider myself a newbie.... I still cannot execute certain commands from my...