Shawn & all,
Thank you for taking to time to reply.
So, to be clear, what I understand from your post is that replacing the
new build's grant/system tables with the archived ones from the previous
version, generally works fine, upgrade issues not withstanding. This is t
Reindl,
I am sorry, in my original post, I forgot to mention that the OLD box and
the NEW box are the same physical machine. I need to be able to save all
data into files on a memstick or portable disc and restore them to the newly
staged machine (with the new version of mysql).
-Grant
a new box:
Mysql 5.6.17 on freebsd 9.3 (x86/32b) call this box B.
1) How does one correctly move the users and all the permissions (grant
tables),
2) How does one move the data.
3) Assume lots of backups have been done and there is no risk of
permanently
uch free space!),
> apart from patching the munin check to deal with numbers > 2^32.
>
> To double check, look at:
>
> mysql> SHOW TABLE STATUS LIKE ' main tablespace>'\G
>
> Look at the "Data_free: " line, it is probably bigger than 2^31.
Actu
nge.
> Field Internal name TypeWarnCritInfo
> Bytes free freegauge 2147483648: 1073741824:"
>
> I don't know enough about mysql (or munin) to figure out what's going
> on. I'm using both MyISAM and InnoDB tables. Can anyone
me TypeWarnCritInfo
Bytes free freegauge 2147483648: 1073741824:"
I don't know enough about mysql (or munin) to figure out what's going
on. I'm using both MyISAM and InnoDB tables. Can anyone help me out?
- Grant
--
MySQL General Mailing List
For l
That still leaves the question, what are the actual rules/business logic by
which you want to group things and get their "abbreviations"? Are you adhering
to Royal Mail/Post Office residual selection/direct selection rules, or do you
have your own scheme? It seems like the latter ... the RM ru
> To verify that root has a password, do the following:
>
> 1) service mysql restart --skip-grant-tables
> 2) In MySQL, SELECT CONCAT('''',user,'''@''',host,'''') mysql_user,password
> from mysql.user where us
hat the mysql users have
passwords.
- Grant
>> I've got a couple security questions for you guys.
>>
>> Is there a way to verify I've set a password for mysql's root?
>>
>> I was previously running mysqld without --skip-networking until I
>>
never found an open 3306 port and I wasn't running a
firewall on that system. Does this behavior make sense to anyone?
- Grant
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
password with --password and also
>> specifying -u mysql but it still fails with error 1045. My
>> /etc/passwd file looks like there is no password for user mysql. What
>> else should I try?
>
> You should use the password for the _MySQL_ root user, which is _not_ stored
>
>> I'm running mysql-5.1.51 which is the latest marked stable in Gentoo.
>> Does this still apply?
>
> No, just 5.5.7.
What else should I try to prevent the 1045 error?
- Grant
>>>> I'm trying to run mysql_upgrade but I get:
>>>>
>
password with --password and also
>> specifying -u mysql but it still fails with error 1045. My
>> /etc/passwd file looks like there is no password for user mysql. What
>> else should I try?
>
> Is this 5.5.7? You have to run the server with --skip-grant-tables, then run
swd file looks like there is no password for user mysql. What
else should I try?
- Grant
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
- Original Message -
From: "Grant Peel"
To: "Michael Dykman"
Cc:
Sent: Sunday, July 11, 2010 9:25 PM
Subject: Re: Mysql 4 to 5
- Original Message -
From: "Michael Dykman"
To: "Grant Peel"
Cc:
Sent: Sunday, July 11, 2010 9:20 PM
- Original Message -
From: "Michael Dykman"
To: "Grant Peel"
Cc:
Sent: Sunday, July 11, 2010 9:20 PM
Subject: Re: Mysql 4 to 5
One problem you might be having is the column named 'call'.. It's a
keyword, so perhaps you might get away with backt
Hi all,
I recently migrated a script called perldesk from mysql 4 to mysql 5.
When I envoke the script from the web, I am now getting an error. I suspect its
a version syntax thing.
Here is what I see:
Couldn't execute statement: You have an error in your SQL syntax; check the
manual that co
- Original Message -
From: "Rob Wultsch"
To: "Grant Peel"
Cc:
Sent: Friday, July 02, 2010 3:57 AM
Subject: Re: Updating 4 to 5
On Thu, Jul 1, 2010 at 5:44 PM, Grant Peel wrote:
Hi all,
I have serveral servers running mysql 4, and need to update to mysql 5.
neeed to run
mysqlupgrade.
My question is, will the mysqlupgrade script update all the mysql tables,
(grant tables etc), as well as update all the users databases, or will there
be other things that need to be done?
-Grant
--
MySQL General Mailing List
For list archives: http
nilnandan,
I meant to say Mysqlupgrade :-)
Further, I can use the old mysql tables, (the mysql gant tables,
user/passwd/host tables etc) and the mysqlupgrade will update them as necessary?
-Grant
- Original Message -
From: Nilnandan Joshi
To: Grant Peel
Cc: mysql
Hi all,
I am about to move from FreeBSD 6 to FreeBSD 8. With that, the mysql server
version will be changed from 4 to 5.
I am assuming I can load all the users tables, and the mysql database (grant
tables and all) to the new server, then run mysqlupdate, and everything that
needs to be
machiel.richards wrote:
Good day guys
[snip]
. Each item in the "text" field is added in the field by entering
the country name then pressing enter and then entering the next, etc
. When exporting the data to a file (even when enclosing each field
within quotes) it still wr
Carlos Williams wrote:
On Tue, Sep 29, 2009 at 11:36 PM, mos wrote:
Why don't you just say "Drop User carlos"?
Also are you logged in as root?
In my original message to the board I demonstrated the error I get on
my server when I attempt to run the 'drop user 'carlos'@'localhost';
command. Wh
You have ten half-open connections (in SYN_SENT state), and a new connection attempt is
giving you error 10055 which is windows' way of saying it can't allocate a buffer for a
new connection. Are you running XP SP2 or SP3 or Vista? Microsoft introduced a throttle
on in these versions, if more
Ali, Saqib wrote:
I exported a large data set from from Microsoft SQL server in CSV
format. However whenever I try to import that data to a a mySQL server
running on Linux, it adds a space between each character in each
field.
Essentially:
Saqib Ali
becomes
S a q i b A l i
I have tried to use
Hi all,
I had a server pretty much locked up this morning due to the mysql bin logs
filling up the /var filesystem.
I had been investigating the my.cnf settings file a white back, got
sidetracked, and never finished it.
The bin logs are named:
/var/db/mysql/myserver-bin.01
/var/db/mysql/m
HP scripts),
IS it safe to grant 'All' privs to that user in the database grants table?
-Grant
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all,
I have a table I needed to prune because it had grown to 5 million rows and
it appeared that that app that uses it couldnt anymore.
I am in the process of:
DELETE FROM mytable WHERE id < 300;
the above has been running for close than an hour and I am starting to get a
little nervou
Hi,
I have a table where I keep sales transactions, so I'm trying to do a
query that will count the number of transactions per day.
My test data looks like:
--
-- Table structure for table `sales_activity`
--
CREATE TABLE `sales_activity` (
`sales_id` int(11) NOT NULL auto_increment,
`
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I found this a while back and it seems to work just fine. It uses
launchd rather than the old /Library/StartupItems folder
http://blog.tomatocheese.com/archives/2007/11/1/migrating_mysql_to_mac_os_x_leopard/
Regards,
Grant Limberg
[EMAIL
l_address field the primary key, only problem is, several records
> already share the same email_address
>
> How do I write a query which will show me all the instances where
> email_address is duplicated throughout the table.
>
> --
> Ferindo
>
--
Grant Limberg
[EMAIL PROTECTED]
ad is
left running, still writing to the drive at approx 2MB/sec.
Does anyone out there have any idea what's going wrong here? I'm stumped.
--
Grant Limberg
[EMAIL PROTECTED]
Have you looked at the results of
netstat -an
?
-Grant
- Original Message -
From: Ross Crawford
To: mysql@lists.mysql.com
Sent: Saturday, January 12, 2008 5:12 PM
Subject: Unable to restart after crash
Hi,
My mysql server crashed last night, and when it rebooted
> >>>
> >> Mysqlhotcopy
> >>
> >> --
> >> MySQL General Mailing List
> >> For list archives: http://lists.mysql.com/mysql
> >> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> >>
> >>
> >>
> >
> >
>
>
> --
> Keith Murphy
>
>
> editor: MySQL Magazine
> http://www.mysqlzine.net
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Grant Limberg
[EMAIL PROTECTED]
r blank database is setup, and that user is given access to is
from localhost, although I have a few users that have requested, and were
granted connections (via the 'hosts' table) remote access.
sampleuser_database sampleuser localhost Select | Insert | Update |
Delete | Create | D
Tangirala, Srikalyan wrote:
Hi All:
Could you provide some more information about Oracle limitations, MySQL
limitations, Oracle vs. MySQL etc?
Sure, let's play devil's advocate for a minute.
Some things unique to MySQL that Oracle does not offer include:
- Storage engines, choices like In
On 11/9/06, ViSolve DB Team <[EMAIL PROTECTED]> wrote:
Hi Experts,
We are in the process of converting Oracle administration commands into MySQL
for some purposes. We dont know how to convert the following Oracle commands to
MySQL. How to do that..?
1. ALTER USER spec TEMPORARY TABLESPACE tem
Thanks,
This worked exactly like I had hoped.
Grant
Peter Brawley <[EMAIL PROTECTED]> wrote: Grant,
>If I want to select all the products that are in the product_table,
>but not in the sale_table, how to make the query? The product_table
>has all the products, but
a subset of the product_table.
I tried:
SELECT item_name FROM product_table, sale_table WHERE product_table.prod_id !=
sale_table.prod_id but I'm not getting any results from that.
Sorry this code isn't exact, I'm not att my development PC at the moment.
Thanks Michael, That was the solution. This was the first time I've seen that
error and now it makes plenty of sense.
Thanks,
Grant
Michael Stassen <[EMAIL PROTECTED]> wrote: Grant Giddens wrote:
> Hi,
>
> I'm using mysql 4.1.14 and and getting this error:
>
&
any workaround I can use?
Any sugguestions would be greatly appreciated.
Thanks,
Grant
-
Brings words and photos together (easily) with
PhotoMail - it's free and works with Yahoo! Mail.
need to do this
mysqldump, recreate my tablespace and re-imporrt my data process each time?
3. What if I'm running multiple databases with innodb tables on one mysql
server? I guess if I use innodb_file_per_table it will help me keep the file
sizes down and make it easier to drop and relo
innodb table
locksON ON
innodb thread concurrency
8 8
Please let me know if I need to post any more
How did you get these byte calculations? I thought an INT took up 4 bytes and
char(10) would take 10 bytes.
http://dev.mysql.com/doc/refman/4.1/en/storage-requirements.html
"C.R.Vegelin" <[EMAIL PROTECTED]> wrote: Hi Grant,
I suggest to change both key fields to Intege
for a
particular product, I have set the PRIMARY key on product_id and feature.
I have lots of products and lots of features. Is design bloating my
available key_buffer memory with too much data?
Is there a better way to index this data?
Thanks,
remaining 512M to the other server services?
For a large database, are they any guides that I can use to determine how
much ram would be optimal for my particular database?
Thanks,
Grant
Eric Bergen <[EMAIL PROTECTED]> wrote: The difference in recommendation size
comes fr
these two variables and all the other my.cnf
settings.
Thanks,
Grant
-
Yahoo! Photos
Got holiday prints? See all the ways to get quality prints in your hands ASAP.
The queries might be a bit off as I don't have the exact code in
front of me right now.
Is there a way I can combine this into 1 query?
Thanks,
Grant
-
Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays,
whatever.
The queries might be a bit off as I don't have the exact code in front of me
right now.
Is there a way I can combine this into 1 query?
Thanks,
Grant
-
Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays,
whatever.
, DNS, ftp server, etc...
It's a dedicated server that only hosts my sites so I can tweak the
configuration. Should I use the my-large.cnf as a starting point, or should I
be OK with my-huge.cnf?
Thanks,
Grant
James Harvard <[EMAIL PROTECTED]> wrote:The reason I suggest
eve it's writing all the data to the
disk and then sorting it. I'd like to try tweaking the my.cnf file to allow
mysql to use more RAM.I just need someone to help me edit the file because
I'm not quite sure what I'm doing...
Thanks,
Grant
Hank <[EMAIL P
d the INDEX from the `salesrank` column. It didn't
make a difference as my results were just like the ones above.
Now that I know what's causing the slow queries, what can I do to fix it?
Thanks,
Grant
Hank <[EMAIL PROTECTED]> wrote: Ok, so the next step would be to t
0,000 rows.
Thanks,
Grant
Hank <[EMAIL PROTECTED]> wrote: Ok, so the next step would be to try the
original query with just the
LIMIT clause, and then just the ORDER BY (but not both).
The results of "select count(*)" query would be helpful to know just
how many records m
od.asin 1 Using index
--
Basically it looks like it's the ORDER BY and LIMIT clause that makes my
original query take so long. All the other queries were pretty fast. Any
idea what is wrong with my original query?
Thank Hank. I will try this. When you say the table descriptions, do you
mean for me to post my CREATE TABLE syntax of how I created the table?
Thanks,
Grant
Hank <[EMAIL PROTECTED]> wrote: I don't think the problem is going to be
solved with the my.cnf file.
Here
or mistakes in the file.
http://retailretreat.com/mysql/my-new.cnf.txt
Thanks,
Grant
James Harvard <[EMAIL PROTECTED]> wrote:I've recently been doing some big
table query optimisation, but after getting the query tweaked to hit the right
index the query time is under very
my proposed my.cnf file. I'm not sure if there are any
errors or mistakes in the file.
http://retailretreat.com/mysql/my-new.cnf.txt
Am I right that I need to tweak the my.cnf file? I think I optimized my
tables with INDEXes correctly a
ed with a higher score. I think this
would give me better search results.
Right now both of these are returned with a score of 2, since they
both have 2 matching words. If I could weight it, I would want:
Apple iPod (brand: Apple) (score=3)
TuneDock for Apple
ed with a higher score. I think this would give me better search
results.
Right now both of these are returned with a score of 2, since they both have
2 matching words. If I could weight it, I would want:
Apple iPod (brand: Apple) (score=3)
TuneDock for Apple
ore.store_network_id) ORDER BY score DESC
Thanks,
Grant
__
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
able1 and 2 items in table2 the
above query only gives me 2 results.
table1 will always be fully populated and table2 might
be missing some features.
How can I run my query to get 3 results and if the
feature is missing still return the table.title and
NULL for the fea
will always return the results in $sku1, $sku2, $sku3,
$sku4 order.
Thanks,
Grant
__
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
--
MySQL General Mailing List
For list archives:
On Thu, 6 Jan 2005 11:30:33 +0200
"Heikki Tuuri" <[EMAIL PROTECTED]> wrote:
> > innodb_data_file_path = ibdata2:7M;ibdata1:10M:autoextend
>
> You have to add new data files to the end of the line, not to the
> start. Please follow the instructions at
> http://dev.mysql.com/doc/mysql/en/Adding_an
On Wed, 5 Jan 2005 08:19:07 -0800 (PST)
Kentucky Families <[EMAIL PROTECTED]> wrote:
> This is a huge database so the option of using LIKE to bring up
> everything beginning with the search term will result in too many
> hits. I need a way to isolate these entries and search them on whole
> words.
Dear Heikki
Many thanks for your reply.
On Mon, 3 Jan 2005 20:41:22 +0200
"Heikki Tuuri" <[EMAIL PROTECTED]> wrote:
> are you sure that you copied the complete ibdata1 file to the new
> place? It is strange how 7 MB can be missing from the file end.
I have just checked the tar file I used to do
On Wed, 05 Jan 2005 12:22:18 +
Stephen Moretti <[EMAIL PROTECTED]> wrote:
> Kentucky Families wrote:
>
> > ... If I use a VARCHAR or TINYEXT field to enter these values and
> >I want to be able to retrieve all records where the surname field
> >contains the whole word Stotts, how would I ente
Dear MySQL people
I have a question regarding the error:
InnoDB: Error: tablespace size stored in header is 17024 pages, but
InnoDB: the sum of data file sizes is only 16576 pages
which appeared when I upgraded from 4.0.7 to 4.1.7.
Somehow I am 448 pages (7M) short of table space.
Can I fix th
I have a new project I'm working for and I was
wondering if anyone could help me optimize my selects
for speed. I have a table with about 500,000 entries.
The table structure I'm using is (via my PHP
commands):
$sql = "CREATE TABLE $store_data_table (
$store_data_column[sku] VARCHAR
, and "" for searching in
full-text boolean mode, so I'd like to preserve that
functionality.
Since I'm on a shared host provider and can't really
optimize the mysql configuration, is there any
suggestions to help me improve my search results?
Thanks,
Grant
__
, and "" for searching in
full-text boolean mode, so I'd like to preserve that
functionality.
Since I'm on a shared host provider and can't really
optimize the mysql configuration, is there any
suggestions to help me improve my search results?
Thanks,
Grant
__
;mysql" has already been started.
There is no /var/run/mysqld/mysqld.sock file, and
mysql.err doesn't have anything to say. Can anyone
help?
- Grant
__
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yah
manual, but I don't
think it really aplies to what I'm trying to do here.
Any suggestions would be appreciated,
Thanks,
Grant
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
For posterity (ie the archives) there's a comma missing in the FROM line:
FROM contact AS cn, codes AS cd1, codes AS cd2
Roddie Grant
on 25/5/04 8:25 am, Greg Willits at [EMAIL PROTECTED] wrote:
> Got an offline answer, so I'm all set. Gotta love SQL.
>
> for posterity...
I am looking for a course in North America that provides mysql and vb.net or
c# training or a good text book or dvds.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am trying to find all my empty records. I am looking for NULLs and Empty
strings but is there a simple way to just as this? I thought MySql may have
something built in.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAI
I am desperately looking for some programming examples for building custom
gui's. And can't find any online using MySQLDriverCS.
I have one built but I need to find better examples.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mys
Any advice will be much appreciated.
Roddie Grant
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
is called 'cou_id' not 'id' (and 'cou_name' not 'country').
Roddie Grant
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have RH9 running on a p4 machine. I have mysql 3.23.58 running on
this linux machine. Through Websphere studio application developer on
windows xp machine I am trying to connect to my MySql database on the
Linux machine.
The error I receive is: connection refused
I then tried to telnet t
OK thx to MATHAN's previous post.
Solution:
Executed the following commands..
# chown -R mysql /var/lib/mysql
# chmod 700 /var/lib/mysql
Then started the daemon.
Thx
-EKG
From: ekg1
To: [EMAIL PROTECTED]
Sent: Saturday, November 08, 2003 1:39 AM
Subject: Mysql daemon dies on startu
I am having trouble installing the RPM files for MYSql 4.1 on RH 9.0.
1. I believe I have the MYSQLD daemon running, however have no idea how
to talk to the server.
2. When I try to install the Client RPM for 4.1, the terminal window
hangs and nothing is printed to the window.
3. When I tried t
SELECT DailyLog.TimeOut, DailyLog.TimeIn,
SEC_TO_TIME(UNIX_TIMESTAMP(DailyLog.TimeOut) -
UNIX_TIMESTAMP(DailyLog.TimeIn)) as test FROM DailyLog
keeps on giving me a result as a date. Not time in years, days, hours, min.
For example 9/9/2007 12:51:26 PM - 9/9/2007 12:51:26 PM gives me 12:00 PM. I
tbl_child.child_datetime
Roddie Grant
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm trying to get a query to work by listing all the people in a row with
the same last name and first name.
key, fname, lname
1 ,John, Smith
4, John, Smith
5, Cody,Edwards
2, Cody, Edwards
Don't list anyone that has a unique first name last name. Is this possible?
Trying to use the Count comman
I'm building a program calendar describing each Year's courses. I have a
field for a semester and it's current courses in one cell separated by a
",". When I go to print this out I create an array out of the cell than do
it's sorting.
Or
Should I just take the time and create a new table and sepa
I have 2 tables used for an online calendar...
first table fields: primary_key , start_date, event_name, event_description
second table fields: primary_key, end_date
Tables fields are shortened and can't be changed.
My second table only contains events that have a end date. I want to create
a qu
PROTECTED]; [EMAIL PROTECTED]
Subject: Re: unique identifier using mysql_connect
At 12:43 -0700 7/30/03, Grant Cooper wrote:
>Can I get a unique identifier using the mysql_connect command by connecting
>to the same host, same user but different database during the life time of
>one scr
Can I get a unique identifier using the mysql_connect command by connecting
to the same host, same user but different database during the life time of
one script?
I currently do a
$conn_id = mysql_connect ($host_name, $user_name, $password);
Then call a,
mysql_select_db ($db_name,$conn_id)
But I
I was hoping someone could tell me a way to increase the productivity of a
database server. It has nothing else installed other than the newest
production version of mysql and the default packages from FreeBSD.
Is there a toaster than can bring me up to speed.
Thanks.
--
MySQL General Mailing
must first create an
InnoDB database, then copy your tables into new tables in the InnoDB
database.
Grant Q
-Original Message-
From: azamka [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 10:59 AM
To: [EMAIL PROTECTED]
Subject: creating table type innodb
Hi everyone,
I
d what to do.
Best of Luck,
Grant Q
-Original Message-
From: Gabriel Guzman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 10:06 AM
To: Bernd Jagla
Cc: [EMAIL PROTECTED]; mysql
Subject: Re: RAID hardware suggestions/experience
Bernd,
here is a good resource on t
I'm still a bit of newbie, but surely these are not the same query. The
empty string is not the same thing as NULL.
Roddie Grant
[EMAIL PROTECTED]
> I tested these 2 queries:
>
> select * from mytable where myfield is null;
>
> select * from mytable where myfield = '&
loose
about 12 cents. Not big losses, but when dealing with financial accounting
it is generally an unacceptable inaccuracy.
Grant Q
-Original Message-
From: Mojtaba Faridzad [mailto:[EMAIL PROTECTED]
Sent: Monday, June 09, 2003 11:56 AM
To: [EMAIL PROTECTED]
Subject: money field
I'm trying to update an email field. Our company has changed from a .com to
a .ca. I wrote a php script to make the changes but I was wondering if I
could do this from the command line. Its a text field and I would like to
replace. [EMAIL PROTECTED] to [EMAIL PROTECTED] Can someone help me out plea
m, Scott Haneda at [EMAIL PROTECTED] wrote:
> on 02/28/2003 1:37 AM, Roddie Grant at [EMAIL PROTECTED] wrote:
>
>> Working in Lasso Profession 6, OS X and My SQL 4.?
>>
>> I'm at the testing stage of a small survey website
>> (http://www.myword.co.uk/iied/iied_i
he new data.
I have confirmed that the SQL is identical for both, and I am now baffled. I
don't even know what to look for. This is mission-critical, so I'm open to
any suggestions.
Thanks
Roddie Grant
[EMAIL PROTECTED]
Is it better to store a picture in mysql field or a link to the file on my
server? I want to allow people to use a php script to upload a gif or a pic.
Any pro's and con's would be appreciated.
-
Before posting, please check:
There are many tools. Use a gui. mysql front (free), premium soft (my pick
but has a 29 day trial). There are also many small window applications to do
this. Do a search at one of the famous downloads. +client +mysql +gui
-Original Message-
From: Charles Mabbott [mailto:[EMAIL PROTECTED]]
Mysql works on port 3306 by default.
for example, my mysql server is on 10.10.10.1 so you would use this command
to test your mysql server.
telnet 10.10.10.1 3306
you will get special garbage or host not allowed if testing a remote server.
But at least you know your mysql server is open.
You co
dly. Is using Access the way to
go or is there a product I'm missing?
- Original Message -
From: "Grant Cooper" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Saturday, December 14, 2002 6:49 PM
Subject: Connecting M. Access Forms to
1 - 100 of 126 matches
Mail list logo
