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 ewen.fort...@gmail.com
Sent: Friday, December 12, 2008 2:26 PM
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
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
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
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-topic
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!
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.flush
Then you will see why you are getting the mismatch error. It is probably
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
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.
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
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.
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
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:
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 About CONCAT_WS()
J.R. Bullington
.
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. You still want
to add your new data to your old data.
UPDATE tmpTable SET Textarea = CONCAT_WS
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,
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
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. =)
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,
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:
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=16384
to
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 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
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
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
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
--
On 6/7/06, J.R. Bullington [EMAIL PROTECTED] wrote:
So, by using MacOS X, you are using a *nix based system.
Everything posted to this list is usually based in code
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 that
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
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 query
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:
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
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
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
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.
You are going to need some sort of Upload software.
For this example, we are going to use Persits.Upload for the upload manager.
!-- BEGIN SNIPPET --
%
Set Upload = Server.CreateObject(Persits.Upload) 'need to
download ASPUpload to use this.
Upload.IgnoreNoPost = true
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
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
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
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-owns a server
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
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
You can still connect
to be
added to the list so that we can get location information from each email.
Thanks for your feedback. Yes, I think adding a geographical dimension to
the email lists brings up interesting possibilities.
Let me know if you want to see maps of other email lists.
Claire
On Oct 24, 2005, at 3:05 PM, J.R
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:
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
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
Check your hostname.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
, 2005 11:35 AM
To: 'J.R. Bullington'
Subject: RE: Startup Error
Here are the contents of the file
050919 09:33:52 mysqld started
050919 9:33:52 [ERROR] bdb: /usr/local/mysql/data: Permission denied
050919 9:33:52 [ERROR] bdb: /usr/local/mysql/data/log.01:
Permission denied
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
and paste a tab into the replace with in
notepad, you can do it that way...
-Original Message-
From: Nick Jones [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 01, 2005 3:19 PM
To: mysql@lists.mysql.com
Subject: RE: Populate values in an Excel sheet from MySQL
--- J.R. Bullington
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,
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
First_Name Last_Name
1 logmeon J.R.Bullington
Table 2 ...
ID1 UserID SitePassword
1 1 145 12345
Table 3 ...
SiteID SiteNameSiteLoc
145 Home
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
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:
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...
Why not just
ALTER TABLE tbl_Foo CHANGE `ID` `CHILD_ID` options go here
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
snip
This is the weirdest thread I've ever seen. I've never seen so many seques
used in a thread
/snip
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
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
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
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
See the last line on the page. You cannot, in the most current stable
version of MySQL, SELECT from the table you are trying to UPDATE.
J.R.
-Original Message-
From: 黄高峰 [mailto:[EMAIL PROTECTED]
Sent:
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
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]
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.
snip
Hello. This is a frequently asked question. For example
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]
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
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,
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
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
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]
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 -r
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,
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??
Hi
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 tblname (`rs.Flds`) VALUES
('objitem') or the UPDATE
tblname SET column1=value1,column2=value2,... statements with
CONPUBS.EXECUTE.
It's a pain to
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
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...).
smime.p7m
Description: S/MIME encrypted message
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
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.
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
mintchev [mailto:[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 i get
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
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/mysql.sock'
I also checked and socket
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
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:
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:
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
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, 1
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
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:
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
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
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
1 - 100 of 113 matches
Mail list logo