RE: query on a very big table

I have tables that are over 7 million records and I originally had the same issue, however if you will create indexes in those tables, on the columns that you will be using for your queries this will GREATLY speed up your queries. I am sure that there is a more concise way to state how you should

Compressing after Deletion

I have looked in the documentation and either I am not looking for the right thing or have simply overlooked it. But my question is this, I have a database with 35 Million records, and I need to delete about 25 million of those. After deletion I would think that I would need to compress, shrink, or

Changing DB name

Is there a way to change the name of a database? What has happened is that our test db has now become the production db and so I want to rename the database. Chris Hood  -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Resetting Auto-increment

Is there a better way to reset the auto_increment in a table, basically there are several million rows in the database and the field that is auto_increment is very large now and I don't want to exceed the limit of the field description so I want to renumber all the rows starting at 1 again. Wha

DBD::Oracle issue

ALL, Can someone help out with this error: DBD::Oracle::st execute failed: ORA-03106: fatal two-task communication protocol error (DBD ERROR: error possibly near <*> indicator at char 23 in 'select table_name from <*>all_tables') [for Statement "select table_name from all_tables"] at ./orac

RE: DBD::Oracle issue

your assistance. Chris Hood  -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 01, 2005 8:02 AM To: Christopher L. Hood Cc: mysql@lists.mysql.com; beginners@perl.org Subject: Re: DBD::Oracle issue Hi, I'll try even if this is not a neither o

RE: storing recurring dates

Bob, You should check out the Date::Manip module from CPAN, it will do what you need to do. Here is a snippet from the docs about recurrence: RECURRENCE A recurrence is simply a notation for defining when a recurring event occurs. For example, if an event occurs every other Friday or every 4

MySQL Losing database information

ALL, I have an issue where MySQL has lost all of the table information for an existing database, I do not know of anything that has changed and there was no maintenance being done in MySQL. Below you will find the error message as I receive it from MySQL. ANY ideas or suggestions on how to

Ask for input during SQL script execution

All, Can someone point me in the right direction ? I am trying to right sql scripts for queries that will prompt for information. Here is the gist of it, I have a sql script that will query a database however I need the script to ask the user for IP address, and other information that will

RE: MySQL Losing database information

on Global Security Operations Center Email:[EMAIL PROTECTED] Desk: 972.399.5900 Verizon Proprietary -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 18, 2005 8:05 AM To: Christopher L. Hood Cc: mysql@lists.mysql.com Subject: Re: MyS

Query from mulitple tables where data will only be in one table but that table unkown

Ok, So here is what I am trying to do, I have 2 tables one with DSL IP addresses and one with Dialup addresses. I need to be able to query both tables and extract the information by IP address but I will not know which table the data is in before I do the search. Basically I want to have a que

find out who was online at a given time

Ok, this may or may not be a tricky one I will try and be succinct in my statement. I have a database (mysql 4.0) with radius log entries for each day, we receive emails about Acceptable Use Abuses and must figure out exactly who was online with a certain IP address when the abuse occurred. As yo

Indexed Database still slow

Ok, I will be the first to say that I am learning about indexes, however it is my understanding that if I have a database with MANY rows and I wish my queries to be faster I should index my database. With that being said, I have 2 tables in my database that are being queried with a single query usi

RE: Indexed Database still slow

have received this message in error please notify the sender immediately and delete the message. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 28, 2004 8:41 AM To: Christopher L. Hood Cc: [EMAIL PROTECTED] Subject: Re: Indexed Database still slow

Date Conversion Function

M$ SQL server has a function MM that will do some date conversion, is there an equivalent in MySQL ?? Chris Hood Investigator Verizon Global Security Operations Center Email: [EMAIL PROTECTED] Desk: 972.399.5900 Verizon Proprietary NOTICE - This message and any attached files may

RE: Date Conversion Function

Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 29, 2004 12:27 PM To: Christopher L. Hood; '[EMAIL PROTECTED] ' Subject: RE: Date Conversion Function I do not know of an MM() date function in MS SQL, only mm used for the date part. What are you att

RE: Brainstorming' time!

Ok unless I missed something here, wouldn't you just use the "SELECT ... INTO OUTFILE" Syntax found here http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html Just search for "outfile" and you can find it faster. You can run a query against a table and save the output into a file and in the case of cr

RE: A new Machine

Well Actually the current Red Hat Release is "Fedora Core 2" , which works very well. You can find it here http://www.redhat.com/fedora/ Chris Hood Investigator Verizon Global Security Operations Center Email: [EMAIL PROTECTED] Desk: 972.399.5900 Verizon Proprietary NOTICE - This

Best way to get Access DB structures into MySQL ??

What is the best way to take the structure of multiple tables in Access and get them re-created in MySQL without doing that all by hand? Is there a way to do the equivalent of a Show Create Table in Access, that I could then use in MySQL ?? Chris Hood Investigator Verizon Global Se