Forum: MySQL

Hi I am using .net Framework 2.0 (VS 2005) ; connecting to a remote MySQl database. When I connect & read data in code; all is fine. When I try to use an SQLDataSource control on my form ; I get an error message .. Unable to find the requested .Net Framework Data Provider. It may not be...

Hi Guys, I want to use the % wildcard on a query to match some phrases from one table to a column on another table . But I am having doubts whether I am actually doing the right thing here. This my query: SELECT name, phonenumber, address, streetname FROM `wb_stores`, `wb_store-street`...

I can't get my head around this one. I have a database table with all events that are held in a city. On the website events are shown for each month. Al events have start date. If the event is held longer then one day there also will be a end date. In a few occasions though some events will start...

I'm trying to make a copy of a MySQL site onto another domain, for testing, backup and demo purposes. The problem that I have is in creating the copy of the database, I've tried creating a new empty MySQL database and importing the file dump from the original using phpMyAdmin but it fails. Dumping...

Just started planning a new MySQL database and reading up on whether to use MyISAM or INNODB tables. Generally seems INNODB is more reliable but then a while ago when Aluminium had a problem the INNODB tables were unrecoverable which confuses me a little - could anyone clarify whether or not...

Hi Guys, I am struggleing with the following. I am haveing a kind of a lotery, people recieved a unique code that they need to submit on a website. Unforunatly I recieved the list with unique codes after the lotery started from the printer/publisher. So I couldn't check if the entered code...

I'm used to working with ASP/SQL Server and know quite a few databases have been infected by script injection attacks. As well as some defensive programming I normally use stored procedures and a user id with the minimum amount of permissions necessary in my connect string to prevent this. However...

...Is it possible to create them ? I've worked out the table needs to be innodb but still can't see a way to set the foreign keys. Cheers

Hi, Does anyone know how you revoke privileges from database users? I've just added a new user in Helm, then in phpMyAdmin (logged in with my main login) I tried revoking privileges from the new user, but it said "Access denied". Steve

Hello RedFox people! hope you can give me a few pointers on using a mySQL database with .NET DataSets and TableAdapters I've got all my code running quite happily here, using version 5.2.2.0 of the connector to access local mySQL or live mySQL on your Hydrogen box but when I try to deploy my...

Guys, It possible to do all this with just one SQL query? Let’s say I have a table with health info on all my pets in a MySQL database. +--------+---------+--------+ | name | specie | health | +--------+---------+--------+

I'm planning to play around with mysql a bit and I've got it working on my pc. I'm not sure yet whether to do everything from the command line or install something (php my admin, maybe) to make it easier. Just wondering what other people are doing - any recommendations? I'm used to working with SQL...

Hi I am having a look at a Asp webiste that uses Mysql database, I have installed the website on my own develoment server Win 2003, but I cannot connect to the database located on the live site servers, I get the following error Microsoft OLE DB Provider for ODBC Driverserror '80004005' ...

Any one come across this issue. The MySQL connector will not work in Medium Trust. There are 2 issues one that can be worked around by recompiling the connector and the second due to trust issues. Below is a link to some info that I found on the web ...

Hi, I have a mysql database up and running on my domain. I have a backup of the db produced using the red fox backup facility. How do I restore the db? Is it just a case of uploading it over the top of the original? Any advice would be appreciated. Charlie

Hi, Can anyone tell me how to set the defaults for max connections and max allowed packet size on a mySQL dB on my shared hosting account? What are the considerations when setting these defaults? Thanks, CHarlie

Hi, I'm looking for a quick and easy way to backup a MySQL dB on RF before doing an update to the application that is using the dB. Any suggestions? Charlie

OK finally got around to doing a bit of development. I have MySQL 5.0.24 installed on a local virtual machine. I have the sql file from a Redfox backup. However, when I try to restore it to my local MySQL database I get all sorts of errors. Any help would be great. (I'm most likely restoring it...

:wacko: I don't get it .. i'm out of ideas. How do I get all records of the current month? This: SELECT * FROM web_bday WHERE MONTH('2006-8-1') = now() Doesn't seem to work.

As a complete novice I am trying to create a connection to my database with dreamweaver. In the MySQL connection dialogue box, what would be the correct entry for "MySQL server"? (I tried putting localhost but it didn't work). I'm not sure wheather I may have made some other fundimental errors in...