MySQL Database Forum

From PHP, doing a DROP TABLE and a CREATE TABLE is successful, but doing a LOAD FILE keeps failing, with the error "Access denied for user 'db_user'@'localhost' (using password: YES)". The DROP/CREATE code and the LOAD FILE code are in separate .php files which I am running from my browser, but both commands are executed with mysql_query()....

Hi, I am looking into writing many sql statements to a file and then executing those all at once. I am using perl in windows to create the insert statements and then need to load the data into a Unix Mysql DB. Would like to do the insert from the windows side using perl and ODBC, but it maybe much faster to do from Unix that it would be...

I have a date field in my database which is set to accept NULLs. If I enter a record from phpMyAdmin and leave the date field blank, the record is entered properly. However, if I do the same thing from a form, I get an error that the date cannot be blank. It seems that I need to enter a NULL in the date field from the form rather that nothing....

Hello, I've got a mysql server running on linux. It was working fine until this morning when a customer wrote and told me it was not working. On investigation it had frozen. I stopped and restarted it this is on an fc3 box, i get the starting mysql message but never get a prompt back. I don't see any output in my /var/log/messages.1 file. I'm...

Hi, Apologies if this sounds dumb but I'm very new to this. I'm just trying to create a simple login page ( http://aarkenuk.co.uk/barnesg/login.php) In my MySQL databases I have the correct database selected, but it's the users I'm struggling with. You get like a front end with my hosting space (CpanelX) and in there I've created user...

Hello, I am looking to impliement SSL on my mySQL server. I have an existing network with a Windows 2003 Certificate Authority. I have no idea on how to get SSL configured on my FreeBSD server. What is the best way for me to get SSL working with mySQL.

I have a problem that I'm not sure if it can be done. I'm trying to use the MySQL C API to be able to use a normal sql insert statement that will send the data or file to a directory and NOT the database. I'm not sure if there is anything out there that will allow this, but I've searched everywhere, and I have found no solution. If anyone...

We were trying to save https://oururl in mysql database. But got https: / /oururl We don't know why "/" be changed to " /", any suggestion? Thanks

hello all, i m using forms 6i with oracle 10g. i have set Nls_lang =American_America.UTF8. Now my problem is when i type some data i marathi Using a font converter engine directly into the text box on form i just get ?????? in the text box. But when i type same data on notepad n then paste it in textbox it gets properly pasted and also get...

Hi all, I'm hoping someone on this forum can help me. I use hibernate with java to access mysql. We are trying to upgrade from 4.1.15 non-inndb, to 5.0.18 with innodb. Hibernate makes a 'create tables' script. The script installs, but the queries that hibernate creates now fails. These same queries worked fine with 4.1 . Since this is a...

Hi. I have a Python program that parses a file and inserts records into a database with MySQLdb. I recently upgraded to MySQL 5.0.8, and now my parser runs *really* slow. Writing out to CSV files is fine, but when I try to insert the same records in a MySQL5 database, it slows to a crawl. Using MySQL 4.1 seems fine. The data seems to be...

Can I use OLEDB with MySQL? Can someone please help? Rgds Young

I am using VB.NET 1.1 and cannot connect to a MySQL (v5) database. I've done the following: 1) Create a DSN for MyODBC. 2) Connect using: Driver=MySQL ODBC 3.51 Driver; Server=localhost; Data Source=test; UID=test; PWD=pwd; OPTION=3 When I run my app, I get this error: An OLE DB Provider was not specified in

this is what I am doing: mySQL> GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON store. TO newusername@127.0.0.1 IDENTIFIED BY 'newpassword'; I have tried leaving out , LOCK TABLES ON also just ,LOCK TABLES it keeps saying: ERROR 1064 (42000): You have an error in your SQL syntax; check the

Hi, 1. I want to calculate size of the record by mysql queries. Is it possible.. 2. What is the best way to calculate table record size which consists of Text type. Regards, @wahab.

Does anyone know where I could find a complete city and state database for MySQL? I've looked at the Zip Code data on the census website, but don't know the best approach to get a .dbf file into MySQL. Preferably someon has already done this? Thanks, Greg

I have a problem selecting records with \ in any values. For example: SELECT * FROM ADDRESS WHERE STREET = "A\" will give an error: If I replace \ with \\ then it works. Eg.

Hi, I have the following: INSERT IGNORE INTO names (name) VALUES ('John'),('Peter'); In the above query, I want to pass an unknown amount of names to the insert query. I tried a stored procedure with the following:

Hello, I would like to ask some opinions on the best DB strategy for the following problem: I have a table containing information about artists (names, dates, descriptions in three languages etc). The full-text index is put on 16 fields. A user can select records to have access to (like favorite artists). There are two possible full-text...

I'm using phpmyadmin(for the first time) to create a db, why doesn't it like my table? please help SQL-query: CREATE TABLE `artwork` ( `artworkID` INT( 10 ) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT , `title` VARCHAR( 25 ) UNSIGNED NOT NULL , `category` VARCHAR( 25 ) UNSIGNED NOT NULL , `dateCreated` YEAR( 4 ) UNSIGNED ZEROFILL NOT...

Please help! I am hunting high and low for an equivalent function for MSSQL's DATENAME function. Here's the spec on the function from MSSQL's Books Online: DATENAME Returns a character string representing the specified datepart of the specified date.

Hi, I capture data from an none db source using perl and then every night I load the mysql table with the new data. Can someone explain to me the best way to do that? It takes 30 minutes or more to load the data, so I want to store it in a temporary table and then load it into the permanent table without losing the characteristics of...

Hi! I"m sure this is pretty basic, I have a form with two radio buttons (see code), when I click submit the info goes into a mysql database as either 'p' or 'b'. I need to count how many 'ps' and 'bs' I have and outut the results. <p>Business:&nbsp;<input type="radio" name="ctype" value="biz" /> Personal:&nbsp;<input type="radio" checked...

I running MySQL locally and have the following dir setup C:\wamp\mysql\data\mike - This is where the tables for the database mike are stored C:\wamp\mysql\data - This is where I think the database data is stored. Basically the file in the data dir. (ibdata1) is 10,240kb in size. When I update a table in the mike database the file size...

Hi Folk I have a query: SELECT COUNT( `SIS`.`ID` ) c, D FROM `SIS` , `SID` WHERE `SID_ID` = `SID`.`ID` AND `BRO` <> "bot" GROUP BY SID.ID