>> In what way is it mangling my query?
>> and why won't the same query work from my php script.
>> I would accept this if it was just any interface but myphpadmin is supposed to be
>in line with mysql standards.
>>
>> >> update cdrequest set albumfill = "hot shots II", releasedatefill
>> >> =
Hi,
Whats the most efficient way of doing a SELECT ... IN on a field of
datatype 'SET' ?
Say you have four types of 'permissions':
- superuser
- poweruser
- normal
- guest
Each user has a field, permissions, of type SET
("superuser","poweruser","normal","gue
On Fri, Aug 10, 2001 at 02:19:21AM -0400, Julian Simpson wrote:
> In what way is it mangling my query?
> and why won't the same query work from my php script.
> I would accept this if it was just any interface but myphpadmin is supposed to be in
>line with mysql standards.
>
> >> update cdreque
try mssql2mysql; this is a VB/VBA script which can connect directly to
MySQL, thus eliminating the need of temporary files
http://www.kofler.cc/mysql/mssql2mysql.html
Best wishes,
Michael Kofler
-
Before posting, please c
In what way is it mangling my query?
and why won't the same query work from my php script.
I would accept this if it was just any interface but myphpadmin is supposed to be in
line with mysql standards.
>> update cdrequest set albumfill = "hot shots II", releasedatefill
>> = 20010708 where requ
> http://www.mysql.com/doc/U/s/User_names.html
> says:
> >>>
> MySQL encrypts passwords using a different algorithm than the one used
> during the Unix login process. See the descriptions of the PASSWORD() and
> ENCRYPT() functions in section 6.4.12 Miscellaneous Functions. Note
> that even
> Is there any way -- using either MySQL directly, or (ideally)
> using the DBI perl module -- to get a list of fields from a
> (possibly empty) table? (If the table is nonempty, you can
> just use a perl function to get the first record, and then
> apply keys() to the returned reference to get
> How is that possible? Even if you do know someone's scrambled password,
> when you connect to the MySQL server pretending to be that user, it will
> ask you for their non-scrambled password. After you type it in,
> the server will scramble it and check that the scrambled value matches
> the sc
> I'm still testing out MySQL and I'm trying to find the my.cnf
> file referred to at
> http://www.mysql.com/doc/O/p/Option_files.html
...
> but none of these files seem to exist on my machine.
...
> MySQL came pre-installed on that machine. Is it possible (or, indeed,
> normal) that the
> update cdrequest set albumfill = "hot shots II", releasedatefill
> = 20010708 where requstID = 2;
>
> i get:
> You have an error in your SQL syntax near '\"hot shots II\",
> releasedatefill = 20010708 where requstID = 2' at line 1
> I can't see any reason for the error.
Your web based inte
Is there any way -- using either MySQL directly, or (ideally) using the DBI
perl module -- to get a list of fields from a (possibly empty) table? (If
the table is nonempty, you can just use a perl function to get the first
record, and then apply keys() to the returned reference to get the fiel
On Thu, Aug 09, 2001 at 11:07:13PM -0400, Paul wrote:
> I've compiled MySQL 3.23.39 with Gemini support. The compile was error
> free although the 'make test' skipped the Gemini tests for some reason. In
> the mysqld.err log from the test directory I see this message:
>
>
On Wednesday, August 8, 2001, at 07:32 AM, Sinisa Milivojevic wrote:
>
> You are using the right compiler.
>
> What you should check are symlinks to dynamic and static versions of
> libstdc++.
>
> They should point out to the stdc++ that came with gcc 2.95.2.
>
> If that does not help, add a ful
I have just downloaded mysql-3.23.39-pc-solaris2.8-i386 and I am going
through my first installation however I don't get far as one of the first
steps is to run the script mysql_install_db however the size of this file is
zero bytes!
I have seen the messages about Sun's tar not working properly
> We are moving away from windows all together in the office I work for, one
of
> our major programs that we use here is ACT2 DB. Can someone point me in
the
> right direction of converting a ACT2 DB to MySQL.
If it's any help, I recently used the following method to successfully
convert an ACT2
The source package for mysqlgui Makefile references an
object 'edfile' which is not included in the source package
(at Aug 9, 2001). When I try to compile without that object,
I get a missing function error.
Can anyone suggest where I can find this mysterious edfile?
Thanks.
Bo Green
---
I've compiled MySQL 3.23.39 with Gemini support. The compile was error
free although the 'make test' skipped the Gemini tests for some reason. In
the mysqld.err log from the test directory I see this message:
00:18:15 MSGS_DIR tag failed -1
---
After succesfully upgrading to .39b things seemed to be running
great... However the past few days I have been having some problems with
queries not completing. This only seems to occur during higher loads and I
am not sure where to begin debuging. I was hoping someone has some ideas...
Here is t
Kat:
This can be a little tricky ... the version of ACT! you have is pretty old.
ACT! is ... TTBOMK ... based on FoxPro. Unfortunately, it doesn't support
ODBC, so it doesn't connect to other DB servers.
The only way I have been able to port the data from ACT! is to use the
built-in export data
We are moving away from windows all together in the office I work for, one of
our major programs that we use here is ACT2 DB. Can someone point me in the
right direction of converting a ACT2 DB to MySQL.
ANy help is greatly appreciated.
Kat
---
I gave the same password to user "root" and user "bhaselto", using the
statements:
UPDATE user SET Password=PASSWORD('') WHERE user='root';
UPDATE user SET Password=PASSWORD('') WHERE user='bhaselto';
(using the real password instead of '', of course). The 'user'
table
Excuse Me,
I'm a starter to Linux.
I've downloaded the MySQL-3.23.40-1 for my Linux OS.
They are in .rpm form. How can I install the software properly on Linux?
I try to follow the instructions mentioned in manual.txt but it didn't work.
Can you help me and tell my how to install it via RPM?
Thank
Run a query like this ...
USE database;
DELETE FROM tblname;
Gerald Jensen
- Original Message -
From: "Dmitry Kashlev" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 09, 2001 4:23 PM
Subject: how to erase all data in database (table)
How can I erase all data except
I installed MySQL 3.23.40 perfectly without
ploblems... but I installed MySQL for database to PHP
4.0.6 with Apache 1.3.20... but when I compile Apache,
this error ocours:
<=== src/modules
gcc -c -I./os/unix -I./include -DLINUX=22
-I/usr/local/php-4.0.6 -I/usr/local/php-4.0.6/main
-I/usr/local
http://www.mysql.com/doc/U/s/User_names.html
says:
>>>
MySQL encrypts passwords using a different algorithm than the one used
during the Unix login process. See the descriptions of the PASSWORD() and
ENCRYPT() functions in section 6.4.12 Miscellaneous Functions. Note
that even if the pass
You might want to look into what your ulimit settings are for the process
starting mysql... usually this can be done with 'ulimit -a' but check your
shells man page for more info. You could have a memory limit set for the
process and mysql is not able to use the amount of memory you specify.
Keep
In the last episode (Aug 09), Dmitry Kashlev said:
> How can I erase all data except for the fields in mysql table? I just want
> to fill all data again in the same table.
TRUNCATE TABLE tablename
or
DELETE * FROM tablename
--
Dan Nelson
[EMAIL PROTECTED]
--
DELETE FROM tablename;
where "tablename" is the name of the table.
-Bennett
At 05:23 PM 8/9/2001 -0400, Dmitry Kashlev wrote:
>How can I erase all data except for the fields in mysql table? I just want
>to fill all data again in the same table.
>
>Dmitry
>
>
>--
Hi,
I use the windows binary distribution from www.mysql.com (version 3.23.40).
When I try to use the function mysql_real_escape_string, the linker complains
about not finding it...
Solution is easy :-) Add the symbol to libmysql.def and recompile...
Cheers
Oliver
--
At 06:04 PM 8/8/2001 -0500, Paul DuBois wrote:
>At 2:50 PM -0700 8/8/01, Bennett Haselton wrote:
>>The first page of the MySQL tutorial at:
>>http://www.mysql.com/doc/C/o/Connecting-disconnecting.html
>>
>>says that when you connect to the MySQL server, it authenticates you
>>based on a username
I'm still testing out MySQL and I'm trying to find the my.cnf file referred
to at
http://www.mysql.com/doc/O/p/Option_files.html
The page says to look in:
/etc/my.cnf
DATADIR/my.cnf
defaults-extra-file (The file specified with --defaults-extra-file=# )
~/.my.cnf
but none of these files
How can I erase all data except for the fields in mysql table? I just want
to fill all data again in the same table.
Dmitry
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql
Thanks Schajee,
Did you let Access make an SQL-script to build your tables ?
You could then use such scripts in mySQL to produce a copy of the
database.
And what would you be using for the import of the data ?
cheers,
bart
> -Oorspronkelijk bericht-
> Van: Schajee Achmad [mailto:[E
I have a table 'cdrequest' it has columns 'albumfill' and 'releasedatefill' among
others
when i do the following query with myphpadmin
update cdrequest set albumfill = "hot shots II", releasedatefill = 20010708 where
requstID = 2;
i get:
You have an error in your SQL syntax near '\"hot sh
I installed MySQL 3.23.40 perfectly without
ploblems... but I installed MySQL for database to PHP
4.0.6 with Apache 1.3.20... but when I compile Apache,
this error ocours:
<=== src/modules
gcc -c -I./os/unix -I./include -DLINUX=22
-I/usr/local/php-4.0.6 -I/usr/local/php-4.0.6/main
-I/usr/local
Hello,
I run the install of mysql on RedHat 7.0 via RPM
successfully. But when I try /usr/bin/safe_mysqld
--user=mysql & or with whatever other option, I've the
message:
"Starting mysql daemon with databases from
/var/lib/mysql 010809 20;59:28 mysqld ended"
and when I try mysql -u root or another
I was wondering if there's a way to "condense" results given by a query.
What I'm looking at is a situation where the following query will give
me a number of rows with all but 1 column the same. I'd like to
concatenate that one column (with a user specified string) so that I
don't have to break
Philip,
InnoDB does not give an exact number of rows
to the query analyzer. A problem is that
in a multiversioned database different transactions
will see a different number of rows in the table,
and a single count of rows cannot be kept.
It is an eternal problem in query optimization.
Errors in
mysql.cc, line 1187: [__1cVbuild_completion_hash6Fbb_v_]: OPT: Unknown
linkage type in dependency graph
1 fatal error
Ideas?
Thanks
Jeff Tanner
Seattle, WA
-
Before posting, please check:
http://www.mysql.com/manual.php
[EMAIL PROTECTED] wrote:
>> Description:
>
>
>
> I'm new to MySQL, and am porting an application from msql. Apologies
> in advance for blatant ignorance on my part.
>
> Apparantly the code that increments the counter on whether
> a table has been modified is br
Hi,
Has anybody tried to concert a UNIFY database into a mySQL database? Has anybody even
heard of UNIFY?
Tim
We are looking for a solution to backing up a remote database, without using
mysqldump, and replication seemed to offer the solution required.
I set up the master/slave configurations on both the master and the slave
exactly the way it was shown in the MySQL documentation (4.10.3 How To Set
Up Re
That means the server does not have permission to read the file.
James E. Hicks III wrote:
> What exactly does this error mean?
>
> mysqlimport: Error: Can't get stat of '/home/jameshicks/NONSTOCK' (Errcode: 13),
> when using table: NONSTOCK
>
> James
>
>
> mysql
>
>
>
My suggestion would be to chown the database files to the same ownership of the mysqld
daemon. This should solve your persmission issues.
-Original Message-
From:Adam Douglas [EMAIL PROTECTED]
Sent:Thu, 9 Aug 2001 10:11:44 -0600
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Su
Hi there,
I am trying to optimise MySQL for use on a machine with:
Linux 2.4.7-ac9 (only kernel to work with the disk controller)
Dual Pentium III 1000 MHz
4096 MB memory
RAID-1 Mirror over two 76GB 7200 RPM UDMA disks
Reiserfs partition for MySQL
As a reference point, I am running t
Hi
i think this isnt a purely mysql specific question but surely related. I
have a stick bit set on the /tmp directory(Solaris) where the socket file
resides.But there is no protection on the file because ppl apart from the
owner of the file can delete the file..
Sachin
--
> So how can I log all the queries. Can I define a log (not binary log) file
> in my.cnf using for instance "log=filename" in the "mysqld" section ?
> Do I have to disable "log-binary" to use normal log ?
This is my startup:
/usr/bin/safe_mysqld \
--log=/var/log/mysql/query_log
-
Is the freebsd-elf mysql binary available at mysql.com compatible with
BSD/OS (bsdi) 4.1? If not, is there a place to download this
binary...or am I stuck with building it myself?
Thanks,
David
-
Before posting, please check
Is there a way to have SELECT return sets for rows that were grouped
together? So if I had a table like:
Table:
ID DATA
1a
1b
2X
2Y
310
320
I want to do something like this:
SELECT MAKE_SET(-1,DATA) as LIST
FROM Table
GROU
"Tadej Guzej" <[EMAIL PROTECTED]> wrote:
> select year(dDate), month(dDate), avg(zPrice), sum(zPrice)
> ... from tmp group by year(dDate), month(dDate);
>
> Is there a way to do this without using a temporary table?
You can use a join.
SELECT *
FROM table1, table2, table3
WHERE month(dDate)=8
AN
On 2001 Aug 09, Jeff Tanner <[EMAIL PROTECTED]> wrote:
> I have downloaded http://www.mysql.com/downloads/mysql-3.23.html Sun Solaris
> (Sparc) [sun-solaris2.7-sparc] to a Sun Solaris x86 machine.
>
> Mr. Milivojevic, would not the binaries Sun Solaris (Sparc) be not
> compatible for Sun Solaris
> Is there a way to put the results of a SELECT into a table without going
> through an export file? For example, something like
> SELECT * FROM table_1 WHERE condition INTO table_2
You can CREATE a table with the new data:
CREATE table_2 SELECT * from table_1
You can also INSERT or RE
mysql.cc, line 1187: [__1cVbuild_completion_hash6Fbb_v_]: OPT: Unknown
linkage type in dependency graph
1 fatal error
Ideas?
Thanks
Jeff Tanner
Seattle, WA
-
Before posting, please check:
http://www.mysql.com/manual.php
Ok but I've have chmod 777 on a couple of tables and I still receive table
in read only message. Plus I was under the understanding that you only need
say 700 because the mysql daemon it self would be modifying the files
directly and not the client using MySQL.
> -Original Message-
> From
Thank you all for your help!!!
The problem was set_time_limit(0);
Thank YOU ALL!
-Original Message-
From: Werner Stuerenburg [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 08, 2001 4:20 PM
To: Jason Radley
Cc: [EMAIL PROTECTED]
Subject: Re: mysql-php mailing list
Jason Radley schr
That sounds more accurate to me, but I still seem to be getting table is
read only error messages when trying to do updates/grants (haven't tried
inserts). I'm lost as to why it's in read only mode.
> -Original Message-
> From: Stefan Hinz [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, Aug
Alright, but what if I do not have a ld.so.conf file? Do I just create one
in /etc/?
> -Original Message-
> From: Gerald Clark [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 08, 2001 8:26 AM
> To: Adam Douglas
> Cc: Mysql@Lists. Mysql. Com (E-mail)
> Subject: Re: Bad path to ibpthre
Hi,
I have a select statement and want to add a Percent sign to the output of one
expression. Do I have to use Concat-function or is there another way (for only one
character)?
Best Regards
Bernhard
p.S. Since this is no spam I include the words database, MySQL, query and table
PhpMyAdmin writes : 3.23.40-log
Why -log, don't know ?...
Le jeu, 09 aoû 2001, vous avez écrit :
> What version of Mysql is it?
>
> > -Opprinnelig melding-
> > Fra: Patrice Garbe [mailto:[EMAIL PROTECTED]]
> > Sendt: 9. august 2001 19:45
> > Til: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > E
You need to download the MySQL-4.0 source and compile for
embedded-server. This is a library that you link your programs to.
It is used for small devices, like what we are doing here.
I haven't found any docs on it yet, but the header files give plenty or
explaination.
Hope that helped
Brian A
I have downloaded http://www.mysql.com/downloads/mysql-3.23.html Sun Solaris
(Sparc) [sun-solaris2.7-sparc] to a Sun Solaris x86 machine.
Mr. Milivojevic, would not the binaries Sun Solaris (Sparc) be not
compatible for Sun Solaris (x86)?
Mr. Smith, after building on a Sun Solaris x86 machine,
INSERT INTO table_2 SELECT * FROM table_1 WHERE condition
or
CREATE TABLE table_2 SELECT * FROM table_1 WHERE condition
if your table_2 is not yet created
Regards,
Tadej
- Original Message -
From: "Eldon Ziegler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 09, 2
I've been reapplying transactions to my aforementioned screwed up database.
It seems however, that the binary transaction log doesn't quite work
properly
with user variables (with MySQL 3.23.38). I have this entry from the log:
insert into Projects (ParentID, Name, LongDesc) values (@customer, "
I have 3 tables that have all fieds the same (name, length, indexes...)
The only difference is that data is stored by year(1999 in table1999, 2000 in
table2000, 2001 in table2001)
I don't want to merge them because each contains about 15,000,000 records and the
index would'nt fit into memmory...
Normally the size can be 2G, 4G or more...
You can check the maximum table size for a table with the myisamchk -dv
table_name or table_file if It doesn't work.
You should have run myisamchk or mysqlcheck (whick worked better for me)
to check your table.
Le jeu, 09 aoû 2001, vous avez écrit :
> H
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Freakin' Spam filter!!!
- -- Forwarded Message --
Subject: Re: Fwd: Re: Embedding MySQL in an application
Date: 9 Aug 2001 14:07:44 -
From: [EMAIL PROTECTED]
To: "Shawn P. Garbett" <[EMAIL PROTECTED]>
Your message cannot be po
Is there a way to put the results of a SELECT into a table without going
through an export file? For example, something like
SELECT * FROM table_1 WHERE condition INTO table_2
Eldon Ziegler
ProAtion Systems
[EMAIL PROTECTED]
http://www.proation.com
From: "Shawn P. Garbett" <[EMAIL PROTECTED]>
Sent: Thursday, August 09, 2001 3:07 PM
Subject: Fwd: Re: Embedding MySQL in an application
> The real point is, that a user can take the product out of shrink rap,
> install it, run the program and never fiddle one iota with installation of
> MySQL o
Dear Carl,
> What I want to-do is create a select statement that lets me select all
> the contacts from the contacts table that have followed link 1 and
link
> 2. I'm finding this hard without subselects.
Maybe I miss out on something, but I would do it like this:
SELECT * FROM contact INNER JO
Dear Shawn,
try PHP (www.php.net).
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
- Original Message -
From: "Shawn P
I've got a table with roughly 1 rows that's being joined with
several other tables Ten-thousand rows isn't a whole lot, but it makes
a difference. With MyISAM, the query is optimized perfectly, exactly
how I would expect it to be optimized given our indexing scheme, but
when I switch the tab
Dear Jean-Luc,
check this part of the manual:
http://www.mysql.com/doc/m/y/mysql_install_db.html
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax:
From: "sachin shetty" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 09, 2001 2:56 PM
Subject: Encrypt Database data
> Is there a way to encrypt database data and to let only one user decrypt
> when server and client runs on the same machine? I am aware of the fact
> that
Hello,
I have a mysql db that contains a table to track visitors, Visitor
information is stored at the beginning of each page. The problem that I am
having is that a few days ago the pages just stopped loading and I had to
dump, drop and recreate the table with nothing in it to get the site g
perl script
At 08:50 AM 8/9/01 -0400, Michael T. Babcock wrote:
>I would like to dump all sql transactions from a binary transaction log
>for a specific table after a specific timestamp. I can run mysqlbinlog
>and delete all the queries up to the point of the correct timestamp, then
>try to filt
>> I have been told it is possible to embed MySQL in an application such that
>> the user never knows a database is running underneath the app. Where can I
>> find more information about doing this?
>That's simple - as you write the application, keep the user interface and
>database totally seper
Documentation for any programming language that supports / has an interface
to / uses MySQL.
Try PHP (www.php.net), Perl (http://www-cgi.cs.cmu.edu/cgi-bin/perl-man), or
one of the many others.
Regards,
Sebastiaan J.A. Kamp
- Original Message -
From: "Shawn P. Garbett" <[EMAIL PROTECTED
Hi,
Thanks for the feedback on my earlier problem. I have come up with a
query:
SELECT *, count(contact_id) AS theCount
FROM eventlog
LEFT JOIN contacts ON contacts._id = eventlog.contact_id
WHERE TYPE = 'CLICK' AND link_id IN (1,2)
GROUP BY contact_id
HAVING theCount = 2
Thing is it takes f
You could be more specific:
Try specifying your programming language and operating system at least.
- Original Message -
From: "Shawn P. Garbett" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 09, 2001 2:43 PM
Subject: Embedding MySQL in an application
> I have been
Hello
Is there a way to encrypt database data and to let only one user decrypt
when server and client runs on the same machine? I am aware of the fact
that this is not fool proof scecurity as the decryption happens in the
memory and not hard to steal..but i guess its for a short time and would
>Description:
I'm new to MySQL, and am porting an application from msql. Apologies
in advance for blatant ignorance on my part.
Apparantly the code that increments the counter on whether
a table has been modified is broken. myisamchk reports that:
I have been told it is possible to embed MySQL in an application such that
the user never knows a database is running underneath the app. Where can I
find more information about doing this?
--
Shawn P. Garbett <[EMAIL PROTECTED]>
See http://www.garbett.org/public-key for my PGP key
--
> > The small problem in mysql is it does not check if parameter is
> > correct in configure script - this produced the problem...
> > Peter mailto:[EMAIL PROTECTED]
Yes, I don't know of any clear way of handling this with
autoconf. Basically, if your option starts wi
From: "Joel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 09, 2001 3:01 AM
Subject: Date calculations with php and mysql
> How do I find the elapsed time on a timestamp field?
SELECT NOW() - field AS elapsed FROM table?
Alex
--
Alex Page, IT Department, Solid State Logic
I would like to dump all sql transactions from a binary transaction log
for a specific table after a specific timestamp. I can run mysqlbinlog
and delete all the queries up to the point of the correct timestamp, then
try to filter out the lines for other databases and tables, but a more
automa
> 1. Please explain the above in detail.
It depends on the type of table you're using. If you're using a table type
that only supports table-level locking, then each transaction is isolated by
being suspended until the previous transaction is done. This is slower
if you do a lot of longer trans
Looks to me like a permissions problem. If you were manipulating the
MYSQL files as root or if you copied or moved them, this could happen.
Look at the permissions on a "working" machine and match those on this
machine. The permissions need to allow changes, but too permissive
permissions will
What you are trying to perform is doable with InnoDB table handler.
Unlike BDB, InnoDB has multi-versioning and consistent reads.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime
Jeff Tanner writes:
> I am looking within http://www.mysql.com/downloads/mysql-3.23.html for MySQL
> server for Sun Solaris i386?
> Is MySQL server for Sun Solaris Sparc build-able on Sun Solaris i386?
>
> Thanks
>
> Jeff Tanner
> Viathan
> Seattle, WA
>
Hi!
Either build it from source or do
> As far as I know, there'll be no other solution than recovering from
backup.
For the old data, that is quite alright -- what I'm trying to figure out now
is how to selectively restore information out of my (very large) binary
database transaction log file. (Anyone have tools to this effect???)
Harro Verkouter writes:
>
> Hi Michael,
> Ok. So I gave it another try. I untarred the source distro into a new
> directory and ran the configure command above (only different prefix).
> Made absolutely no difference whatsoever: still a gazillion+-1 errors
> :). Below I have a snapshot of the kin
No. The data has to be moved from MSSQL to MySQL some way, and that will be
either an export or a copy. AFAIK, there is no way for the two RDBMS's to
communicate directly with each other ... you need some sort of intermediary.
And before any data can be moved, the table schema must be created on b
Hello,
I tried with unbuffered queries and It doesn't solve the problem at all
I have an weird error performing "select id from categories where name =
'Hifi'".
The error is now : '0 : ' (nothing).
There's an error but it is not defined ?!?
Note that only the crashing query is unbuffer
Patrice Garbe schrieb am Donnerstag, 9. August 2001, 14:20:04:
> Then It is not a memory problem for "ini_set()" didn't work.
> It always crashes at the same point.
> Mysql doc says :
> ERROR 2008: MySQL client ran out of memory
> note that the error refers to the MySQL client mysql. The reas
Then It is not a memory problem for "ini_set()" didn't work.
It always crashes at the same point.
Mysql doc says :
ERROR 2008: MySQL client ran out of memory
note that the error refers to the MySQL client mysql. The reason for this
error is simply that the client does not have enough memory to s
- Original Message -
From: "shiuwaitai" <[EMAIL PROTECTED]>
To: "SDiZ Cheng " <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, August 09, 2001 1:08 PM
Subject: RE:Re: Localization..
>
> Hi,
>
> try to use "varchar" or "varchar binary" instead.
> they work fine in my applicati
Hi,
I'm a bit stuck at the moment with a select query. I have 2 tables a
contact table and an events table. They are joined together by contact
id.
The data is stored in the events table like this:
eventid link id contact id
1 1 1 *
If it is a memory problem, try for example
ini_set("memory_limit", "16M");
in your script. Otherwise, it may be a loop that keeps allocating
memory until it crahes. It this is the case, you won't get it
through allocating more memory.
Patrice Garbe schrieb am Donnerstag, 9. August 2001, 12:43:
Halo,
I'm trying to install MySQL on a RedHat 7.0 (RPM). When I run
mysql_install_db, I get the message that the grant tables has been created.
I can fint it in /var/lib/mysql. Then when I run safe_mysqld --user=mysql &
I get a error Can't find file 'host.frm' but the are in this path.
If I can
Hi Michael,
Michael Widenius wrote:
> Between the different configure attemtns, did you do 'rm config.cache'?
>
> If not, then there is a big change that the old content of
> config.cache from the first build could have affected the later
> builds.
I got an email from Timothy Smith yesterday s
1 - 100 of 107 matches
Mail list logo
