If you use ProvenScaling - ask for Jeremy.
Time and time again is he a great resource and he is a great speaker at the
MySQL Users Conferences.
J.R. Bullington, CMA
From: Ewen Fortune
Sent: Friday, December 12, 2008 2:26 PM
To: bruce
Subject: Re
Use CONCAT().
SELECT CONCAT('/',your_field,'/') 'newData' FROM your_table.
Then use similar logic to do an UPDATE statement, i.e. UPDATE your_table SET
your_field = CONCAT('/',your_field,'/')
You need to first make sure that the field you are trying to update is a
VARCHAR, because as it stands
You can also try the MySQL Monitoring Service. It's a great tool that looks at
your server's health and tells you if any changes need to be made.
It's especially helpful in tuning your server variables, query cache, and index
usage. It also sends mail if you need / want it.
Hi MySQL'ers --
I run multiple HIPAA compliant databases and a lot of very secure patient
information in my MySQL databases.
However, I am a bit of a security phreak and want to go a step further and
encode the data INSIDE the database so that, in the very unlikely event that
someone can bum-r
I received the same as David. The question was:
What OS do you currently use? Please check all that apply: (page 3, question 4
or 5):
I chose Linux 2.6.x and Windows. It kept telling me that I needed to answer the
question.
I changed the answer to just Linux and it let me thru
Same here, although they have been a little less frequent
lately.
From: "B. Keith Murphy" <[EMAIL PROTECTED]>
Sent: Friday, July 06, 2007 3:50 PM
To: Michael Dykman <[EMAIL PROTECTED]>
Subject: Re: off-topi
it is a MySQL error? I would prefer to do the
rounding in ASP and not have to update other scripts giving the same
problems.
--
Dave
J.R. Bullington wrote:
> This is an ASP error, not a MySQL error.
>
> However, try doing a
>
> response.write rs("Score")
> response
This is an ASP error, not a MySQL error.
However, try doing a
response.write rs("Score")
response.flush
Then you will see why you are getting the mismatch error. It is probably the
fact that rs("Score") is not returning an integer or number of any kind (i.e.
if rs("score") is null).
HTH!
--
If you are talking about a Dual Core computer with 4 GBs of RAM
and at least 6GB of swap space, you should have no problems running it on one
computer.
MySQL is really robust and can handle quite a load, esp. on Linux. If you are
running Windows, just remember to remove all the
Olaf is right.
It is really more about query execution time, and more importantly, QUERY
OPTIMIZATION.
Depending on how you setup your keys, your table type, and what else your
server does, you should be able to run multiple queries on this table without
too much of an issue.
Ace,
I am sorry to get into this so late, but you didn't mention what version you
are running.
If you are running 5.0.1 or greater, you can use the MySQL function ROW_COUNT().
You will find that it will help you in returning the results that you need.
Here's the page in the ma
You can download the MySQL manual from their website in PDF, ZIP, and HTML
sources.
http://dev.mysql.com/doc/index.html
From: [EMAIL PROTECTED]
Sent: Monday, June 04, 2007 3:17 PM
To: mysql@lists.mysql.com
Subject: Documentation
Hello
I am going to be
MySQL GUI tools is one of the best out there, and it's specifically designed
for MySQL.
MySQL Administrator allows you to control the server.
MySQL Query Browser lets you create and edit tables, indecies, etc
MySQL Migration Tool helps you migrate from other popular RDBs to MySQL.
http://dev.mys
Here's a question that begs to be asked --
When you upgraded from 4.1 to 5.0, did you do an in-place upgrade, or mysqldump
your data and then re-import?
MySQL 5.x's query cache and table optimizers work very differently than in 4.1,
so the results you are getting are probably from 2 issues:
1)
our
application code is really the way you want to do this.
J.R.
1-Can I use Tab (\t) instead?
2- Can I insert the date this new data was added to the field?
"J.R. Bullington" <[EMAIL PROTECTED]> wrote:
CONCAT_WS() works as well, but the format is still the same. Yo
#x27;t normally see in
a textfield so that you can differentiate between the new text and the old text.
J.R.
From: sam rumaizan <[EMAIL PROTECTED]>
Sent: Friday, April 06, 2007 12:31 PM
To: [EMAIL PROTECTED]
Subject: re: append information
How Abou
Use the CONCAT() function to achieve this:
UPDATE tmpTable SET Textarea = concat(Textarea,'data you wish to add') WHERE ID
= someID
HTH!
From: sam rumaizan <[EMAIL PROTECTED]>
Sent: Thursday, April 05, 20
This may sound mundane, but why not use a subselect COUNT?
SELECT COUNT(
select concat('Test row ',currentreturnrownum()) as testdata ,
mytestdata from mytestdatatable;) FROM mytestdatatable;
(I can't test this as I don't have currentreturnrownum() and cannot
As far as I know, MySQL does not need a TZ patch (unless you
use specific/custom Time Zone information), but your OS does.
The best way to check is to run:
mysql> SHOW VARIABLES LIKE 'TIME_ZONE';
If it says SYSTEM, then you need only patch your OS. (Patching the OS is [OT]
Hi Devy --
There are a couple of issues with your query below, and hopefully we can help
you figure it out.
First off, your table and query structure are fine. However, one can ask why
not use a TINYTEXT or even a TEXT field instead of VARCHAR(255). It's all in
the memory overhead. =)
Moving
Depending on when Heikki and the InnoDB team moved the DNS
records, it could take between 24 and 48 hours to propogate throughout the
entire internet.
I also see the cyber-squatter page, but I am sure that this will resolve itself
shortly.
J.R.
---
Always being the last to input, there are lots of other
database tools out there that let you do this.
One in particular is DBTools Professional (which is what I use). You can ADO
IMPORT Excel, MS-Access, and others like FoxPro and PostgreSQL.
Another is Database Workbench, whic
I used to have this problem, but I solved it by using 'IS NOT NULL' in my
queries v. using
if rs(fld.value) <> ""
Here's something else from the MySQL manual... Don't know if this will help
or not...
***
ASP users: if you're getting empty recordset
returned when using COALESCE, add "OPTION=1638
Part of the problem is that you have a ' ' in between your REPLACE and your
(). The REPLACE function needs to have that space removed.
SELECT REPLACE(deviceID,'*','.*') FROM MY_TABLE;
Try that and see if it helps.
J.R.
-Original Message-
From: Eitan Gur [mailto:[EMAIL PROTECTED]
Sent:
The best way to do this is with code, however, here is A way to do it (I am
sure that there are more than one...)
UPDATE tbl_Name SET ZipCodes = concat('0',ZipCodes) WHERE length(ZipCodes) =
4
Of course, this will involve you changing the length() if the ZipCode has
only 3 digits.
Also, of cours
When you run the query in the Query Browser, do any of the records return a
'NULL' value?
If so, then MS's ASP engine would return an EOF because MySQL's NULL is NOT
the same as objRS(fld.name) = "".
J.R.
-Original Message-
From: Jesse [mailto:[EMAIL PROTECTED]
Sent: Monday, June 26,
The command is "mysqldump"
Here's the man file on it:
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
-Original Message-
From: Karl Larsen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 20, 2006 3:09 PM
To: mysql@lists.mysql.com
Subject: Copy database to a file
I have been r
r-returns.html>
> > #1045 - Access denied for user 'root'@'localhost' (using password: NO)
> >Open new phpMyAdmin
> > window<
> http://localhost/phpmyadmin/index.php?target=index.php&lang=en-iso-885
> 9-1&convcharset=iso-8859-1&
You can't just change the name without changing (or stating) the type.
ALTER TABLE actors CHANGE director_id actos_id varchar(96) default NULL;
J.R.
-Original Message-
From: Mark Sargent [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 07, 2006 10:10 AM
To: mysql@lists.mysql.com
Subject:
So, by using MacOS X, you are using a *nix based system.
Everything posted to this list is usually based in code (as in WebApps) or
by the MySQL command line. You need to learn how to use the command line
(terminal.app) and SQL. There are lots of books out there, including on
using and installing
As a word of advice, before posting to any list, please RTFM (Read The Fine
Manual).
You have to escape all "special characters", like apostrophes and single
quotes, with the backslash.
INSERT INTO thetable (name) VALUES ('O\'Connell');
http://dev.mysql.com/doc/refman/5.0/en/string-syntax.html
The now() function would be used in the INSERT/UPDATE statement, not the
form field.
$query = "INSERT INTO staffs (firstname, lastname, signin) VALUES
('$firstname', '$lastname', now())";
mysql_query($query) or die('Error, insert query failed');
See the change to your variable $signin. Change tha
it it, post your SQL
query and your CREATE TABLE statement so that we (the list) can test this
out for you.
J.R.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, April 24, 2006 11:42 AM
To: J.R. Bullington; mysql@lists.mysql.com
Subject: Re: mysql
There is an EDIT button on the bottom of the Query Browser. You have to
"activate" the edit feature by clicking on this. You will see that it
remains highlighted.
To edit your cells, double click on them. When finished, hit APPLY CHANGES
at the bottom. If you do not apply them, they will not commi
Select COUNT(names) 'cName' FROM tblname GROUP BY names ORDER BY cName
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html
J.R.
-Original Message-
From: jakot05 [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2006 12:37 PM
To: mysql@lists.mysql.com
Subject: Results Rank
Some people use MySQLAdministrator. Some people use mysqldump. Yet others
use scripts (as was mentioned before).
We use a combo of mysqldump and Cron (Linux)/Task Scheduler (Windows).
Using a text editor, create the mysqldump file that will push all of your
data to a SQL file.
For example:
sh
If they are pasting from Word, there is a lot of Word-proprietary XML and
formatting that is being pasted as well.
Your insert statement may be failing because:
1) Because of the XML and formatting, the statement is going beyond
the TEXT fields limit;
2) There are ' (single quotes)
Here's the skinny -- YES and NO.
NO in that it won't export directly, YES in that you have to do a little leg
work in order for it to be done.
You have 3 options -- ODBC, Code and CSV.
ODBC -- Excel has the ability to use ODBC connections to the MySQL database.
Run your MySQL query with the H
Windows or Linux??
The REPLACE() function would do it if using the Character Mapping in
Windows.
UPDATE tbl_Name SET col1 = REPLACE(col1,'"','"')
UPDATE tbl_Name SET col1 = REPLACE(col1,'"','"')
They are ALT+0147 and ALT+0148 in Windows Character Map (charmap.exe)
J.R.
-Original Message--
You need to be careful what you write. I have found that Shawn is one of the
best guys on this list. His answers are 99% right on target (1% because not
enough information was given) and can help on every version of db out there.
Don't start a flame war because your feelings were hurt. Grow up.
J
You are going to need some sort of Upload software.
For this example, we are going to use Persits.Upload for the upload manager.
<%
Set Upload = Server.CreateObject("Persits.Upload") 'need to
download ASPUpload to use this.
Upload.IgnoreNoPost = true
'ASPUpload Specific
Access MEMO is actually closer to LONGTEXT than to BLOB.
Blob stands for Binary Large OBject.
Although you can use BLOB, depending on what you are inserting, it is
recommended that you use LONGTEXT for your memo field.
J.R.
http://dev.mysql.com/doc/refman/5.0/en/blob.html
-Original Messag
My turn to chime in on this one...
I have been using ASP/MySQL on a Windows AND Linux box without any issues.
Yes, that's right, ASP, with the right 3rd party software, can even run on
Linux. (Don't ask Why??, just note that it can be done!)
As long as you create a system DSN (IMOH, the easiest w
Thanks guys!
J.R.
-Original Message-
From: JamesDR [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 27, 2005 9:21 AM
To: mysql@lists.mysql.com
Subject: Re: MSSQL-MySQL Compatibility Question
J.R. Bullington wrote:
> Hi All,
> Quick question -- I have a client who co-
Hi All,
Quick question -- I have a client who co-owns a server with me. I am
a die-hard MySQL guy, they are MSSQL. They have some proprietary
Access-frontend/MSSQL-backend financial system that they want to continue to
use (i.e. pigheaded and won't convert).
Can MS-SQL and MySQL run on th
ns, that's the place to go.
HTH,
J.R.
-Original Message-
From: Serge Goyette [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 26, 2005 11:03 AM
To: 'J.R. Bullington'; mysql@lists.mysql.com
Subject: RE: Best configuration OS WebServer
Hi
Thank you for the answer
&q
I don't want to speak out of turn, but here is the real question...
What are you more comfortable with?
If you feel that you are more comfortable with Windows, then use Windows and
Windows 2000/2003 Server.
If you want to stretch your comfort level and think outside the box, Linux
is your choi
t 3:05 PM, J.R. Bullington wrote:
> Couple of questions for you --
>
> What are you using to keep pinpoint the origin of the submitted emails?
> PING, TRACERT, WHOIS off the domain names?
>
> Are you only doing original posts, or original & replies?
> Do they need to be registe
I am not the smartest on the list, but I think this would do it for you.
UPDATE table_one t1, table_two t2 SET t1.ID = t2.ID WHERE t2.num = t1.num
AND t1.ID = 0
J.R.
-Original Message-
From: C.F. Scheidecker Antunes [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 16, 2005 1:45 PM
To: my
SELECT ID, title, date, left(content,40) FROM news ORDER BY date asc LIMIT
0,10
If you want the last 40, use right(), and if you want to choose a section,
use the mid() function.
HTH,
J.R.
-Original Message-
From: Dotan Cohen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 04, 2005 12:
Title: Security Question
Hi All --
I have been a member of this list for a while but I actually have a question that I can't answer.
MySQL v4.1.14-nt on Win2k3 Server
I've got someone who is trying to get in, but I have locked it down. Methods used include, but are not limited to:
No
ata
total 63868
drwx--2mysqlmysql
-rw-rw1mysqlmysql-bin.000
.
.
-rw-rw1mysqlmysql.err
J.R.
_
From: Johnson, Richard (NY Int) [mailto:[EMAIL PROTECTED]
Sent: Monday, September 19, 2005 11:35 AM
Check your <>.err logs located in the /data/ directory. This will
tell you why you can't start the server.
J.R.
-Original Message-
From: Johnson, Richard (NY Int) [mailto:[EMAIL PROTECTED]
Sent: Monday, September 19, 2005 10:38 AM
To: 'mysql@lists.mysql.com'
Subject: Startup Error
Hi th
values in an Excel sheet from MySQL
--- "J.R. Bullington" <[EMAIL PROTECTED]> wrote:
> Automatically populate??
>
> Not that _I_ know of, but of course there are those on this list that
> know much more than I.
>
> I do know that you can export the values into tab
Automatically populate??
Not that _I_ know of, but of course there are those on this list that know
much more than I.
I do know that you can export the values into tab delimited format and then
import it into Excel.
I think that you may want to do this via ASP or PHP. It would make life a
lot e
First glance -- It's missing a comma (,) between T1.BldgName and
T1.StreetName, Missing a period (.) in PstlAddr T1 and in PrsnAddress T2
Also, how does the system know the table names if you are putting them
first, (i.e. shouldn't it be BldgName.T1 not vice versa)?
You don't define what T1 is, u
UserID UserNameFirst_Name Last_Name
1 logmeon J.R. Bullington
Table 2 ...
ID1 UserID SitePassword
1 1 145 12345
Table 3 ...
SiteID SiteNameSiteLoc
What a great discussion thread!
Gary,
I currently use MySQL as part of a HIPAA compliant system for the
integration of web-based apps with Patient Care information.
HIPAA (Health Information Portability and Accountability Act) is a set of
standards set by the US Government to protect people's pr
Although finding a tool that will automatically transfer files from MySQL to
MS SQL format will be hard to do, both will accept txt files that have the
CREATE statements and data in SQL.
mysqldump will do this for you.
http://dev.mysql.com/doc/mysql/en/mysqldump.html
Just export the files to an
"something" = ODBC is the first thing that comes to mind.
You can set specific permissions on the ODBC and you don't have to open up
but 1 port (3306 or whatever you choose) in your proxy / firewall. Whenever
your app calls the ODBC, the connection is made and everything is happy.
Just my $.02
J.
You got exactly what the db found. An "Empty Set". You wouldn't get '0'
results because there aren't '0', it's EMPTY. It's not NULL either since
NULL is a form of non-existence.
Why were you expecting '0'?
J.R.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent:
Why not just
ALTER TABLE tbl_Foo CHANGE `ID` `CHILD_ID` <>
Since I don't know the rest of your options or what you want to change the
column to, that's just for the name change.
J.R.
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Monday, June 13, 2005 4:56 PM
To: Sc
Alter table foo drop Primary Key
Alter table add `userid` int(8) first
Alter table add Primary Key `userid`
Those 3 statements should do it. However, knowing the people on this list,
they will have a faster and better way than mine.
Don't forget about the manual as well...
http://dev.mysql.co
This is the weirdest thread I've ever seen. I've never seen so many seques
used in a thread
Agreed.
However, if you read the entire thread you have learned more in ONE location
about timestamps, default values, creating tables, other RDBMS types,
interoperability, contribution to the open
You do not need to set a default value if you want the current_timestamp.
Just leave the default option out when creating your table and the server
will do it for you.
CREATE TABLE COOKIE_REF (
cookie_ref varchar(50),
dat timestamp
);
OR
If you really want to put in a va
Have you tried to telnet into that port? Are you sure that it's open in your
firewall?
J.R.
> can somebody explain the events below:
>
> mysql is running but its not listening on 3306,...as a result clients
on remote
> machines are not able to connect..
>
smime.p7s
Description: S/MIME cryptog
Changing types to larger shouldn't be an issue. If you are changing to
smaller, of course you are going to truncate the data more.
You do not need to move the data out and then back in again unless you
really want to.
mysql> ALTER TABLE tbl_name CHANGE `col1_old_name` `col1_new_name` text
default
http://dev.mysql.com/doc/mysql/en/update.html
(B
(BSee the last line on the page. You cannot, in the most current stable
(Bversion of MySQL, SELECT from the table you are trying to UPDATE.
(B
(BJ.R.
(B
(B-Original Message-
(BFrom: $B2+9bJv(B [mailto:[EMAIL PROTECTED]
(BSent: Tue
IMO, dateTime doesn't parse now() the same way that timeStamp does. If you
use now() in a dateTime field, I have found that it doesn't always write the
time to the record, while using now() with the timestamp always does.
As far as your other questions, the indexing and increased performance, I
ha
DB Tools software will convert the file for you. You can download it at
http://dbtools.com.br/EN/index.php. All you have to do is download and
install the FreeWare version and then use the TOOLS > DAO Import Wizard.
J.R.
-Original Message-
From: David Blomstrom [mailto:[EMAIL PROTECTED]
You can change it on the command line by
mysql> set date_format = '%m-%d-%Y';
However, this may be a client-only view, as I am still trying to get the
global variable to change.
J.R.
PS - Sorry it took me so long Mark, was busy and AFK
-Original Message-
From: [EMAIL PROTECTED] [mailto
Check your DATE format in your server variables... MySQL default date format
is -MM-DD. You can change it, however until then, you have to use
update policies set renewdate = '2006/02/21' where polnumber = 'WRIM01002';
HTH,
J.R.
Hello. This is a frequently asked question. For example read
When you are running as root, but are you running as 'root'@'%' or
'root'@'localhost'? This does make a big difference. The '%' means all
network connections, which isn't secure. I would only using it as testing
purposes.
However, because your error message says that you cannot see the server, ar
1) Are you running a firewall? If so, make sure that port 3306 is open.
2) Is your MySQL server is up and running?
3) Do you have the correct permissions to connect to the server via your
mysql.hosts table?
Just some thoughts.
J.R.
-Original Message-
From: gerardo Villanueva [mailto:[E
I know that this is a little off topic, but if you want a "real" Desktop
Publishing Suite, try Adobe
(InDesign, specifically). They cannot do MailMerges like in OpenOffice or M$,
but it's much easier
to use than M$ and looks a lot more professional.
As a side note, OpenOffice, as of 1.1.2, does
Since this post, I have been able to enter a PDF file into the DB using
MySQLCC / MySQL CLI and INSERT / UPDATE statements. Now my issue is the ASP
/ aspUpload. That is not appropriate for this list.
Thanks anyways!
J.R.
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
S
Title: Inserting Other Binary data into DB (NOT IMAGES)
Good afternoon all,
I have a db (gasp!) that is holding images in a BLOB field already. I can upload and retrieve on the fly - no problems.
Now I am looking at inserting binary data such as M$Word Documents (.doc and .rtf), XML
2 things --
1) Permissions on your /mysql/data/ directory.
User mysql needs to have ownership, group mysql needs to have ownership
as well.
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> chown -R root /path/to/mysql/.
shell> chown -R mysql /path/to/mysql/data/.
shell> chgrp
Here's a little more info for you.
http://dev.mysql.com/doc/mysql/en/c.html
J.R.
-Original Message-
From: Shuva, Judith [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 25, 2005 9:08 AM
To: mysql@lists.mysql.com; J.R. Bullington
Subject: RE: Where can I download The MySQL C API?
http://dev.mysql.com/downloads/
Please note the section of Official APIs
# Application Programming Interfaces (APIs)
* Official APIs:
o The C API is included with the server, above.
J.R.
-Original Message-
From: Shuva, Judith [mailto:[EMAIL PROTECTED]
Sent: Tuesday, Jan
I have found that MySQL really doesn't like the rs.Update and rs.AddNew
features like SQL and Access
do. You are better off with the INSERT INTO (`rs.Flds`) VALUES
('objitem') or the UPDATE
SET statements with
CONPUBS.EXECUTE.
It's a pain to convert, but you will find that it writes faster t
This is really based on your OS, not MySQL. If you install MySQL on Red Hat
Linux Enterprise
Symmetric Multi-Processing (SMP), then MySQL will use both CPUs based on
instruction sets in the OS.
If you install it on WinXP or Win2k3 server, they both have SMP and can support
it. So the question
is
You need to set the OLD_PASSWORDS variable in the [MYSQLD] section of the
my.ini file.
Set-variable = old_passwords=1
It's not the ODBC, but your version of MySQL. 4.0.x uses 1 variant of password
hashing, 4.1.x uses a
more secure one that will be covered in MyODBC 3.53 (coming soon...).
J.R.
This error is caused when the server isn't started. Make sure that you start
the server first, then
log in. When you skip the HOSTS.FRM tables (by doing mysqld
--skip-grant-tables), you have to
restart the server normally to effect your changes in the mysql root user.
J.R.
-Original Message
smime.p7m
Description: S/MIME encrypted message
The reason that you cannot connect is that your MySQL server is not running.
Make sure that you have run `#/usr/local/mysql/bin/safe_mysqld &` First and
then try to run
mysqladmin. The other option is to run `#/usr/local/bin/mysqladmin status` to
check to see if the
server is running.
J.R.
---
ailto:[EMAIL PROTECTED]
Sent: Thursday, December 09, 2004 7:29 PM
To: J.R. Bullington
Subject: RE: Deleted: 0 Skipped: 0 Warnings: a lot
> Command is SHOW WARNINGS;
>
> You can run this from either the command line or from the MySQL CC SQL
> viewer.
thanks.. but from the command line
Command is SHOW WARNINGS;
You can run this from either the command line or from the MySQL CC SQL viewer.
J.R.
-Original Message-
From: kalin mintchev [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 09, 2004 6:53 PM
To: [EMAIL PROTECTED]
Subject: Deleted: 0 Skipped: 0 Warnings: a lot
, November 23, 2004 1:30 PM
To: J.R. Bullington
Subject: Re: MySQL configuring on Linux
I just did it and configured it to be a "Server" but after all when I restarted
mysqld I got this
error:
shell> Can't connect to local mysql server throught socket
'var/lib/mysql
Windows has always been more graphical. For Linux, depending on the version
that you have downloaded
(binary v. source) you have to do very little to configure it for a dedicated
server. Check out the
my.cnf files in the /support-files/ folder of your MySQL installation. Use
these as a guideline
It is my Digital Signature. Sorry that it didn't come through.
J.R.
-Original Message-
From: Ferguson, Michael [mailto:[EMAIL PROTECTED]
Sent: Friday, November 12, 2004 11:19 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: ODBC connection
Thanks. I will give it a try. I als
I have multiple databases running tables with thousands of records in them. Some of my
tables have
as many as 130 million records in them. Memberships and patient data can easily run
from thousands
to tens of thousands of records. If you are looking into things like DNA/Genome
mapping, you can
e
This is usually one of two things...
1) MySQL is not running on that machine
2) Permissions for accessing the socket via PHP.
More likely this first, but try both. Check you [HOST].err file to be sure.
J.R.
-Original Message-
From: Ferguson, Michael [mailto:[EMAIL PROTECTED]
Sent: Monda
This is usually one of two things...
1) MySQL is not running on that machine
2) Permissions for accessing the socket via PHP.
More likely this first, but try both. Check you [HOST].err file to be sure.
J.R.
-Original Message-
From: Ferguson, Michael [mailto:[EMAIL PROTECTED]
Sent: Mond
I have searched high and low and I know that you guys can help out ( as you
have helped me before ).
First, I will list table descriptions, then the problem, then I will list
the code, and finally the permissions.
The Descriptions:
2 tables - both MyISAM.
"Table 1" has 9 fields,
The easy way around this is to change your hostname to 'localhost,' install
the scripts, and then change your hostname back. There are other ways to
fixing this, but that's the fastest, I've found.
J.R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Alter table 'tablename' change column 'columnname' 'new-columnname' not null
default 0
If you have any null values in that column, you will not be able to make the
change.
J.R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.c
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
Greetings!
I have a query that I would like to refine a little more. I am using this to
send email to a directory with so many users in it that it causes my SMTP
server to clog up. I want to break up the database send module so that it
sends to only last names with the letters A - K first, do a pa
The next step is to shutdown mysqld, delete the mysql and temp tables from
your /data/ folder, and then re-run the scripts/mysql_install_db. That will
reinstall the mysql/hosts.frm, which will basically reset your root user and
password. However, it will also kill any users you have created.
To r
1 - 100 of 113 matches
Mail list logo
