Dear MySQL Users,
MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:
- In-Memory storage - Real-time performance (with optional
checkpointing to disk)
- Transparent Auto-Sharding - Read & write scalability
- Active-Active/Multi-Master geogr
Dear MySQL Users,
MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:
- In-Memory storage - Real-time performance (with optional
checkpointing to disk)
- Transparent Auto-Sharding - Read & write scalability
- Active-Active/Multi-Master geogr
Dear MySQL Users,
MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:
- In-Memory storage - Real-time performance (with optional
checkpointing to disk)
- Transparent Auto-Sharding - Read & write scalability
- Active-Active/Multi-Master geogr
Dear MySQL Users,
MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:
- In-Memory storage - Real-time performance (with optional
checkpointing to disk)
- Transparent Auto-Sharding - Read & write scalability
- Active-Active/Multi-Master geogr
Dear MySQL Users,
MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:
- In-Memory storage - Real-time performance (with optional
checkpointing to disk)
- Transparent Auto-Sharding - Read & write scalability
- Active-Active/Multi-Master geo
Dear MySQL Users,
MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:
- In-Memory storage - Real-time performance (with optional
checkpointing to disk)
- Transparent Auto-Sharding - Read & write scalability
- Active-Active/Multi-Master geogr
Dear MySQL users,
MySQL Connector/Net 8.0.11 is the first general availability release of
MySQL Connector/Net to add support for the new X DevAPI. The X DevAPI
enables application developers to write code that combines the strengths
of the relational and document models using a modern, NoSQL-like
Kind Regards / Med venlig hilsen
Lars Nielsen
> - Original Message -
>> From: "Lars Nielsen"
>> To: "MySql"
>> Sent: Tuesday, 23 January, 2018 23:19:29
>> Subject: Re: Examples of savepoints and transactions
>
>>> D
Den 22-01-2018 kl. 22:01 skrev shawn l.green:
Hello Lars,
On 1/21/2018 3:37 PM, Lars Nielsen wrote:
Hi,
I have a system that uses begin and commit transactions. It works
like a dream! ;)
Now I want to test it by creating test data. This how ever cannot be
rolled back. I think the solution
scenario. Are there some
good guides or tutorials out there somewhere? Any suggestions are welcome.
Best regards
Lars Nielsen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Dear MySQL Users,
MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:
- In-Memory storage - Real-time performance (with optional
checkpointing to disk)
- Transparent Auto-Sharding - Read & write scalability
- Active-Active/Multi-Master geogr
Dear MySQL Users,
MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:
- In-Memory storage - Real-time performance (with optional
checkpointing to disk)
- Transparent Auto-Sharding - Read & write scalability
- Active-Active/Multi-Master geogr
Dear MySQL Users,
MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:
- In-Memory storage - Real-time performance (with optional
checkpointing to disk)
- Transparent Auto-Sharding - Read & write scalability
- Active-Active/Multi-Master geogr
[ This is part 2 of the announcement ]
Logging Notes
* These error-logging changes have been made:
+ The server is now more forgiving if it cannot find
the configured error-message file (specified using
the lc_messages_dir and lc_messages system
Dear MySQL users,
[Due to file size limitations, the announcement is split in 2
parts. This is part 1.]
MySQL Server 8.0.2-dmr (Milestone Release) is a new version of the world's
most popular open source database. This is the first public milestone
release of MySQL 8.0.
http://dev.mysql.com/d
ng signals to
the recipients. (Bug #22705935)
References: See also: Bug #18753341, Bug #23202735.
* CMake now detects whether a GCC 5.3.0 loop optimization
bug occurs and attempts a workaround if so. (Bug
#25253540)
On Behalf of the MySQL RE Team
Lars Tangvald
Dear MySQL users,
MySQL Connector/Node.js is a new Node.js driver for use with the X
DevAPI. This release, v1.0.6 M5, is the fourth development release of the
MySQL Connector/Node.js 1.0 series.
The X DevAPI enables application developers to write code that combines
the strengths of the relation
failed to upgrade the sys schema if a sys
database directory existed but was empty. (Bug #81352,
Bug #23249846, Bug #22875519)
On behalf of the MySQL RE Team,
Lars Tangvald
Dear MySQL Users,
MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:
- In-Memory storage - Real-time performance (with optional
checkpointing to disk)
- Transparent Auto-Sharding - Read & write scalability
- Active-Active/Multi-Master geogr
f the GCI; the generation is incremented
whenever the node process is restarted, and this value is
now used to provide a monotonically increasing sequence.
(Bug #73781, Bug #21809959)
On behalf of the MySQL Release Team,
Lars Tangvald
#x27;s Alter Table functionality did not detect
changes to fractional seconds. (Bug #19774377, Bug
#74254)
On behalf of Oracle MySQL Release Team,
Lars Tangvald
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
en/mcm-news-1-4-0.html
The user manual can be found at:
http://dev.mysql.com/doc/index-cluster.html
Your feedback is greatly appreciated!
Please report any problems you have at https://bug.oraclecorp.com/
Enjoy!
On Behalf of the MySQL/ORACLE RE Team,
Lars Tangvald
--
MySQL General Mailing Lis
ormation about this bug, see
https://github.com/paramiko/paramiko/issues/243. (Bug
#19714350, Bug #74160)
* The import and export process did not always function
with network folders. (Bug #19443451, Bug #73575)
On behalf of Oracle MySQL Release Team,
Lars Tangvald
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
ordCopyOut, the data
overran the allocated buffer space. With this fix, ClusterJ
checks the size calculated by NdbDictionary::createRecord and
uses the value for the buffer size, if it is larger than the value
ClusterJ itself calculates (Bug #20695155)
On behalf of Oracle/MySQL RE Team
Lars Tangvald
Dear MySQL users,
MySQL Connector/NET 6.7.8, a new version of the all-managed .NET driver
for MySQL has been released. This is the GA, feature complete. It is
recommended for production environments. It is appropriate for use with
MySQL server versions 5.5-5.7.
It is now available in source an
irectory, you'd more than likely
want to link with the one in the debug directory, I think, to get
useful stack traces into library code when debugging.
Lars Nilsson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
File )
>
> can you
> 1) locate MSVCRT*.dll on your %PATH%
> 2) dumpbin -exports MSVCRT*.dll
The problem is at compile/link-time not run-time dll lookup, so he'll
first need to make sure he can link. Once it links, I'd hazard a guess
it'll run ok (assuming the program i
so the symbols are resolved
> correctly? The release mode works perfect and the application runs
> fine in that way only...
The missing functions should be provided by the Visual Studio debug
runtime library. Are all source files in your own code compiled and
program linked with one, and only one
appen to use pointers for some of these instead of
putting them on the stack, the ball is back in my court again to make
sure I don't lose track of something.
This is my personal preference. YMMV.
Lars Nilsson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On Thu, Jun 7, 2012 at 3:08 AM, Simon Walter wrote:
> On 06/07/2012 12:29 PM, Lars Nilsson wrote:
>> I've been happy using SQLAPI++ (http://www.sqlapi.com/) where I work.
>> Commercial and not open source, but it's cross-platform and supports a
>> dozen or so differ
con.Commit();
Simply replace SA_Oracle_Client with SA_MySQL_Client, etc, and you'll
be working against MySQL. Only requirement is that the dll/so
libraries for each database you want to connect to are installed
properly.
Lars Nilsson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
tal sp
where sp.code = substring(lp.code, 1, length(sp.code));
or, given a particular long postal code
select sp.code from short_postal sp where sp.code = substring('W1U
8JE', 1, length(sp.code))
Indices won't be of too much help for the short_postal table, I
imagine, for this kind
not to forget that there can also be street adresses like foobarstreet 23-25
or foobarstreet 17b and so on ... so i
guess i'll have to split my addresses into 2 fields from now on (street and
number). anyway thanks for ideas and
replies! best: lars
On 7/27/07, Joerg Bruehe <[EMAIL P
hi all, is there any shorthand to extract the string part of a varchar field
only?
like when having german street addresses (e.g. foostreet 23) in a varchar
field
and i want to select the non-numeric part of it (foostreet) only?
thanks, best: lars
or that
purpose handy?
thanks: lars
or that
purpose handy?
thanks: lars
hi,
keep on going through the documentation, the answer is there :)
or here:
http://dev.mysql.com/tech-resources/articles/4.1/prepared-statements.html
lars
On 2/14/07, balaraju mandala <[EMAIL PROTECTED]> wrote:
Hello everybody,
While i am going through the MySQL documentation i
hi afan,
depending on your mysql conf you have a minimum word length. check
your config for:
ft_min_word_len
and change it to 3.
hth: lars
On 2/13/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
hi to all!
I'm trying to get some products from products table using fulltext
DATE_ADD().
lars
On 2/11/07, barz040 <[EMAIL PROTECTED]> wrote:
Hi all
I want to extract the records that aren't oldest of 1 week.
Ho can I do this in two mode?
1) when my data field is int(10) and I store record with unix time
(1171152000)
2) when my data field is a data field and
hi tsr,
where's the question? :) store the reference to the file in the
database, not the file itself.
hth: lars
On 2/11/07, tsr.offentlig <[EMAIL PROTECTED]> wrote:
Hi,
Ok, I've been searching around for information on storing images in a DB
(ok, not very original, but
SELECT foobar,
COUNT(foobar) AS NumOfFoos
FROM bar
GROUP BY foobar
HAVING ( COUNT(foobar) > 1 )
On 2/6/07, Tomás Abad Fernández <[EMAIL PROTECTED]> wrote:
Any can tell me a slq to find duplicate entries in a table?
Thanks,
Tomás
--
Lars Schwarz
Gottorpstrasse 20
26122 Oldenbu
oops, sorry, forget the last post i made. it's not related to the
group by. it should work like that from my point of view. a stripped
down version of this works for me (tried without the left join)
On 2/6/07, Lars Schwarz <[EMAIL PROTECTED]> wrote:
i suppose this to be working whe
90
2 France 6060
3 Norway 2424
etc.
I expect the RunSum for Germany 60, France 150, Norway 174 etc.
Whay am I doing wrong ? Any help is appreciated !
Regards, Cor
--
Lars Schwarz
Gottorpstrasse 20
26122 Oldenburg
T 0441 2171 354 0
F 0441 2171 354 0
M 0179 512 4628
--
Well I´m having some problems with a trigger and i don´t know how to handle
this situation.
Let´s start... well I have 2 tables (Table1 and Table2). Only fictional
tables.
CREATE TABLE `table1` (
`id` int(10) unsigned NOT NULL auto_increment,
`status` tinyint(1) unsigned NOT NULL,
PRIMARY KEY
t;>
>>
>>
>> --
>> No virus found in this incoming message.
>> Checked by AVG Free Edition.
>> Version: 7.1.411 / Virus Database: 268.17.19/663 - Release Date:
>> 2/1/2007
>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?
> [EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Lars Schwarz
Gottorpstrasse 20
26122 Oldenburg
T 0441 2171 354 0
F 0441 2171 354 0
M 0179 512 4628
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
i might have
done wrong. Has anybody a hint for me? No, the table
is not empty :) It contains about 1 rows.
thanks
--lars
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ith 3 and 6 in the table... that's what i need 3 and 6 as a result, e.g.
those
values from the list that haven't been found (are not in the table). how to
do
that? thanks: lars
) and which use the C-language interface of MySQL?
Does it work OK?
Thanks.
- --
Viele Grüße,
Lars Heidieker
[EMAIL PROTECTED]
http://paradoxon.info
-
Mystische Erklärungen.
Die mystischen Erklärungen gelten für tief;
die Wahrheit ist, dass sie noch
transaction_id
COMMIT PREPARED transaction_id
ROLLBACK PREPARED transaction_id
and it states PREPARE TRANSACTION -- prepare the current transaction
for two-phase commit
- --
Viele Grüße,
Lars Heidieker
[EMAIL PROTECTED]
http://paradoxon.info
-
Mystische
completely new algorithms like tiger and whirlpool.
Is there any possibility to do this without touching MySQL's source and
if not, are there any plans to include them?
Greets, Lars
--
"Kriterium des Wahren ist nicht seine unmittelbare
Kommunizierbarkeit an
ast ) but as soon as
I apply the "order by" it uses filesort and slows down.
I would be very happy about any hint ;)
lars
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm currently working on a little PHP-project, where I would like the
possibillety of automatically upgrading the MySQL-tables, so that users
don't have the need to drop the database, and then run the installscript
again, from a mysqldump of the original database I'm running.
What I was thinking,
rest of the
program unfortunately needs huge amounts of memory, but when it is
running, there are still several hundreds of megabyte free memory..
I would like to know, how much memory the dbase structure needs.. I
suppose, that it will not be much..
Any other idea?
Thanks,
--
Lars Wenderoth
0919 16:11:37 Got fatal error 1236: 'Binary log is not open' from master
when reading data from binary log
There shouldn't be anything wrong with the configuration, since the same
configuration works with the other binary. Has anyone else had the same
problem? Is it a bug?
Regards,
I tried that, but i dont work either.
I need to insert a way that mysql doese'nt complain when i copy some
records that have the same id (or that it just gives it an id according
to the AUTO_INCREMENT)
Thanks again
//Lars Rasmussen
-Oprindelig meddelelse-
Fra: Jay Blanchard [m
orking.
I hope anyone of you got a workaround for this problem, i did'nt find
any in the manual.
//Lars Rasmussen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
308109312 Jun 30 20:08 #sql343_2ed63d_0.MYD
-rw-rw1 mysqlmysql1024 Jun 30 18:56 #sql343_2ed63d_0.MYI
(RedHat 7.3 with rpm mysql 3.23.56-1.72)
---
Lars Andre
r would of course be "Do you really need a mysql table for
this? There are a gazillion full text indexing packages out there!". Yes,
I do need to store it in a mysql table - it's part of a much larger
database.
Thanks in advance.
Lars Nygaa
Hej all,
I have a really kinky mysql problem.
Well lets start,
I have a table that looks like this
++--+-+
| id|title |subid|
++--+-+
| 1| MAIN | 0 |
++--+-
Heyho folks,
I am sitting now for a few weeks on a tricky problem. I don't get it - maybe
anyone of you could give me a hint.
Let's say I have two tables :
Table One has a lot of information about travels, hotels, flights etc.
Table Two has an entry for each hotel and each day where I store info
but I'm not sure what to do anyway. If configure is
asked to use gcc instead, it looks for MIT Pthreads in an eternal loop.
Any suggestions are greatly appreciated.
Best regards,
Lars-Owe
-
Before posting, plea
Hi,
have you tried the mysql-server from the pkg collection of netbsd?
Lars
On Dienstag, Dezember 24, 2002, at 09:44 Uhr, Bruce Lane wrote:
Fellow MySQL'ers,
I've been trying to install MySQL ver. 3.23.54a on NetBSD 1.6 on an
i386 platform.
The difficulty I've been
L only supports one
autoextending file.
/Lars
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
mory is
tight it helps to activate priority_paging.
Search for Solaris and priority_paging.
I think the right syntax is to put a line in /etc/system like this:
set priority_paging = 1
this is usefull for pre Solaris 8 systems and never set this varibale
fo Solaris versions > 7
Lars
On
Does the memory amount used increases any further if repeating the dump
import.
If so there is a leak if not you just got fooled by the standard malloc
of solaris which wont return memory free(d) to the system but instead
the memory will be kept in a pool for the next malloc.
Lars
On
On Fri, 15 Nov 2002, Admin-Stress wrote:
> I tried --skip-networking, but then mysqld could not be started. I got this from
>google.com. Is it
> the correct way?
It's correct. Put this in your /etc/my.cnf and restart mysql.
[mysqld]
skip-netwo
gards
/Lars
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-m
dress already
in use
021113 18:28:15 Do you already have another mysqld server running on port:
3306 ?
021113 18:28:15 Aborting
/Lars
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
h
limit would also stop the auto-increase files from growing I
guess? That's the primary reason. Another reason is the normal MyISAM
datafiles, some of them are quite big also.
Thats a few reasons that makes me want to solve this on the mysql-server
level instead of at the OS level.
- lars
O
I can stop the users from filling up the
disks.
-- lars
On Thu, 31 Oct 2002, gerald_clark wrote:
> You may have a malformed join that is giving you a very large result set.
> These would be the temporary tables.
>
> Lars Andersson wrote:
>
> >Hi,
> >
> >I manage
Thanks,
Unfortunatley I think things will break if I remove the temporary files
while they still are in use =)
I want a solution that keeps the files limited in size. There must be
some settings that controll this kind of stuff.
/Lars
On Thu, 31 Oct 2002, Black, Kelly W [PCS] wrote:
> #!/
c-2.2.5-40.
Could this file-thing be related to the glibc-mysql problems?
regards
/Lars
query,sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the li
he size it would
have if it had grown to it maximum size.
/Lars
On Fri, 18 Oct 2002, Lars Andersson wrote:
> I have a question about innodb, some of my users get an error code 1114
> saying that a table on an innodb database is full.
>
> When I do a show table status i get the follow
-3.23.53a?
- lars
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe,
Hi!
This is a bug in RedHat 8.0. Also an up-to-date RedHat 7.x is affected by
this bug.
Sollution:
Start mysql with --skip-name-resolve option.
More info:
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=74943
---
Lars Andre
-Original Message-
From: Victoria Reznichenko [mailto
I wonder if anyone knows when 3.23.53a will be released? I don't need an
exact time, just if it's due today, tomorrow or next week.
Regards
/Lars
-anti-spam-workaround sql query
-
Before posting, please chec
I had the same problem with 4.0.4, I downgraded to 3.23.52 because I
thought it was something with the unstable version. Is 4.0.4 also built
against the same static glibc?
regards
/Lars
>This problem is due to the glibc used by mysql AB for building binary ...
>
>Have a look to mysq
This problems are making me a bit tired, forgot to give you information
about the systems.
MySQL-3.23.52
dual pentium 700, 800MB ram
RedHat 6.1
Kernel 2.2.19-6.2.1smp
glibc-2.1.3-27
MySQL-3.23.52-Max
dual pentium 1.4Ghz, 2 GB ram
Redhat 7.3
Kernel 2.4.18-10smp
glibc-2.2.5-40
regards
/Lars
On
on linux? or with 3.23.52 that
should cause this behaviour
- what should I do to find the error, my logs shows nothing pecuilar.
I'm currently dumping a processlist each five seconds to a file.
regards
/Lars
-
Bef
hi,
on solaris it probably a good idee to change the tmp directory from /var/tmp ->
/tmp
as /tmp is a ram disk that gives a good performance boost if tmp tables are
involved.
The sort_buffer variable the the one to look at try increasing it, as if the
result fits into
the sort buffer no tmptable
Heyho folks,
I hope I am in the correct mailing list here.
We do have a performance problem with mySQL.
In the database we have :
INSERT INTO art_xml VALUES ('0', 'english
product nr 0 and went away, and two technicians remained
with instrument and started to\r and deutsches product
nr 0 an
who answered to this question could
post it again since I'm in quite a hurry to solve this problem.
Thanks again
ps: I have subscribed correctly this time:)
Sincerely
Lars Erik Petersen
Original message:
Hi!
Does anyone know how to copy/download a mssql db ru
way I can get a mssql into fully working mysql db
by copy once a day?
In advance, thank you!
Sincerely
Lars Erik Petersen
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Have a look for binary log files in the manual these are binary log files,
needed for replication setup eg.
Lars
mysql mailing list user wrote:
> Hi,
>
> I my mysql server database directory (that is the directory that holds the
> .err and .pid files) so strange files have apeare
aintegrety.
Lars
Kathy Reyes wrote:
> I am trying to backup a table in mysql without locking my tables it this
> posible
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.
ws - should return 1 row.
#The words "database" and "tutorial" both exists in the first row only.
SELECT * FROM articles WHERE MATCH (title,body) AGAINST
('+database -tutorial');
#Returns 3 rows - should return 2 rows.
Fix:
None.
Synopsis: Boolean operators doesnt
Just copy the backup files into the database dir and the database should be
back.
Lars
At 08:22 AM 2/15/2002 -0500, Paul wrote:
>Hello mysql,
>
> I dropped an entire database but I have the frm, myd and myi files
> in a backup.
>
> What are the complete steps to resto
MySQL, float fields: Can I change from "." to ","?
/Lars
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
tries made, but nothing more)
>>
mysql error: Out of sort memory. Increase daemon sort buffer size
mysql error number: 1038
<<
thx for help,
Lars
--
---
aka Large Green Wood
I think what you see is the fact that x86systems have overtaken
workstations in some respect.
have a look at spec.org for specint (which should be most relevant for
databases)
the same is true for memory throughput (look out for streambench)
At 01:13 PM 9/6/2001 -0700, Floyd Mann wrote:
>Hello
eserving for the table names?
Hope somebody can help.
Lars Bruun Hansen
Denmark
Hi Karel!
Thanks for your suggestion. The rights are now:
srwxrwxrwx1 mysqlmysql 0 Aug 1 11:02 mysql.sock
But I still can't access mysql with linux user freymark. The eroor code is
the same.
thanks
Lars Freymark
Tel.: 0431/ 66870-0
Fax :
freymark]$ mysql -u alten -p eichen
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/m
ysql.sock' (111)
thanks
Lars Freymark
Tel.: 0431/ 66870-0
Fax : 0431/ 66870-29
e-mail: [EMAIL PROTECTED]
w
se insensitive records search.
>
> Is it's possible and how?
>
> Thanks a lot!
>
> Andis
There is no case insensitive type in MySQL as far as I know but you should be able to
do it with regular expression
lokk for them in the manual.
Lars
My 4.2 STABLE dosent get so many queries, according to mysqladmin (Queries
per second avg: 0.700) the last time it acted up. By the way, it is a dual
CPU machine. On another machine with only one CPU running exactly the same
code and relese of FreeBSD I havent seen this problem.
/Lars Andersson
I have experienced the same problems on a dual processor machine running
4.2-STABLE and mysql 3.23.36 from the ports tree.
regards,
Lars Andersson
At 16:03 2001-04-09 -0400, Andrew Schmidt wrote:
>Have you tried this under a 'stable' version of freebsd?
>
>In FreeBSD 4.
s left. It doesn't matter
> where the redirection is; it can even be before the call to mysqldump.
>
> --Pete
>
Yes, but it might be that mysqldump wants the database to dump as the last
argument
lars
>
> > mysqldump --flush-logs --add-drop-table -u root -p markloky shu
Hi,
the cammod looks wiered to me try something like
mysqldump --flush-logs --add-drop-table -u root -pmarkloky shuncheong >
/backup/shuncheong.sql
lars
"Mark Lo (3)" wrote:
> Hi,
>
>I would like to know how to backup mysql using crontab or cron jog.
>
> I h
wrong?
S.
>From: "Gary Huntress" <[EMAIL PROTECTED]>
>To: "Stefen Lars" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>Subject: Re: Selecting 3 days worth of data with an offset of 5 days from
>now()
>Date: Sat, 31 Mar 2001 09:04:48 -0500
&
Hello all
I am looking for a way to return 3 days worth of data with an offset of five
days (in the past) from today.
For example, say we had the following dates and today is 2001-03-31. First
we do:
select name, datestamp from visitor_data order by datestamp desc;
and are returned with this
1 - 100 of 108 matches
Mail list logo
