I have a database application in MS-Access running in Windows NT, that is in a network
drive, and it has about 150 users.
What i want to do, is centralize the database in a PC that would be the server, and
place the MS-Access tables in a MySQL database, and the tables would be accessed from
-Original Message-
From: Richard S. Huntrods [mailto:[EMAIL PROTECTED]]
I have database mysqldump outputs that were 15 megabytes (now 10 megs,
as I removed some report storage from the system). I have restored my
system from these dumps many, many times. I have 4 systems in use
Hi!
Windows binaries of MySQL-3.23.44 - .46 were accidentally compiled with
UNIV_SYNC_DEBUG defined in the project file. That makes some InnoDB queries
up to 10 times slower than they should be on Windows. Fixed binaries, named
3.23.46a, are now available for download at
Hello,
I would like to hear your opinions, recommendations, ideas, etc., about
the following subjects:
I have two servers. Both of them have MySQL, PHP, Apache.
The first server is used as SQL server and the second server is used as
Web sever.
The problem is that it is mission critical and very
Hello.
When I start the mysql database my load is nearly zero. After some time
e.g. 30 min the load goes up to 11-12 and sometimes up to 25. Both CPU´s
are going wild till 90% user 10% system. Normaly this system could handle
a lot of database operations.
Here are some system information:
-
Hello.
When I start the mysql database my load is nearly zero. After some time
e.g. 30 min the load goes up to 11-12 and sometimes up to 25. Both CPU´s
are going wild till 90% user 10% system. Normaly this system could handle
a lot of database operations.
Here are some system information:
-
Hi
I have a similar database on the local and remote
server. I want to syncronize the two.
Please Help
Ananth
__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
Hi.
You can use the built-in replication feature to sync a MySQL instance
on the web server (slave) with the database server (master). Then you
always have a recent snapshot of the database.
You can also use the database on the slave to make your backups.
Temporarily halt replication, make your
Hi.
On Mon, Dec 10, 2001 at 11:06:24AM +0100, [EMAIL PROTECTED] wrote:
Hello.
When I start the mysql database my load is nearly zero. After some time
e.g. 30 min the load goes up to 11-12 and sometimes up to 25. Both CPU´s
are going wild till 90% user 10% system. Normaly this system could
Hi.
On Mon, Dec 10, 2001 at 02:17:07AM -0800, [EMAIL PROTECTED] wrote:
Hi
I have a similar database on the local and remote
server. I want to syncronize the two.
Please Help
I would love to, if I knew what's the problem.
You may want to have a look at replication in the fine manual:
Hello,
I often run into the problem of trying to join several tables and select
just the most recent (or largest) item from a series of entries.
For example.
Table 1: names
Id | name
15 | George
16 | Suzy
Table 2 : scores_1
Id | score
15 | 85
15 | 60
15 | 70
15 | 95
Table 3 : scores_2
Id
Hi Benjamin.
Thank you for your fast reply. I have another two small detailed questions.
1st: Do you think, if I compile the mysql source on my own it should be
better ?
I readed, that RedHat 7 has pre-compiled the mysql with an errorous version
of
gcc. ... so I would compile it on my own.
2nd:
Hi Mike
This command executes and immediately ends:
safe_mysqld --log
[2] 855
root@linux:/var/lib/mysql Starting mysqld daemon with databases from
/var/lib/mysql
04 07:45:16 mysqld ended
This command seems to run quite nicely:
safe_mysqld --skip-grant-tables
Now the manual
Hi everybody.
Does anybody know how to rotate log files (log_bin) _correctly_ while I have
master\slave relationship has been started?
The problem is that while I try to do any of rotating procedures (by
logrotate or manual mysqladmin ... flush-logs) I loose master from slave
(Slave wrote:
Hello to all.
First, I'm sorry, but my englis is very, very bad.
My problem is the next:
I'm using Poolman to create a conecction pool in Tomcat 4 to access a
MySql database, the driver that I'm using is org.gjt.mm.mysql.Driver,
JDBC throws this exception:
java.sql.SQLException: Transaction
On Monday 10 December 2001 10:30, Benjamin Pflugmann wrote:
You may want to have a look at replication in the fine manual:
http://www.mysql.com/doc/R/e/Replication.html
A lot of info there! But it seems to apply mainly to v4. I'm not sure of
Ananth's situation, but what I want to do is have
Hi.
On Mon, Dec 10, 2001 at 11:41:34AM +0100, [EMAIL PROTECTED] wrote:
Hi Benjamin.
Thank you for your fast reply. I have another two small detailed questions.
1st: Do you think, if I compile the mysql source on my own it should be
better ?
I readed, that RedHat 7 has pre-compiled the
One of three issues:
1 - the db is not set up correctly;
2 - the user is not set up correctly;
3 - the PHP script is not calling the db properly - this could be due to
wrong syntax, misnaming of the db table, or incorrect username parameters.
You would need to post some more info, in particular
Hi. Try this one:
SELECT MAX(score) FROM scores_1, scores_2
WHERE Id = 15
Greetz
- Daniel Backhausen
-Ursprungliche Nachricht-
Von: Anatole [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 10. Dezember 2001 11:32
An: [EMAIL PROTECTED]
Betreff: SELECT QUERY Problem
Hello,
I often run
Hi.
On Mon, Dec 10, 2001 at 11:12:58AM +, [EMAIL PROTECTED] wrote:
On Monday 10 December 2001 10:30, Benjamin Pflugmann wrote:
You may want to have a look at replication in the fine manual:
http://www.mysql.com/doc/R/e/Replication.html
A lot of info there! But it seems to apply
hi all,
how can i cast a variable either from integer to varchar or varchar to
integer in mysql.
thanks in advance.
regards,
sreedhar
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi,
Table 1: names
Id | name
15 | George
16 | Suzy
Table 2 : scores_1
Id | score
15 | 85
15 | 60
15 | 70
15 | 95
Table 3 : scores_2
Id | score
15 | 50
15 | 55
15 | 60
15 | 45
What I want to end up with is a selection that would pick up George and his
highest score on score_1
On Sat, 8 Dec 2001, Admin wrote:
I was just reading an annoying article from a user who was moving from
MySql to Postgres because of stability problems and because of
problems restoring large MySql data-dumps.
. . .
I would be grateful to hear your opions and experiences, good or bad.
I
Hi. Best and simpliest way ist to use phpMyAdmin for
such changes.
Greetz
- Daniel Backhausen
-Ursprüngliche Nachricht-
Von: sreedhar [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 10. Dezember 2001 12:43
An: mysql
Betreff: is type casting available
hi all,
how can i cast a variable
Hi.
On Mon, Dec 10, 2001 at 05:13:21PM +0530, [EMAIL PROTECTED] wrote:
hi all,
how can i cast a variable either from integer to varchar or varchar to
integer in mysql.
That's not possible in the way you ask for. Values will get
automatically converted to the column type in question. In
When I try to do anythithing with MySQL, I always see
Ignoring query to other database on my screen. When I type status, the
computer prints:
All updates ignored to this database.
after Current user.
Could anybody help me ?
robertix
Can you give some more info?
Eg what is Fink, what distro are you using, how can you install if you don't
have perms for the directory, etc.
Kevin
On Saturday 08 December 2001 15:17, Espen Isaksen wrote:
I installed MySql through Fink but now that I try to start up I type
mysqld at the
Help!
I'm at a loss as to a GUI that I can run and just edit the damn data in
a grid format (there's millions of tools to modify the database
structures.)
I'm on RedHat 7.2 so KMysql isn't supported.
If anyone has found a good one, I'd love to know (similar to pgaccess is
absolutely fine -
hi Benjamin,
thanks,
here shortname is varchar and pcallid is integer. i need shortname and
pcallid as ' callno' of length 6. pcallid starts from 1 .. 999.
to get effect like for callnumber 'xxx001' i plan to add pcallid by 1000 and
pick last 3 characters and concat with shortname.
simply
Hi all,
I'm having a problem importing a dump file in Mac OSX. I created the dump
from phpMyAdmin, and tried to import it in these 2 ways with the following
results:
From mysql command line:
Mysql database_name dumped_file;
Result: ERROR 1064: You have an error in your SQL syntax near
Hi Josep
We have to be clear about definitions.
You seem to be making a couple of mistakes here:
1 - guestbook.sql is not the db, but probably a script to create the db (you
can check by opening it in a text-editor - it will probably have a CREATE
TABLE statement at the top, then the field
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
says that for some sub-queries you can create temporary tables, but I
couldn't find any examples in the tutorial that show the use of a temporary
table. Are there any?
Or, if you're feeling generous, could you just tell me how to do this
So far as I know, yes. You need to set up two different connection strings,
though, and reference those in the different queries.
Kevin
On Friday 07 December 2001 08:14, Ares Liu wrote:
Can I implement parallel queries to mySQL by using sevial query sentences
in a single PHP file? Who
I use the -lmysqlclient command line argument to gcc
under Linux. It compiles fine and everything works
great.
However, if I move the compiled binary to another
system, which doesn't have the mysql client libs
installed, when I try to start the program, I get:
error while loading shared
mySQL can't do subselects afaik
Etienne
Harlan Feinstein wrote:
Rory I want to write an efficient query that will delete all records
Rory from one table when they show up in another table (pending
Rory shipments -- shipped shipments). I can't do it with this:
mysql DELETE from
http://www.phpbuilder.com/columns/tim2705.php3
especially:
http://www.phpbuilder.com/columns/tim2705-res.php3
those aren't from the latest releases of both DB, but gives a good idea.
Someone in replies said that the mysql that dies is not normal and some
config was probably not done
Please use a more descriptive subject,
you have better chances to have replies (a lot filter out subjects
having only question newbie, etc
Etienne
Angel Gabriel wrote:
Thanks for reading this. I'm new to the whole world of linux, and MySql, but
I decided to get my hands dirty, and learn
Please use a more descriptive subject...
I don't use Solaris and therefore cannot help you at all with your
problem.
Plus a lot of users filter out subjects problem newbie question
since they are usually a lost of time to read and often not related to
one of their strong subject.
Etienne
PLEASE
can everybody use a descriptive subject?
Especially on a monday morning, I have over 250 messages, I really
appreciate to read and learn from other's problems, but when it talks
about solaris install I can't care less, I do filter subjects, but too
often they are totally unhelpful.
Is
Hi,
Bennett Haselton wrote:
--snip
select * from user left join MYTEMP on user.ID = MYTEMP.userid where
MYTEMP.userid IS NULL;
I bet that this approach will fail because you want the join to show you
records that aren't there. But it will show you something, and it will
show you more if you
Hi all,
Is there any limitation in creating full-text indexes on MyISAM tables?
Currently, I have a table like this:
CREATE TABLE IF NOT EXISTS mytable (
UId BIGINT(20) NOT NULL AUTO_INCREMENT,
Title VARCHAR(255) NOT NULL,
Field1 TEXT,
Field2 TEXT,
Field3
Hi!
On Dec 10, Al Caponi wrote:
Hi all,
Is there any limitation in creating full-text indexes on MyISAM tables?
Currently, I have a table like this:
CREATE TABLE IF NOT EXISTS mytable (
UId BIGINT(20) NOT NULL AUTO_INCREMENT,
Title VARCHAR(255) NOT NULL,
Field1 TEXT,
I knew that would get your attention. But it may become reality because I
don't seem to have the skill to solve this problem as I'm a Linux novice and
my Win2K install works perfect. It would be a shame to give up on Linux in
favor of Microsoft but it works on Microsoft.
I have run out of
Our brand new, fresh install of 3.23.46 won't let us set the password for the root
user because one seems to already be set. Even after wiping the ...mysql/data/mysql
directory clean and rerunning mysql_install_db, we still get an Enter password:
prompt when attempting to set the root user
Our brand new, fresh install of 3.23.46 won't let us set the
password for the root user because one seems to already be set.
Even after wiping the ...mysql/data/mysql directory clean and
rerunning mysql_install_db, we still get an Enter password:
prompt when attempting to set the root user
Hi Sergei!
Thanks for the reply! That was fast :)
-Original Message-
From: Sergei Golubchik [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 10, 2001 10:48 PM
To: Al Caponi
Cc: MySQL Mailing List
Subject: Re: Limitation of Full-Text indexing in MyISAM table?
Hi!
On Dec 10, Al
At 8:19 AM -0700 12/10/01, Chris Bolt wrote:
Our brand new, fresh install of 3.23.46 won't let us set the
password for the root user because one seems to already be set.
Even after wiping the ...mysql/data/mysql directory clean and
rerunning mysql_install_db, we still get an Enter password:
What version of MySQL?? - older versions ( I think around version 3.2.22 and
earlier ) you could not
run on the same system as MySQL was running and use the TCP socket (3306) -
your programs had to
use the socket file. For some API packages interfacing to MySQL - they used
the TCP socket and
On Saturday, December 8, 2001, at 12:53 PM, Arjen G. Lentz wrote:
Re-order the list of tables in the FROM, and put the
subprojectweb.subproject_name = 'shoeshine.com' bit first
after the WHERE, that will also make it clearer for you to read.
Is this just for my own personal clarity? I
Hello mysql,
Running Linux 2.4.x SMP/innodb.
This query works OK.
mysql explain SELECT cp.counter_id, tg.tbl, cs.host
- FROM counter.table_groups AS tg, counter.counterproperty AS cp, counter.servers
AS cs
- WHERE tg.tblid=cp.tblid AND tg.server=1 AND cs.SERVER_ID=tg.server limit
Hi
I've got the following SQL statement for a MySQL database:
SELECT * FROM gd_records WHERE FIND_IN_SET('$value',$field)
What I want to know is how do I replace $value with a number of the
position of the SET field? Ugh, I'll try and explain this more clearly.
I've got the following
Arjen == Arjen G Lentz [EMAIL PROTECTED] writes:
Arjen Hi,
Arjen - Original Message -
Arjen From: AJ [EMAIL PROTECTED]
Ver 11.15 Distrib 3.23.46, for pc-linux-gnu (i686)
The problem that has cropped up I have is that in all GROUP BY column
DESC
statements, the DESC is now
Hi,
I recently installed 3.23.46 Binary for HP-UX
replacing my 3.xx.42 (basically, replaced the symbolic
link /usr/local/mysql to look at the 3.23.46 untar
directory.
-- Here's a an output:
$/usr/local/mysql#su# bin/mysqladmin -u root -p
version
Enter password:
Server version
Hi!
On Dec 10, Al Caponi wrote:
Hi Sergei!
Thanks for the reply! That was fast :)
-Original Message-
From: Sergei Golubchik [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 10, 2001 10:48 PM
To: Al Caponi
Cc: MySQL Mailing List
Subject: Re: Limitation of Full-Text
Thanks, I will definitively look for that
But the blocking should be done by the mailing list, making a reply like
the one for omitting mysql or database in the message.
the message could just ask to put a more descriptive subject.
because if every user filters out topics, then the person
On Monday 10 Dec 2001 14:08, Etienne Marcotte wrote:
PLEASE
can everybody use a descriptive subject?
I've got an additional idea - how about configuring the mailing list remailer
to put something like [MySQL-General] or [MySQL-Internals] in the subject
line? For some of us who are on
If you use PHP, you can use my utility dbUtils at
http://php.sitecreative.com - it has functions for synchronizing databases.
- Jonathan
-Original Message-
From: Ananth Rajaraman [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 10, 2001 2:17 AM
To: [EMAIL PROTECTED]
Subject: Database
Gordan Bobic wrote
I've got an additional idea - how about configuring the mailing list
remailer
to put something like [MySQL-General] or [MySQL-Internals] in the subject
line? For some of us who are on multiple lists, it gets really hard to
work
out what is what without reading the whole lot.
Hi
How can I create an index of a SET field so that a FIND_IN_SET can search
for a column number rather than name?
Is this even possible in MySQL? It might seem like a bug?
Thanks.
Wiliam Stephens
Web Developer
http://www.fbagroup.co.uk
I suggest installing FoxServ, which installs a combination of Apache, PHP,
and MySQL. Does it without a hitch. Great for development systems.
- Jonathan
-Original Message-
From: Dan Wolfe [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 6:24 PM
To: [EMAIL PROTECTED]
Subject:
I think you are missing something.
From the Manual:
FIND_IN_SET(str,strlist)
Returns a value 1 to N if the string str is in the list strlist
consisting of N substrings. A string list is a string composed of
substrings separated by `,'
characters. If the first argument is a constant
Hi
Thanks for your reply.
I've got the field res_places_sl. It's a SET field that consists of the
following options:
'Wales','North','South'
I was using FIND_IN_SET('Wales',res_places_sl); to access all records that
were categorised under 'Wales' which worked great.
Now, I want to be able
If you are a beginner and are using red hat why don't use the mysql rpms.
It does everything for you.
When you compile php, be sure you have the right path for mysql
(I think that is your error in this case).
Finally, be sure you entered the user right for the connection, with the host
Hey list,
thanks to all those who gave me useful information regarding my
problem with mySQL.
I intend to upgrade my kernel from 2.4.4 to 2.4.12, and then see if
there is any change.
If not then I'll try changing mySQL for the binary version from
the site. I plan to install to
read http://www.mysql.com/doc/S/E/SET.html for the set, how it works
internally...
humm.. is that what you want? :
mysql CREATE TABLE test(
- id INT UNSIGNED AUTO_INCREMENT,
- place SET(Whales,North,South);
- PRIMARY KEY (id));
Query OK, 0 rows affected (0.00 sec)
[insert some
I recently wrote in that I've tried everything in the book to connect to
MySQL but I'm still getting the infamous socket (111) error. I've had a
few good suggestions and I think we are almost there.
Here's where I am.
With MySQLGUI trying to connect, I changed the host from localhost to
hi,
is this bug already in buglist, maybe in newer verisons of mysql is already
corrected?
if yes then please let me know please from what version.
the probmlem:
select round(9.065,2)
++
| round(9.065,2) |
++
| 9,06 |
++
why not 9,07
From :
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Fun
ctions
ROUND(X)
Returns the argument X, rounded to the nearest integer:
mysql select ROUND(-1.23);
- -1
mysql select ROUND(-1.58);
- -2
mysql select ROUND(1.58);
- 2
Note that the
The rounding rule I learnt many years ago said, rounding in 1 if
previous digit is odd but discarding it if even.
so 9.065 - 9.06, 9.055 - 9,06, ...
Attila Soki wrote:
hi,
is this bug already in buglist, maybe in newer verisons of mysql is already
corrected?
if yes then please let me
Is this MySQL mailing list available via a news group?
Won
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
That rule is usually to try and get at the end the most accurate
value, if your numbers are evenly distributed your final value will be
closer to the good one. So if your values will never have the rounding
digit odd so you'll always be discarting half the smallest digit.. at
the end of multiple
I would love to give proper credit to the individual who created this, but
alas, I cannot remember where I stumbled upon it.
When I needed to do some cleaning, I did \T from the mysql app to write to a
file... then ran the script
SELECT CONCAT('DELETE FROM post WHERE threadid = ',
My problem was the next:
I'm using Poolman to create a conecction pool in Tomcat 4 to access a
MySql database, the driver that I'm using is org.gjt.mm.mysql.Driver,
JDBC throws this exception:
java.sql.SQLException: Transaction Isolation Levels are not supported.
params:
The replication server functions perfectly, but the slaves are not updating.
A. Clausen [EMAIL PROTECTED]
- Original Message -
From: Miguel Angel Solórzano [EMAIL PROTECTED]
To: A. Clausen [EMAIL PROTECTED]; MySQL Mailing List
[EMAIL PROTECTED]
Sent: Friday, December
Had a question on Whether or not MySQL Editor supports Db2 Version 5.0.
Kumud Advani
Sears Canada Inc
Architect Council - Corporate Data WareHouse
Tel : (416) 510 - 6217
-
Before posting, please check:
Quick question for someone if they can pass along a little knowledge from
their experiences:
I am dabbling in MySQL and Apache on a Win2K box and most of it seems to
work fine. The one thing I can't figure out is that when WinMySQLAdmin
launches at startup, I am not able to use the functions of
Attila Soki wrote:
select round(9.065,2)
++
| round(9.065,2) |
++
| 9,06 |
++
why not 9,07 ??
Most C compilers today defer things like round() to the floating-point unit
on the CPU. Most CPUs these days implement IEEE754 as
maybe you can add a small value to be sure it rounds up.
select round(9.065+.001,2);
Always add 1 at the digit after the one you want to keep:)
so 9.065 can also be a variable...
Etienne
Shankar Unni wrote:
Attila Soki wrote:
select round(9.065,2)
++
|
I am new to dababases in general and have a few questions. I have been
building a database in mysql using sql commands in msdos but would like
to use Visual Basic from here on out to edit the database. After
completion of the database I need to use it for a program that will also
be editing the
[EMAIL PROTECTED] wrote:
[blabla because there is no sql in my text]
You have written the following:
Good point
well then the best is two smaller than the highest resolution you
have.
if all your data has 4 digits after the . you'll be ok with a epsilon 2
digits smaller since
Etienne Marcotte wrote:
maybe you can add a small value to be sure it rounds up.
select round(9.065+.001,2);
The rounding in 1 on odd and 0 on even is dealing only 5, to make the
round more accurate or even, as you mentioned. 6-9 always round in 1
while 1-4 always round in 0.
select
Unless I'm off my rocker, the WinMySQLAdmin program is a windows executable
and has nothing to do with Apache. When you're in it, click on the My.ini
Setup tab and enter the necessary username/password required to connect to
your MySQL installation and save that configuration. Then
From: [EMAIL PROTECTED]
I am new to dababases in general...
Learn SQL (which it sounds like you've done). It's almost always going to be the
standard tool between various database vendors and APIs.
...would like to use Visual Basic ...to edit the database.
I won't make any MickySoft vs.
Dr. Randy Frid writes:
I recently wrote in that I've tried everything in the book to connect to
MySQL but I'm still getting the infamous socket (111) error. I've had a
few good suggestions and I think we are almost there.
Here's where I am.
With MySQLGUI trying to connect, I changed the
I am new to dababases in general and have a few questions. I have been
building a database in mysql using sql commands in msdos but would like
to use Visual Basic from here on out to edit the database. After
completion of the database I need to use it for a program that will also
be editing the
Welcome to the Club!
Connecting to a mySQL database would be the same way in VB6 as MS SQL or
Access, via ODBC. You should download myODBC from mysql.com.
On Microsoft Oses it is easier to develop apps via ODBC because its like
saving you 5-10 lines of code to write. If it's a web
I need to suuply an exact number of bytes in a database dump. When using
VARCHAR(21) and only using 18 characters, how do you fill in the rest
with forced spaces?
-
Before posting, please check:
Hello,
I need to kill a thread. I've issued a command which has locked a table
(delete from table where id = 9) was the command and it is taking a
very very long time.
Now I'd like to kill that thread. However, I can't read the the thread ID
because the ID scrolls out of view in my little
try using mysqladmin with a grep command, or redirect it's output to a
file. something like this should do it.
mysqladmin -u user -p processlist | grep delete deleteprocess.out
then less the file and you will be able to scroll thru the output.
hope this helps..
--shak
Karl J. Stubsjoen
From: Jeff Small (NWCC) [EMAIL PROTECTED]
...how do you fill in the rest with forced spaces?
char pads, but you may not want to alter your database. Why do you ~have~ to have 21
bytes? Can the device you're pulling this data into be modified to handle things more
intelegently? Another
I'd pipe the process list contents to a file, then look at the file via a
text editor
eg.
\T c:\processes.txt
show processlist;
\t
Kelly
try using mysqladmin with a grep command, or redirect it's output to a
file. something like this should do it.
mysqladmin -u user -p processlist | grep
I have a 3.23.45 database running with InnoDB tables. When I do this:
create table test_default ( testint int not null default 1 );
desc test_default;
I get:
+-+-+--+-+--+---+
| Field | Type| Null | Key | Default | Extra |
I need to remove a previous version of mysql and install the newest. When
trying to remove the previous version it complains about dependencies . I
don't know what to do about it, so I end up with a successful install of the
new version. Any help would be appreciated
rpm -e mysql-3.23.36-1
You wouldn't happen to be crossing an architecture boundary, would you?
Say from a Macintosh client to a PC server, or a PC client to a Sun Server?
16777216 Decimal = 100 Hex which would make perfect sense if there was an
'endism' problem.
Philip Molter wrote:
I have a 3.23.45 database
What permissions do you need to have to issue a show slave status
command?
Thanks,
database,sql,query,table
--
Michael Eklund
System Administrator
Netmechanic, Inc.
[EMAIL PROTECTED]
http://www.netmechanic.com
I can connect to mysql with Perl when I have the perl script on the same
computer, but as soon as I move the perl script to a different machine it
won't work. I replaced localhost with the IP address of the machine on which
mysql is on, but that didn't work either.
Does anyone have an
I need to suuply an exact number of bytes in a database dump. When using VARCHAR(21)
and only using 18 characters, how do you fill in the rest with forced spaces?
Take a look at the LPAD() and RPAD() functions.
HTH
/Rob
~
Robert Alexander, Alpha Geek,
From: Dan [EMAIL PROTECTED]
I can connect... on the same computer
...different machine it won't work.
I suspect that you need to add an entry at the MySQL host for the machine that you are
connecting from. This can be done with a GRANT statement:
- Format:
grant all privileges on
I inherited a large table (50 million records) with the date stored as an
integer in the format (mmddyyy). The dates go back to the 1800's and in the
1990's so the year is either 8xx or 9xx.
I need to be able to search by partial dates. For example, some searches
need to pull every record for
try just upgrading the RPMs using rpm -ivh
--
Kelly Firkins
[EMAIL PROTECTED]
I need to remove a previous version of mysql and install the newest. When
trying to remove the previous version it complains about dependencies . I
don't know what to do about it, so I end up with a
1 - 100 of 136 matches
Mail list logo