Hi Charles,
Did you create the MySql system tables by running the script
mysql_install_db which is located in the scripts folder?
This script will create the system tables for your mysql database.
After creation you can run the mysqld_safe as root
Login using mysql as user root , leave the pas
Hi,
You are using a reserved function name "AREA" (polygon function) as a
fieldname. Simply change the field's name or try using quotes around
it...
Detlev
> [...]
> FOREIGN KEY (A_areaNum) REFERENCES Area(areaNum),
> [...]
> Any ideas?
--
MySQL General Mailing List
For list archives:
Tomahawk Computers (www.tomahawkcomputers.com),
Singapore, released an advanced multimedia centric
Linux desktop distribution featuring Intel Centrino
wireless technology, Zeroconf, High-Definition audio
and video playback, Bluetooth, Firewire, iPod access
and Podcasts. Complete suite of software a
Dear Peter,
Thanks very much for your concern. Answers to your questions are listed
below. Here, I am facing another serious problem: Should I interrupt the
Indexing work, which has been running for about 19 days? I don't know
how long it will take to finish the job. The table contains
1,045,
Thanks for the reply Brad, two questions about your situtation:
(1) The speedup only applies because of concurrent queries, right?
With sequential queries you would expect no speedup?
(2) If you have 180 underlying tables, then each query to the merge
table has to do 180 separate index lookups, r
When I execute the following query
CREATE TABLE Sponsor (
sNum INTEGER UNSIGNED NOT NULL,
sAdrBlock CHAR(2),
sCivil_ID CHAR(12),
sDateOfBirth DATE,
sDrvLicenseExp DATE,
sDrvLicenseNum CHAR(9),
sGender ENUM('M','F'),
sName VARCHAR(20),
sStatus VARCHAR(20),
sTelephone CHAR(7),
A_areaNum INTEGER UNS
PostgreSQL is becoming the World's Financial Capital !!
All the banks in the world are ordered to change their operations to
run on open-source databases like PostgreSQL, MySQL or FireBird.
It means all the banks in 200 countries in the world run on open
source db system.
The heart of the bank is
I am running Whitebox linux 4 and have MySql 4 installed.
When I run the mysqld_safe file, mysql starts then immediately stops.
It does give me the message that it is starting with "databases from
/var/lib/mysql"
In the mysqld.log file I see -
"[ERROR] /user/libexec/mysqld: Can't fine file: './
