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
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
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
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
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
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
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
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
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
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
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
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
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:
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
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
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
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
17 matches
Mail list logo