In regards to building the source distribution of MySQL on a Solaris/Intel system
(i.e. Solaris 8 for Intel), I have successfully 'built' and installed MySQL 3.23.40,
and found the following tasks need to be performed:
As Phil Dibowitz stated:
You need to have your LD_LIBRARY_PATH set. F
Would the submitter of this Email to the list (seen below as
mailto:[EMAIL PROTECTED]) please fix your "/etc/hosts" file to
display your 'real' system name and 'domain'...
Also, you should create an account for yourself on the system, and send
your emails to the list as that user (how is anyone
You did not mention what the 'client' or the 'server' were (i.e. NT, UNIX,
Mac), or what the 'distance' between the 2 was (over the Internet ?, thru
firewalls, etc).
If you're trying to connect over any distance on a network, make sure you
DON'T use 'telnet' or 'ftp' (or you will find your ser
Ick !!!
This question had come up on the list about 2 weeks ago...
I like:
WinVI (I know that the Emacs lovers will respond soon) at:
http://www.winvi.de/en/
For other versions and 'ports' of VI, see "The VI Lovers Homepage" at:
http://www.thomer.com/thomer/vi/v
"mysqldump" creates an 'SQL' script, which you 'run' to recreate the tables
and data within them.
Something like this should do the trick...
mysql -u root -p password NewDataBaseName < file.mysql
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, J
You should use the 'startup script' supplied with the 'source' distribution
(named "server.sh" in the subdirectory "support-files").
To 'boot' without starting any applications or daemons, type "boot -s" at
the 'boot prompt' (Lilo's boot prompt if you have installed "lilo"). This
will boot the
If you had read the installation instructions, you would have seen
statements that looked like this...
cd /usr/local/mysql
./bin/mysql_install_db
Make sure that the "var" directory that is created grants access to the
'user' that MySQL is running as... (otherwise I'm sure we'll be getti
Here's another one that appears to be a 'carrier' for something devious...
(though I didn't see any attachments)
How did it get thru the list without any of the necessary 'words' ?
Perhaps someone should block this Email address from the list:
[EMAIL PROTECTED]
P.S. Database
- Original M
It's nice to see that someone has an 'auto-response' setup for incoming
infected messages...
BUT, by the looks of the original Email (at the bottom of this message), it
was an intentional attack on the list...
P.S. Database
> - Original Message -
> From: "Bulk Mail Response" <[EMAIL PR
I think you meant that you're Sun server is using version "3.22.xx"...
The files with the ".ISD" and ".ISM" extensions belong to the "3.22.xx"
family of MySQL Isam file version types... (while the newer "myisam" have
the ".MYD" and ".MYI" extensions).
You would either have to 'upgrade' the MySQL
You might have had a 'distribution' that was installed via the 'RPM' method.
You can see if the RPM packages are installed by typing:
rpm -q -a | grep -i mysql
If some package appear (as 'mysql-something), remove each one by typing:
rpm --erase 'mysql-something'
Otherwise, if you'v
AND, you'd want to 'protect' the data from viewing if you've 'dumped' the
database or backed it up to an 'insecure' media or location (to
tape/disk)... Encrypting the data, with the 'key' or 'salt' located
somewhere else, would allow you to 'transport' the tables containing the
sensitive data
Depending on the 'environment' (i.e. O/S you're using), the tools available
might be different...
But, using Linux (and I'm sure any other 'flavor' of Unix), my company
used the latest 'libmcrypt' to encrypt the credit card numbers (as well as
the user passwords) within a PHP function prior to
What directory are you in when you 'unpack' the source distribution ?
What directory are you in when you issue the 'make' command ?
What directory are you in when you issue the 'scripts/mysql_install_db'
command ? (I usually go to the 'installed' directory "/usr/local/mysql" and
type "./bin/mys
More RAM never hurts (as long as you're using it, which you might be able to
influence by your other option of optimizing the server variables).
I've always had the opinion, that the faster you service the queries, the
more queries you can handle with existing resources. This might be best
han
What about the version of the file which should be in
"/usr/local/mysql-3.23.39-pc-solaris2.8-i386/bin" ?? (which is the one you
should be running from the 'mysql' directory as "./bin/mysql_install_db" )
- Original Message -
From: "Wu, Steve" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc
here), but has a pretty steep learning curve.
>
> -- Original Message ------
> From: "Steve Brazill" <[EMAIL PROTECTED]>
> Reply-To: "Steve Brazill" <[EMAIL PROTECTED]>
> Date: Mon, 16 Jul 2001 10:48:08 -0700
>
&g
Don't forget that "WinVI" exists and can be found (and downloaded) at:
http://www.winvi.de/en/
And for those who like the 'code warrior' or 'slickedit' type of stuff
(where different types of 'statements' are highlighted in different colors),
there's "Code Genie" available at:
http://www.c
Here comes my 2 cents...
The 'advantage' of installing a package such as MySQL on your system as
"root", is that the "root" user would be the only one able to 'modify'
permissions on the installed files. You'd still create a "mysql" user and
"mysql" group, which would be assigned to the "var"
First, I'd like to say that it's great that a "Solaris for Intel" version
of the binaries are now available (or was it my poor eyesight that hadn't
seen it before).
There's a possibility that the fact that you've used a 'symbolic' link for
"/usr/local/mysql" is causing a problem (though it works
Just checked the site, and only see version 3.22.26a (very old) on the
site...
- Original Message -
From: "Ravi Raman" <[EMAIL PROTECTED]>
To: "Mike Jimenez" <[EMAIL PROTECTED]>; "Steve Brazill" <[EMAIL PROTECTED]>;
"Mysql"
safedir%2F
space3%2Fcoll2%2FSUNWasup%2Ftoc%2FPACKINSTALL%3APACKINSTALL%3Aclose&DwebQuer
y=package+OR+creation&oqt=package+creation&scope=BOOK&Ab2Lang=C&Ab2Enc=iso-8
859-1
- Original Message -
From: "Mike Jimenez" <[EMAIL PROTECTED]>
To: "Steve Brazill&quo
I'd think that someone would have to had created a 'package' for Solaris
installations, BUT, you'd have to identify which version of Solaris you
were using, and whether you're running it on a SPARC or Intel based
system
I haven't seen them on the site (you could download the source fi
Oh, and if you're going to use this system as a server for
intranet/internet resources, why do you have a Win98 drive installed ??
You won't be able to use it if you're going to keep the system up, running
Linux...
- Original Message -----
From: "Steve Brazill&quo
Here it is at "bookpool.com" (my favorite source for tech books) for $31.95
http://www.bookpool.com/.x/nqmc5ymle4/sm/0735709211
And an interesting one on PHP and MySQL that I haven't seen 'reviewed'
yet...
http://www.bookpool.com/.x/nqmc5ymle4/sm/0672317842
- Original Message -
From: "F
g MySQL on
any RedHat 6.2 system). Look closelyat the permission settings I
use.- Original Message -From: "Aditya Dhekney"
<[EMAIL PROTECTED]>To: "'Steve Brazill'" <[EMAIL PROTECTED]>;
<,[EMAIL PROTECTED]>Sent: Thursday, June 21, 2001 12:50
Could you list (exactly) what commands you are using to 'unpack',
'configure', 'build', and 'install' the distribution (which package have you
downloaded ?) ??
- Original Message -
From: "Aditya Dhekney" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 21, 2001 12:19 PM
Su
Perhaps the 'replication' of 'user' data (and/or other MySQL 'control' data)
doesn't perform the necessary 'refresh' (which occures when you do a "flush
privileges"), but was 'triggered' when you changed the users' password
Turtle wrote:
> Ok.. even more bizarre... IN addition to what I to
You didn't mention how many 'transactions per second/minute/hour' you
expect... (on those 25 connections)
A Sun Ultra 10 is just a PC built by Sun (but with a Ultra-SPARC CPU and
other nice enhancements). I don't know if Sun has made it possible to
attach ANY brand of disk drive (that they haven
Someone else asked this question last week, and it turned out that she had downloaded
the Sun/SPARC version (as you did) and tried to install it on a Sun/Intel system...
If you type "uname -a", what does the display tell you ??
zhiheng_huang wrote:
> Hi,
> I try to install mysql-3.22.32-sun-
It's looking for the "host" table (physical files) within the 'mysql' data area
(not your own data area).
Did you run "mysql_install_db" after installing the new version ? (or copy the
"mysql" subdirectory from the old version)
Guy Smith wrote:
> I just upgraded from 3.23.27 to 3.23.32 (can't
In case you're not aware of it yet, Linux (and other UNIX operating systems)
are not 'binary file compatible' with Microsoft products (including Windows
98).
You should always 'dump' your database contents (using mysqldump) before
'moving' the data to build another database (unless you're moving
If you're trying to check a 'remote' system, you can 'telnet' to port 3306
(IF you have remote 'telnet' access to the MySQL service, and IF it's
listening on the default port 3306) which will display some garbage containing
the version number
> telnet yubby.dubby.com 3306
3.23.37G\Tn
Is it 'exactly' once every 10 times ??
You should check to make sure it's not an 'external' issue.
- Do you have a 'series' of DNS servers (like 10) that you use to lookup
system names (and 1 of them isn't working properly ?)
Try some other service (like 'pinging' the MySQL server from the P
organa), which is why I used a subdirectory of
> /export. Besides, I don't have permission to write to /usr/local.
>
> My OS is Solaris2.7 /i386.
>
> Thanks for your quick response.
>
> Barbara Baughman
> X2157
>
> On Mon, 11 Jun 2001, Steve Brazill wrote:
>
You might have issues with the 'environment' you're setup with...
What 'shell' are you using (especially when you performed the installation)
??
Isn't "/export" an 'NFS mounted' area ? (will this cause issues with the
installation ?)
Can you 'resolve' (lookup) your system name yourself ? (i.e
s as "rwxrws---" and the rest of the MySQL are as 'root.root' and
"rwxr-xr-x"
- Original Message -
From: "Mike Jimenez" <[EMAIL PROTECTED]>
To: "Steve Brazill" <[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 2:57 PM
Subject: R
When you 'copied' the data directory (and/or contents), did you make sure
that the directory and file 'ownerships' and 'permissions' remained the same
? Did you check the 'ownership' and 'permissions' on the new MySQL 'parent'
directory ?
- Original Message -
From: "Mike Jimenez" <[EMAI
What type of installation is your corrent MySQL config ?? (i.e. RPM, source,
etc)
I find that the best way to manage updates, and be able to 'save' different
versions for 'fallback' or testing, is to always use the 'source'
distribution (not the source RPM).
I 'config' the package with the --pr
For MySQL databases, is there any ability (or method) to construct
'record layouts' which
would provide alternate fields within the record ?
I'd like to create a "codes" table, where different types of reference
'codes' would be stored (i.e. "payment terms", "tax authorities",
"credit card types
Perhaps the physical layout of your disk drives are contributing to the
'slowness'...
- Are the 12 drives making up the SCSI RAID 5 array the only drives in the
system ?
- Do you have the O/S and/or the 'temp' area being used by MySQL on
different drive devices than the RAID array ? (is the 'tem
Oh, and response time should be 'faster', since you can locate the different
tables on separate storage devices, allowing for concurrent drive access to the
different parts of the item.
Steve Brazill wrote:
> You should split the data-fields into tables containing 'categ
You should split the data-fields into tables containing 'categories' of
fields.
* 'textual' (or informational) fields would be the main 'item' table
* 'quantity' and other 'numeric' fields that are updated frequently (i.e.
quantity sold, quantity on-hand) would be in the table that wou
You should get an identical 20gig IDE drive to 'mirror' the O/S partitions,
and since you have a SCSI setup for the data areas, you should get at least
2 more of those, and 'stripe' the data across them (or at least get a second
drive to 'mirror' those partitions as well).Though 'mirroring' w
Before you listen to anyone else (and spend any money on a commercial SSH client)
download and try "PuttySSH", which is a free 'telnet like' SSH client (it WILL
do straight telnet if you want it to) that works fabulously (at least for me at
home and work for the past year). You can also downloa
Do you 'refresh' your tables before each test ? If so, is it possible that
you're writing over the same disk space each time (which would point to a
drive surface problem). Is it possible that the larger runs of 'inserts'
are using more RAM than the smaller tests, and you're hitting a bad memo
Can you give more info on what type of system this is ??
Is this really a 'server' type machine, or an HP "Vectra" PC ?? (of the
'XU' series ?)
Does it have the onboard SCSI controller (what size drives, and are they
SCSI drives ?)
- If they're SCSI, you might want to get 4 drives, and m
If you look at the 'text' file you created with the 'dump', you'll see that
it contains all of the 'SQL commands' to recreate the tables and 'insert' the
data you've extracted.
So you simply type:
mysql mydbf_db < /mydir/mydbf.backup
(you might have to insert/add the -u and a username and
Look on Ebay for Compaq 1850R 'rackmount' servers...
You can find one with 'dual' Pentium II CPU's, dual power supplies (which you can
plug into 2 different circuits or UPS's), and enough SCSI drive slots to provide the
disk space (and the different number of storage devices to 'mirror' and s
It looks like they're running Sun Solaris version 2.6 (SunOS 5.6) on an
Intel-based system (as apposed to a SPARC based Sun server). The MySQL
site only shows binaries available for the SPARC version of Solaris, so
you'll have to download and compile the 'source' distribution...
- Origin
Have 'cron' run the normal "mysql" init script (should have come with the
distribution). The script already checks to see if there's a "mysql" process
already running (and issues a "A mysqld process already exists" message).
Your 'cron' entry should look like:
00,10,20,30,40,50 * * * * /ho
I personally use SSH (running as a server on the Unix/Linux system running
MySQL, and which is now included in the RedHat 7 release series) which is
configured to accept only 'ranges' of IP address (subnets that my dialup
ISP might assign me, like 207.25.33.* 207.25.34.*).That should
prett
Just a note. If you're requesting "telnet" or "ftp" access to your
'colocated' systems, the issue isn't only with your 'ISP'. I just got
finished assisting another MySQL user in rebuilding his system (for the 2nd or
3rd time) who has been using "telnet" and "ftp" to remotely administer his
sy
That link is now:
http://www.urbanresearch.com/software/utils/urbsql/
- Original Message -
From: "j.urban" <[EMAIL PROTECTED]>
To: "Sofiane Sakhri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, April 29, 2001 9:43
Subject: Re: Is there mysql client under Windows?
> Yes,
I find it humorous that you're Email address is "perl_programmer2001", yet
you don't know how to set your PATH variable...
Type "echo $PATH" and see if "/usr/local/bin" is included in it. If so, you
can do what I usually do, which is to add 'symbolic links' from there to
programs that I want
If you're logged on as "root" on the system, you should be able to 'stop'
mysql, remove the contents of the "var" subdirectory (NOT /var), and re-run
"bin/mysql_install_db"...
(I hope I'm right...)
TWooly wrote:
> Hey I installed the MySQL pkg from http://pkg.nl.cobalt.com a couple of
> wee
"Marc S. Bragg" wrote:
> How does one redirect mysql to a data directory location different than
> the default. . . . and if possible, only for a particular database.
>
>
You can find the 'official' notes on how to relocate tables or entire
databases at:
http://www.mysql.com/doc/S/y/Symboli
"l0phthcrack" should work, since the "rocket scientists" in Redmond have still
retained the "NetBIOS" version of the password (the old "Windows for Workgroups"
version) in the SAM. So much for improved security...
(HA HA HA HA HA HA HA )
Roel Vanhout wrote:
> Do you have code on how it is
OR, you can do what I usually do, and create a 'symbolic' link from
"/usr/local/bin" to programs 'outside' of your path, that you feel are safe to
run 'automatically' (i.e. "cd /usr/local/bin; ln -s
/usr/local/mysql/bin/mysql ")
Brian Warn wrote:
> Make sure in (solaris + ksh) /etc/profile o
Unfortunately, you're using MySQL on a Microsoft product, and you've probably
run into one of those issues where Redmond decided what's best for you (changing
the 'case' of the filenames).
BUT, in both the Microsoft and UNIX realm of products, 'packaging' files (on
UNIX using 'tar' and 'gzip',
I haven't checked the manual yet, but I'd guess that the 'query' abilities of
versions "3.22.32" and "3.23.33" are slightly different
It's generally not a good idea to have different versions (or different 'revs') of
the program on the 'development' and 'production' systems... (you'll have
There's some good documentation (a lot of it in the form of 'warnings') on
security aspects of the "mysql" database.
http://mysql.com/documentation/mysql/bychapter/manual_Privilege_system.html#Privilege_system
But, here's some quick notes:
Anyone who has 'modify' permissions to the "mysql"
One thing you should do to protect your MySQL 'instance' , is have it running
on a system 'behind' your 'front line' defenses (i.e. Firewall) and not 'on
it'.
Setup MySQL to listen only on the interface that your webserver or other
'client' is communicating on (we have a 'private' network conne
Maybe they just seeing if MySQL is 'as open' as Interbase...
http://www.securityfocus.com/frames/?content=/templates/advisory.html%3Fid%3D3152
There are a lot of 'robotic probes' going on out there (most commonly looking
for FTP access).
Just 'batten down the hatches' and keep monitoring...
My company is using it for all database functions. We're an online
'collection' agency and have been using it for the past 6 months (versions
3.22.23 upgraded to 3.23.36). In comparison with Borland's
"Interbase" ("Ibase"), which I supported at the late "Money Store"
corporation for all 100 of
65 matches
Mail list logo
