I have a constantly growing database of keywords. I need to parse incoming text inputs (articles, feeds etc) and find which keywords from the database are present in the text. The database of keywords is much larger than the text. Since the database is constantly growing (users add more and more keywords to watch for), I figure the bes...
I grabbed a database of the zip codes and their langitudes/latitudes, etc from this This page. It has got the following fields: ZIP, LATITUDE, LONGITUDE, CITY, STATE, COUNTY, ZIP_CLASS The data was in a text file but I inserted it into a MySQL table. My question now is, how can i utilise the fields above to calculate the distance ...
We are currently using Mysql version 5.0 in our application and are thinking of moving to version 5.1 How stable is version 5.1.30 ? EDIT When version 5.0 was released it took a long time to become stable ...
The MySQL documentation isn't very clear on this. I want to add an index to an existing table. The table is a user table with the login id and password and I want to create an index for this to optimize logging in. This is how I thought I would try it: mysql> ALTER TABLE `users` ADD INDEX(`name`,`password`); This created: mysql> sh...
Looking for a tool that will automatically create a graphical representation of a MySQL DB schema from a live database, showing tables, columns, and relationships (an ER diagram). Ideally something that would run on OS X would be great but I'll take what I can get and run it on a different machine if necessary. I checked Google and del....
I have an ASP.net project I'm looking at and they want to use MySQL. I'm used to SQL server but using mySQL shouldn't be a problem. Normally the control would like a SqlDataSource to bind to but that's not available with MySQL (from other posts on this site). What's the best way to connect MySQL and the DevExpress ASPxScheduler so tha...
Is it possible to enforce uniqueness across two tables in MySQL? I have two tables, both describing users. The users in these tables were for two different systems previously, however now we're merging our authentication systems and I need to make sure that there are unique usernames across these two tables. (it's too much work to put t...
We are using MySql version 5.0 and most of the tables are INNODB. We run replication to a slave server. We are thinking of backup the MySql log files on a dally bases. QUESTIONS: • Is there any other way of doing an Incremental backup without using the log files? • What are the best practices when doing Incremental backups ? ...
I'm trying to design a database for a sports meeting. I think I've got something good but I'm not quite sure. The situation is as follows. There is the meeting, several sportsclubs will each send a number of athletes: 1 or more. The athletes can enter in more then one event. There are several events: Marathon, pole-juming, spear throw...
What would you recommend using between a datetime and a timestamp field, and why? (using mysql). I'm working with php on the server side. ...
So I'm trying to build a simple forum. It'll be a list of topics in descending order by the date of either the topic (if no replies) or latest reply. Here's the DB structure: forum_topic id, name, email, body, date forum_reply id, email, body, date, topic_id The forum itself will consist of an HTML table with the following h...
Ok, here is my dilemma I have a database set up with about 5 tables all with the exact same data structure. The data is separated in this manner for localization purposes and to split up a total of about 4.5 million records. A majority of the time only one table is needed and all is well. However, sometimes data is needed from 2 or more...
I am trying to insert a very long text string into a MySQL Blob column, but MySQL is only saving 64kB of the data. The string is 75360 characters long. I am connecting with PHP's mysql_connect(). Any ideas? Does it make a difference if it's Blob or Text. I originally had it as a Text but changed it with no affect. ...
I have my MySQL database server on Server 1. I want to have my Rails apps on two other servers - say A and B to be able to connect to this Server 1. What's the best way to do this? In the my.cnf file it appears I can use the bind-address to bind to one and only one IP address. I can't specify the IP addresses of both A and B in my.cnf. ...
I've seen other topics that deal with this error but none that seem to correspond to my situation. First of all, my code works completely fine when i run it locally. But when i upload it to the server, i get the error: Parameter '?PuserName' not found in the collection. Here is the C# code: public DataSet GetEmployeeByUsername(strin...
Assume I have a database table with many names. I'd like to "flex match" against these names. I'm not sure if "flex match" is the proper term to use, but let's go with that for now. There have been similar discussions on "fuzzy matching," but I'm not really interested in phonetic matching. I'm interested in what I'd call ordered-subs...
Using MySQL syntax, how would I write a query to return the following (I am including the two table descriptions and the relationship between them): TABLE_A (ID, DATE, TABLE_C_ID) TABLE_B (ID, AMOUNT, TABLE_A_ID) TABLE_C (ID) I want to return the following, with the specified limitations: SELECT TABLE_A.ID, TABLE_A.DATE ...
I'm not sure if this is the right place to post these kind of questions, if it's not so, please (politely) let me know... :-) I need to save files greater than 16MB on a mysql database from a php site... I've already changed the c:\xampp\mysql\bin\my.cnf and set max_allowed_packet to 16 MB, and everything worked fine then I set it to...
Are there any 64-bit version RPMs of MySQL GUI Tools? ...
Do I use varchar(36) or are there any better ways to do it? ...