Hello,
This is an announcement to all MySQL developers. I have opened my web site
www.SQL-Scripts.com up to MySQL . This means that you can now search for
scripts for MySQl and other database system on this site.
www.SQL-Scripts.Com is targeted at becoming the number on search engine for
databas
Mark Susol | Ultimate Creative Media wrote:
On 4/15/04 11:49 PM, "Daniel Kasak" <[EMAIL PROTECTED]> wrote:
I'm currently using:
replace(replace(NoteText, '<', '<'), '>', '>') as NoteText
to replace the offending characters with HTML escape codes. Is there a
cleaner way of doing this?
Yo
On 4/15/04 11:49 PM, "Daniel Kasak" <[EMAIL PROTECTED]> wrote:
> I'm currently using:
>
> replace(replace(NoteText, '<', '<'), '>', '>') as NoteText
>
> to replace the offending characters with HTML escape codes. Is there a
> cleaner way of doing this?
You can try the php command:
htmlspecialc
On 4/15/04 11:46 PM, "Joseph A. Nagy, Jr."
<[EMAIL PROTECTED]> wrote:
> So I'm using PHP and MySQL to serve up a game and all is going well until
> today. The first problem came when for some reason the game was sending
> apache as the username to access the db (which is not what I have in the
>
Did I really ask that tough a question? Anyone?
On 4/15/04 7:38 PM, "Mark Susol | Ultimate Creative Media"
<[EMAIL PROTECTED]> wrote:
> I've found a nice shell script to use to backup my server's MySQL databases.
> https://sourceforge.net/projects/automysqlbackup/
>
> However, when I tried this
So I'm using PHP and MySQL to serve up a game and all is going well until
today. The first problem came when for some reason the game was sending
apache as the username to access the db (which is not what I have in the
dbconnect file) and output some errors. I checked the page it was
complaining a
Hi all.
Yes I know this is a little off-topic, but also a little on-topic...
I have a user who likes to use the 'less than' sign ( < ) in notes he
enters into the DB.
When I print them out to a web page, they are interpreted as an HTML
code and everything after them '<' is not printed.
I'm curr
While trying to fix some problems with the user access privileges on
mysql4.0 alpha, I run the mysql_fix_privilege_tables script.
http://dev.mysql.com/doc/mysql/en/Upgrading-grant-tables.html
As the result, I can't get to the database, even using the root login.
I tried to recover root password
Because if you want to pre-load indexes into cache,
you need to have same block size for all indexes of a
table.
--- Rhino <[EMAIL PROTECTED]> wrote:
> I don't know the answer to your question but I'm
> curious to know why you
> would want to do this.
>
> Normally, that sort of detail is handled
Paul
Because I want to use the "load index into cache..."
to pre-load the indexes into cache. But I can not use
this feature since the block size of indexes are
different (1024 vs. 2048), and the "load index into
cache.." complains about it.
Any idea?
Thanks a lot!
Haitao
--- Paul DuBois <[EM
Lorenzo,
Try this:
select P.ssn
from patientrecall_table as P
left join appointment_table as A
on P.ssn = A.ssn
and appdate between '2004-04-15' and '2004-04-30'
where P.nrd >= current_date
and A.ssn is null
Before applying the where clause, the left join will have
- a row for
Hello fellow listoers,
Long time reader first time poster. :P I just recently installed a
MySQL server to back-end a mail system (PHP webmail, SMTP, and IMAP
servers). Everything is working pretty well, but I have a reallt odd
problem I can't difure out. I've asked a few times in #Mysql on
fre
> "jim" <[EMAIL PROTECTED]> wrote:
> >
> >> Does this machine have a valid server-id? Run show variables like
> >> 'server_id' from the mysql monitor.
> >
> > Interesting. The my.cnf says "server-id = 75" but the "show_variables;"
> > command says server_id 0 (zero).
> >
> > Why would that b
At 17:34 -0700 4/15/04, Haitao Jiang wrote:
It seems to be either a hard question or stupid
question:). Is there anyway in Version 4.1.1 I can
force all the indexes to have same block size? Say
2048? If it is plain impossible without changing the
source code, please let me know.
Why do you care abo
I don't know the answer to your question but I'm curious to know why you
would want to do this.
Normally, that sort of detail is handled by the database and should not be a
consideration for any user of the database. In other words, your queries
should work regardless of whether the block sizes fo
It seems to be either a hard question or stupid
question:). Is there anyway in Version 4.1.1 I can
force all the indexes to have same block size? Say
2048? If it is plain impossible without changing the
source code, please let me know.
I really appreciate any help on this.
Thanks
HT
- Original Message -
From: "Mike T. Caskey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 15, 2004 6:06 PM
Subject: Learning curve
> Hi all!
>
> I'm wondering if anyone can help me find out how much time/training is
> needed to accomplish my task using MySQL.
>
> My
It should work if both columns are numerical. Say int, decimal, float,
double and so on.
Babs
-Ursprüngliche Nachricht-
Von: MYSQL [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 16. April 2004 01:50
An: mysql
Betreff: Query Question
Hi,
I am wondering if this is possible:
Say I have a
At 16:56 -0700 4/15/04, MYSQL wrote:
I did try it, and it doesn't work, I was looking for Ideas that will work.
Looks to me like it should work. Try this and see what you get:
SELECT Column_Count, Column_TotalCount, Column_Count > ColumnTotalCount
FROM mytable;
That'll show you what's in the colu
Hello,
Friday, April 16, 2004, 12:56:32 AM, you wrote:
M> I did try it, and it doesn't work, I was looking for Ideas that will work.
Obviously not, because that's exactly how you do it.
--
Best regards,
Richard Davey
http://www.phpcommunity.org/wiki/296.html
--
MySQL General Mailing List
Hi,
I have 2 tables.patientrecall_table
and appointment_table.The patientrecall_table used to store what is the
nextrecall date for the patient while the appointment_tablewill store
all the appointments made.Now, I'd like to get through this:"Patients
Due for Recall, but No Scheduled Appo
I did try it, and it doesn't work, I was looking for Ideas that will work.
> Hello,
>
> Friday, April 16, 2004, 12:50:21 AM, you wrote:
>
> M> Is it possible to use a query to select all rows from the table
> M> where Column_Count is greater than Column_TotalCount?
> M> Like this:
>
> M> SELEC
Just to get a general feel for interest:
Should I just whip up something quick and dirty and post to the mailing list,
or should I work up a nice page or two and put it on a web site?
Anyone else interested?
Warnring: to work up something, it might be a week or two as school is getting
really
Hello,
Friday, April 16, 2004, 12:50:21 AM, you wrote:
M> Is it possible to use a query to select all rows from the table
M> where Column_Count is greater than Column_TotalCount?
M> Like this:
M> SELECT * FROM mytable WHERE Column_Count > Column_TotalCount;
Perhaps you ought to try it before po
Hi,
I am wondering if this is possible:
Say I have a table with 2 columns, Column_Count and Column_TotalCount;
Is it possible to use a query to select all rows from the table where Column_Count is
greater than Column_TotalCount?
Like this:
SELECT * FROM mytable WHERE Column_Count > Column_Tota
At 23:51 +0200 4/15/04, Rob Schuurman wrote:
Hi,
When trying to improve system performance of my webserver, I found out that
there are 10 entries of "[mysqld]" in the Unix proces table (ps aux), even
when there are only one or two processes visible with the "mysqladmin
proceslist" command. Those e
I've found a nice shell script to use to backup my server's MySQL databases.
https://sourceforge.net/projects/automysqlbackup/
However, when I tried this earlier today it resulted in a corrupt table. Now
the table in question is one I've had issues with for other reasons, but it
has over 2 mil rec
Hi Joshua,
I would love to here more about multi-user issues (like record locking).
I searched the archives by the title and by your name with no luck. If
you don't feel like going into detail, could you point out some good
links to learn more about the subject.
Regards,
Justin Palmer
-
Try ls to see whether safe_mysqld is in the directory and the run:
Safe_mysqld &
Note! You have to be root to run the mysqld demon
HTH
Babs
-Ursprüngliche Nachricht-
Von: Don Dachner [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 15. April 2004 21:48
An: [EMAIL PROTECTED]
Betreff: co
Hi,
When trying to improve system performance of my webserver, I found out that
there are 10 entries of "[mysqld]" in the Unix proces table (ps aux), even
when there are only one or two processes visible with the "mysqladmin
proceslist" command. Those entries in the Unix proces table consume much
Mike -
You didn't indicate your department, so I'm not sure what your background is.
Your message, overall, is a bit scary, as any university that far behind
right now would be worrisome. I'm not exactly sure what you're asking for
(as you didn't ouline your requirements), but I would first t
Mike T. Caskey wrote:
Hi all!
I'm wondering if anyone can help me find out how much time/training is
needed to accomplish my task using MySQL.
My background: I'm fresh to the world of MySQL and databases in
general. I do have some fundamental knowledge in the area of
programming and database
Using mysql 3.23.53, i have a table with approx 1.000.000 records, and
only 3 columns. One of these (called 'value') is usually between 50 and
150 characters, but occasionally jumps to a current maximum of 570
characters, so I figured I had to go for the TEXT type.
now I tried to add an index o
Hi all!
I'm wondering if anyone can help me find out how much time/training is
needed to accomplish my task using MySQL.
My background: I'm fresh to the world of MySQL and databases in
general. I do have some fundamental knowledge in the area of
programming and databases, but nothing too in-d
binary 4.1 on Linux.
to start mysql, i have to be in: /usr/local/mysql
and execute:
./bin/mysql -u root mysql
If i'm in another directory, I get "command not found: trying to start mysql". Seems
to me this is a PATH issue.
I had binary 4.0 working here at one time, but I'm delete most if
Sounds to me like it doesn't the the alias name T2 but might need the full
table name.
> Hi,
>
> Can anyone give me a hint to what this error message is trying to say.
>
> Thanks,
>
> Justin Palmer
>
>
> -Original Message-
> From: Justin Palmer [mailto:[EMAIL PROTECTED]
> Sent: Thursday,
Your join syntax is incorrect. Check out:
http://dev.mysql.com/doc/mysql/en/JOIN.html
In particular, you join against an alias (t2), when you need to join on
an actual table.
On Thu, 2004-04-15 at 14:25, Justin Palmer wrote:
> Hi,
>
> Can anyone give me a hint to what this error message is
Hi,
Can anyone give me a hint to what this error message is trying to say.
Thanks,
Justin Palmer
-Original Message-
From: Justin Palmer [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 1:38 PM
To: [EMAIL PROTECTED]
Subject: FW: Error ?
The query that generated this error was
The query that generated this error was:
SELECT t1. *
FROM `wat_student_profile` AS t1, `wat_student_job` AS t2
LEFT JOIN t2 ON t1.student_id = t2.student_id
WHERE t1.cv != '' AND t1.sevis_id = '' AND t2.student_id = NULL
LIMIT 0 , 30
Regards,
Justin Palmer
-Original Message-
From:
Hi,
I get this error from a query:
#1066 - Not unique table/alias: 't2'
What does it mean? Can anyone point me to a place where I can look up
what these codes actually mean?
Any help would be great.
Regards,
Justin Palmer
--
MySQL General Mailing List
For list archives: http://lists.my
Hi,
I’m using Win98 with mysql 4.0.1-alpha-max-debug. My main
database has only InnoDB tables and, I don’t know how, some tables were
corrupted. My problem is using the CHECK statement I can find where the
corruptions are but I can’t repair them with REPAIR (error message: table
han
Hi,
Thanks. So what you are saying is if a record is not there it is
considered NULL?
Regards,
Justin Palmer
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 12:54 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: SELECT ?
Ab
Absolutely, do a left join and check for NULL values from the other
table.
SELECT t1.*
FROM t1
LEFT JOIN t2 ON t1.id=t2.id
WHERE
t2.id IS NULL
The left join retains all records in the first table regardless of
matches in the second. You then filter out those records with a null
value in a table
On Thu, Apr 15, 2004 at 03:05:01PM -0400, Wensheng Deng wrote:
> Is there some version of MySQL cluster available for downloading at the
> moment? If yes, where is it? Thanks in advance.
MySQL Cluster is currently only available in source form as part of the
MySQL 4.1 BitKeeper repository (which m
Hi,
Is it possible to select all records from one table that don't have an
entry in another table. Something like:
SELECT t1.*
FROM 'TABLE1' AS t1,
'TABLE2' AS t2
WHERE t1.cv = 1
AND t1.id != t2.id
So in this mock example there is an id in one table, but the id is not
in another t
Hi All,
Is there some version of MySQL cluster available for downloading at the
moment? If yes, where is it? Thanks in advance.
Cheers,
Wensheng
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Folks.
I've seen similar questions asked both here, and via a google search - but I
haven't found an answer which has helped yet - so heres hoping!!
I run a Linux webserver which has PHP 4 installed, and am currently
prototyping a design using MySQL 5.0-alpha on Windows 2K professional. The
tw
MySQL just announced their MySQL Cluster product. But the minimum
requirements for it include a Xeon/Itanium/Opteron CPU and a SCSI drive
with a RAID1 controller. Why is that? Seems strange.
http://www.mysql.com/products/cluster/faq.html
--
MySQL General Mailing List
For list archives: http://l
That's a lot of stuff to ignore but I managed to do so successfully
> -Ursprüngliche Nachricht-
> Von: Victor Medina [mailto:[EMAIL PROTECTED]
> Gesendet: Donnerstag, 15. April 2004 13:39
> An: [EMAIL PROTECTED] Mysql. Com
> Betreff: please ignore
>
> -BEGIN PGP SIGNED MESSAGE-
Our master suffered a power failure. When fixed we brought up its only slave
and found that it wouldn't replicate. The error log revealed that the slave
was requesting replication from an impossible position:
Slave SQL thread initialized, starting replication in log 'dbm-bin.041'
at position 11741
This appears when I attempt to open phpMyAdmin. It doesn't matter what
account I set in the config.inc.php file, I continue to get this error. How
do I change this so that another account logs in to the localhost? I
unfortunately had to reboot my server and this became the result. I notice
that I c
On Thu, 15 Apr 2004, Max Campos wrote:
> On Apr 13, 2004, at 2:01pm, Michael Stassen wrote:
>
> > You shouldn't be surprised. This is normal behavior.
> > interchangeStatus is a varchar, so
> >
> > select fileName from outDocInterchange where interchangeStatus = 91;
> >
> > requires that interc
On Apr 13, 2004, at 2:01pm, Michael Stassen wrote:
You shouldn't be surprised. This is normal behavior.
interchangeStatus is a varchar, so
select fileName from outDocInterchange where interchangeStatus = 91;
requires that interchangeStatus be converted to an int for each row so
it can be c
On Wed, 14 Apr 2004, Tim Cutts wrote:
>
> On 14 Apr 2004, at 10:57 pm, Adam Erickson wrote:
>
> > (This is probably not the best place for this post, but here goes...)
> >
> > The (soon to be released) MySQL cluster software docs use a "sample"
> > cluster node configured with Dual Xeons and 16GB
> How do I know the table is configured by InnoDB instead of normal table ?
Do a "show table status" or a "show create table name_of_my_table"
> Should I at least see some entry in the /etc/my.cnf to indicate that InnoDB
> is configured?
No, but if you don't want to use innodb you can add "skip-in
Hi Jenny,
mysql> SHOW VARIABLES LIKE '%have%';
++---+
| Variable_name | Value |
++---+
| have_bdb | YES |
| have_crypt | NO|
| have_innodb| YES |
| have_isam | YES |
| have_raid | NO|
| h
MySQL Experts:
I am new for MySQL database.
We have a 4.0.18 MySQL sit on Linux box.
I am reading on InnoDB. And having a question.
How do I know the table is configured by InnoDB instead of normal table ?
Should I at least see some entry in the /etc/my.cnf to indicate that InnoDB
is configure
Hello Everyone;
I thought I would take a chance to remind you all of the blog collection and
image gallery available at http://uc2004.vbmysql.com
We have had over 30 blog entries posted since the conference started, written by
several bloggers and encourage more to contribute. If you were not abl
You can also use pae for any one process to address 4 GB of ram on a 32 bit
system.
--
DVP
> -Original Message-
> From: Tim Cutts [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 14, 2004 2:05 PM
> To: Adam Erickson
> Cc: [EMAIL PROTECTED]
> Subject: Re: MySQL Cluster
>
>
> On 14 Apr
So I am guessing this is not a bug, and that I will have to modify the script myself?
-Original Message-
From: Luc Foisy
Sent: Monday, April 12, 2004 4:34 PM
To: Michael Stassen; MYSQL-List (E-mail)
Subject: RE: mysql error file
Michael wrote:
>mm... Have you looked in /etc/rc.d/init.d
mysql.sock only exists while the server is running.
Your package install/uninstall scripts are broken.
Phil Ewington - 43 Plc wrote:
Hi All,
I am trying to install MySQL-3.23.54-1 pkg on a RaQ4i (from pgkmaster.com),
which is something I have done on numerous occasions without problem.
However, t
I use a PERL module called Spreadsheet::WriteExcel. You can get it from
CPAN at http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-0.42/.
I generate tons of reports monthly using cron to fire off PERL scripts that
output my data as Excel spreadsheets using this module. Implementation is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, i been having problems with my mail server, just ignore this message.
- --
~ |...|
~ | _ _|Victor Medina M |
~ |\ \ \| | _ \ / \ |Linux - Java - MyS
Use phpmyadmin.
Damn good for data dump in any format you wish...
-Original Message-
From: Bart De Man [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 6:59 AM
To: [EMAIL PROTECTED]
Subject: export to csv or excel
Hi,
Do you know a good tool to export mysql tables to csv or exc
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
please ignore
- --
~ |...|
~ | _ _|Victor Medina M |
~ |\ \ \| | _ \ / \ |Linux - Java - MySQL |
~ | \ \ \ _| | |_) / _ \ |Dpto. Sistemas
"Juri Shimon" <[EMAIL PROTECTED]> wrote:
>> I was able to repeat it on 4.1.1 but your example worked fine on 4.1.2.
>
> Where I can get it?
Binaries currently are not available, but you can install it from development source
tree:
http://dev.mysql.com/doc/mysql/en/Installing_source_tree
Hi,
> 2 DBs sitting on different machines, any idea of how
> to run the query?
>
> Select a.*, b.field1 from computernam.db1.table1 a,
> computername.db2.table1 b where a.fieldx = b.fieldx
>
> where computername is host for DB.
As far as I know, you cannot.
With regards,
Martijn Tonies
Database
Here's another rotter!
I searched UseNet and read that in MySQL you cannot have a sub-select,
but I'm lost as to how to split this into two selects?
SELECT distinct p.ProjectID ,p.ProjectName FROM tbl_project AS p
INNER JOIN
(
(
(tbl_UnitType AS ut INNER JOIN tbl_RateType AS r ON ut.Rat
Hi,
2 DBs sitting on different machines, any idea of how
to run the query?
Select a.*, b.field1 from computernam.db1.table1 a,
computername.db2.table1 b where a.fieldx = b.fieldx
where computername is host for DB.
regards
__
> I was able to repeat it on 4.1.1 but your example worked fine on 4.1.2.
Where I can get it?
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
Do you know a good tool to export mysql tables to csv or excel files? It
should be able to run on a Linux system, and should be able to be scheduled
(cron job).
I worked with EMS Mysql Export on a Windows system, this worked fine, but I
can't get it to work on the Linux system.
I also tried wi
"jim" <[EMAIL PROTECTED]> wrote:
>
>> Does this machine have a valid server-id? Run show variables like
>> 'server_id' from the mysql monitor.
>
> Interesting. The my.cnf says "server-id = 75" but the "show_variables;"
> command says server_id 0 (zero).
>
> Why would that be, and could it be t
"Juri Shimon" <[EMAIL PROTECTED]> wrote:
> Hi!
> Win2000, MySql 4.1.1-alpha, cp1251
>
> select 'ÃÎÍ×ÀÐÀ' like '%ÃÎÍ×ÀÐÀ%'-> 1
> select 'ÎËÅÑß ÃÎÍ×ÀÐÀ' like '%ÃÎÍ×ÀÐÀ%'-> 0
>
>
> It's a pity 8(
>
> Hint :
> select 'ÎËÅÑß ÃÎÍ×ÀÐÀ' like '%%ÃÎÍ×ÀÐÀ%'-> 1(change leading % to %%)
>
Duh...never mind.
I found the answer buried in my old notes.
I'm building a dynamic binary since I'm using SSL.
In case anyone else has the same issue, you need
a lib/libnss_compat.so.whatever in your chroot environment.
Works like a charm.
Steve
At 09:58 PM 4/14/2004, Steve Slater wrote:
Has a
Hi All,
I am trying to install MySQL-3.23.54-1 pkg on a RaQ4i (from pgkmaster.com),
which is something I have done on numerous occasions without problem.
However, this RaQ for some reason does not have /tmp/mysql.sock installed
when the package is installed. When I uninstall the pkg, the script wa
Hi!
Win2000, MySql 4.1.1-alpha, cp1251
select 'ГОНЧАРА' like '%ГОНЧАРА%'-> 1
select 'ОЛЕСЯ ГОНЧАРА' like '%ГОНЧАРА%'-> 0
It's a pity 8(
Hint :
select 'ОЛЕСЯ ГОНЧАРА' like '%%ГОНЧАРА%'-> 1(change leading % to %%)
Variables:
character_set_system=utf8
character_set_server=cp1251
saiph <[EMAIL PROTECTED]> wrote:
>
> i'm studing foreign keys but my sql code does not react as
> would imagine when i insert inconsistent data.
>
> i.e.
>
> create database urls;
> use urls;
>
> create table caths
> (
>name varchar(7) primary key
> ) type = innodb;
>
> create table urls
>
beginner <[EMAIL PROTECTED]> wrote:
> Hi,
> i got mysql 4.0.13 on my machine. When i installed it,
> i did only basic stuff to get it running (bascilly hit
> setup).
> Now, i'm getting a little bit closer to mysql (the
> system starts to became more friendly), but i got the
> following problem:
>
"Paul Maine" <[EMAIL PROTECTED]> wrote:
> I am running MySQL version 4.0.18 on a Windows 2000 server system. If I log
> in locally as an administrator and issues a command such as "DESCRIBE TABLE
> some_table;" - everything works fine. If I come back at a later time and run
> the same command again
Hi all,
I have win2k server machine, if this machine online, i could login to MySQL
4.1.1 on RH 9 is about 1 second, but if this machine offline connection
establish in about 10 seconds, then i try connect to mysql 4.0.17 in SuSe
machine its done in about 1 second. I connect to mysql server fr
Doh! dont bother I found it in the manual
ALTER TABLE t1 CHANGE c1 c1 BLOB;
/Jonas
- Original Message -
From: "Jonas Lindén" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 15, 2004 9:46 AM
Subject: Changeing a columns type with alter
Hello list, Could anyone help me
Hello list, Could anyone help me on how I go about if I would like to change a coulmns
type from say INT to FLOAT? Should I use the ALTER command? I cant seem to find any
info on it in the manual.
Regards
/Jonas
Date: Wed, 14 Apr 2004 13:26:10 -0400
To: [EMAIL PROTECTED]
From: "Pingouin Team" <[EMAIL PROTECTED]>
Subject: mysqld_multi
Message-Id: <[EMAIL PROTECTED]>
Hi,
I need help. I have my old mysql server running in my web server and I
can't stop it for make the test of the new version (3.28 to 4.0). I
Klaus Neudecker <[EMAIL PROTECTED]> wrote:
> Hi,
> I am comparable new to mySQL, so sorry if I might bother you with a
> newby Problem:
>
> When I connect to the database via phpMyAdmin or via the mySQL Command
> Line Tool as root I have problems creating a view (root has all
> privelegs, and t
Hello,
After upgrating mysql 4.0.7 to 4.0.18/FreeBSD 4.6.2, the mysqld restarts
each time it receives a remote connect from another client machine. Here
is what is written into the log:
040415 08:51:00 mysqld started
040415 8:51:00 Warning: setrlimit returned ok, but didn't change limits.
Max
Hi,
> I am sure conversion questions are asked a lot, I need to move what is a
MS
> SQL Server database to a MySQL database, both table stuctures, data, and a
> web application with a very large number of queries.
>
> I am looking for any advice on this undertaking, things to be mindful of
and
> s
Hi,
I am comparable new to mySQL, so sorry if I might bother you with a
newby Problem:
When I connect to the database via phpMyAdmin or via the mySQL Command
Line Tool as root I have problems creating a view (root has all
privelegs, and the pure select statement works fine in the line before):
The *best* way to do this is via conversion software. I find that for table
creation and data transfer, http://dbtools.com.br has the best free tool. It
converts all your Access and SQL based databases over to MySQL without any
hitches. Really good help files and web site as well.
Intelligent Conv
I am sure conversion questions are asked a lot, I need to move what is a MS
SQL Server database to a MySQL database, both table stuctures, data, and a
web application with a very large number of queries.
I am looking for any advice on this undertaking, things to be mindful of and
such, and if anyo
89 matches
Mail list logo
