How To run Multiple Storage Engines: CSV, InnoDB...

I'm running MySQL 5.0.22 on CentOS 5.1 (with all current patches applied) and tried to define a table 'testcsv' using ENGINE = CSV. I couldn't find a *.CSV file in the data directory. After looking it up in MySQL Third Edition (by Paul DuBois) it turns out that I'm not running the CSV engine. My

Re: Optimize: 14 hours and still running!

I do not know the answer to this. I do think your machine is slow, and has too little memory. For such a large database you should have a faster processor and more memory. But, I cannot speak to how the Optimize action works. Bob Cochran Greenbelt, Maryland, USA Nathan Gross wrote: On a

Re: Map of MySQL Users

This is awesome! You missed me by 3 days. It looks like you can see the exact street and house that an email originated from. I like the mapping capability very much. Bob Cochran Claire McLister wrote: Hi, We've developed an automatic email mapping capability from Google Maps API. To

Re: Map of MySQL Users

This shows me as being in Washington, DC. My ISP has a point-of-presence somewhere in the city. My physical location is Greenbelt, Maryland, USA. Bob Cochran Claire McLister wrote: Peter, We try to take care of the situation where people are coming from an ISP account. Let me know if

Re: renaming the database

I think you can just rename the directory that that database lives in. If you read the documentation for CREATE DATABASE in dev.mysql.com, you'll see they discuss renaming the directory (although it does not directly say this can be done to rename the database, but it comes really close to

Re: renaming the database

And, of course, you need to grant permissions for the new database name. Bob [EMAIL PROTECTED] wrote: Robert L Cochran [EMAIL PROTECTED] wrote on 10/17/2005 07:37:26 AM: I think you can just rename the directory that that database lives in. If you read the documentation for CREATE

Re: LOAD DATA INFILE Syntax Error

http://mirror.tomato.it/mysql/doc/mysql/en/load-data.html Bob Cochran Jason Ferguson wrote: I am attempting to import a large file with data in this format: 1923158|GA|1996 Olympic Yachting Cauldron|park|Chatham|13|051 |320446N|0810502W|32.07944|- 81.08389Savannah With this

Re: Another LOAD Infile Problem

You'll have to edit your input file. There will always be instances where some field is quirky and you need to fix it/them/entire rows. Don't expect the input file to be perfect. I'd also suggest that you have a test database on a test machine that is devoted entirely to getting your tables

Re: Another LOAD Infile Problem

Then you are in for quite a lot of editing work. I've done it a lot myself. Don't expect your project to be easy. Look for automated ways to edit the data according to your needs and the actual table structure. Bob Cochran Jason Ferguson wrote: The data is split into about 60 files, average

Re: Documenting and visualizing a database

I would start by writing down what you believe the database consists of: 1. The table structures -- write them down, commit them to paper. 2. The relationships you believe exist between the tables. Document them in writing and visually. Use whatever tool works for now -- don't make the mistake

[Fwd: Re: Beta 5.0.4: Table 'mysql.host' Does Not Exist]

restrictions. Execute it is manually. Check that your data directory has the 'mysql' database. Robert L Cochran [EMAIL PROTECTED] wrote: When I installed MySQL-server version 5.0.4 on my Fedora Core 3 system (Linux x86, using RPMs from MySQL.com) with SELinux running in enforcing mode, the server

Beta 5.0.4: Table 'mysql.host' Does Not Exist

When I installed MySQL-server version 5.0.4 on my Fedora Core 3 system (Linux x86, using RPMs from MySQL.com) with SELinux running in enforcing mode, the server failed to start, possibly due to denials from the SELinux implementation. 'restorecon -R -v /var/lib/mysql' failed to let the server

Re: MySQL upgrading

I myself want to go from version 4.1.7 to 4.1.9, so I read the upgrade page, which advises you to back up your databases. You do that with mysqldump, and that is briefly explained here: http://dev.mysql.com/doc/mysql/en/upgrading-to-arch.html I added this user comment to the page:

Re: upgrading from 4.1.8 to 4.1.9

I'm using Fedora Core 3 and just did an upgrade from 4.1.7 to 4.1.9, using Linux AMD64 rpms from the MySQL web site. It looks like everything went well. For me, the hard part was backing up my databases with mysqldump -- see my comments under the thread MySQL upgrading on this list. I shut

Migrating Access Tables -- Empty Columns, Date and Time

I'm migrating a Microsoft Access 2002 (Service Pack 3) table constructed by my wife to a corresponding table in MySQL 4.0.20. Some columns in most of the 3000+ rows are empty. Some of these are contiguous empty columns. I don't know if Access considers them NULL or not, but when you export an

Compiling MySQL 4.1.1 For New OpenSSL Version

I downloaded the Linux RPM binaries for MySQL 4.1.1 and all except MySQL-shared-4.1.1-0.i386.rpm and MySQL-shared-compat-4.1.1-0.i386.rpm installed correctly. The -shared RPM failed on missing dependencies, it was looking for openssl 0.9.6 and libcrypto 0.9.6 shared libraries and couldn't find

4.0.7-gamma build: aclocal and automake error on Red Hat 8

While trying to build 4.0.7-gamma from the source rpm with this incantation: rpmbuild -bb mysql-4.0.7-gamma.spec on an old machine which has seen several Red Hat upgrades (ever since version 6.0), the build continues for nearly an hour until it gets this error: make[1]: Leaving directory