RE: Upgrading How To

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

Re: Upgrading How To

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 the answer I

Upgrading How To

to 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

Re: munin MyISAM InnoDB issues

the munin check to deal with numbers 2^32. To double check, look at: mysql SHOW TABLE STATUS LIKE 'any innodb table that was created in the main tablespace'\G Look at the Data_free: line, it is probably bigger than 2^31. Actually it's zero. Is that a problem? - Grant I have 4 out

munin MyISAM InnoDB issues

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 list archives: http://lists.mysql.com/mysql

Re: munin MyISAM InnoDB issues

Info 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 I should add that I get the following: # munin-run mysql_isam_space_ # munin

Re: Postal code searching

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

Re: Verifying security

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 noticed port: 3306 was referenced in mysqld.err.  The strange thing is 'nmap localhost

Re: Verifying security

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 user='root'; This will show every host that root can login as along with the PASSWORD

Re: mysql_upgrade fails with Access denied

should I try? You should use the password for the _MySQL_ root user, which is _not_ stored in /etc/passwd, but within MySQL. / Carsten Thanks everyone. I got mysqld to start with --skip-grant-tables by adding skip-grant-tables to /etc/mysql/my.cnf and restarting mysql. mysql_upgrade ran without

Verifying security

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

mysql_upgrade fails with Access denied

? - Grant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: mysql_upgrade fails with Access denied

should I try? Is this 5.5.7? You have to run the server with --skip-grant-tables, then run mysql_upgrade. I'm running mysql-5.1.51 which is the latest marked stable in Gentoo. Does this still apply? I always use Gentoo's mysql initscript so I'm trying to find the correct command to start mysqld wtih

Re: mysql_upgrade fails with Access denied

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: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck

Mysql 4 to 5

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

Re: Mysql 4 to 5

- Original Message - From: Michael Dykman mdyk...@gmail.com To: Grant Peel gp...@thenetnow.com Cc: mysql@lists.mysql.com 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

Re: Mysql 4 to 5

- Original Message - From: Grant Peel gp...@thenetnow.com To: Michael Dykman mdyk...@gmail.com Cc: mysql@lists.mysql.com Sent: Sunday, July 11, 2010 9:25 PM Subject: Re: Mysql 4 to 5 - Original Message - From: Michael Dykman mdyk...@gmail.com To: Grant Peel gp

Re: Updating 4 to 5

- Original Message - From: Rob Wultsch wult...@gmail.com To: Grant Peel gp...@thenetnow.com Cc: mysql@lists.mysql.com 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 gp...@thenetnow.com wrote: Hi all, I have serveral

Updating 4 to 5

will 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

Re: Updating from 4 to 5

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

Updating from 4 to 5

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

Re: Help with export and import into Oracle

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

Re: Unable To Remove User

Carlos Williams wrote: On Tue, Sep 29, 2009 at 11:36 PM, mos mo...@fastmail.fm 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

Re: MYSQL startup problem

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

Re: Importing MS SQL exported CSV files adds spaces

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

Bin Files.

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

Permissions

), 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]

Help!

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

Do I need to use GROUP BY to do this?

Hi, nbsp; 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` ( nbsp; `sales_id` int(11) NOT NULL

Re: MySQL 5 on OS X Leopard

-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

Re: finding duplicate key

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]

Crash Recovery Problem

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]

Re: Unable to restart after crash

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

Re: preferred way to backup a 20GB MySQL database

://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

Virtual Hosting Privileges

, 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 | Drop | Grant | References | Index | Alter

Re: Migration from Oracle to MySQL

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

Re: Convertion ORACLE query to MYSQL

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

Re: How to select data if not in both tables?

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 the sale table

How to select data if not in both tables?

is 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, Grant

Re: Column in field list is ambiguous

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: Column 'asin' in field list

Column in field list is ambiguous

appreciated. Thanks, Grant - Brings words and photos together (easily) with PhotoMail - it's free and works with Yahoo! Mail.

Re: innodb questions

-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 reload individual databases. Am I correct here? Thanks, Grant Ware

innodb questions

ON ON innodb thread concurrency 8 8 Please let me know if I need to post any more variables. Thanks, Grant

Re: Most efficient way to design this table

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 Integers. Numeric keys take

Re: key_buffer_size vs innodb_buffer_pool_size

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 from the different

Most efficient way to design this table

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, Grant

key_buffer_size vs innodb_buffer_pool_size

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.

Can I do a boolean search and get the row count in 1 SQL query?

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.

Can I go a boolean search and get the row count in 1 SQL query?

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.

Re: Do I need to tweak my server variables for this SELECT statement?

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 PROTECTED] wrote: Now that I know what's causing

Re: Do I need to tweak my server variables for this SELECT statement?

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 suggested that you just use

Re: Do I need to tweak my server variables for this SELECT statement?

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 livable-with, despite the fact

Re: Do I need to tweak my server variables for this SELECT statement?

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's what I would try

Re: Do I need to tweak my server variables for this SELECT statement?

long. All the other queries were pretty fast. Any idea what is wrong with my original query? Thanks for everyones help. Grant Hank [EMAIL PROTECTED] wrote: I don't think the problem is going to be solved with the my.cnf file. Here's what I would try.. 1- run and time the original

Re: Do I need to tweak my server variables for this SELECT statement?

. 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 mysql is trying to sort and limit

Re: Do I need to tweak my server variables for this SELECT statement?

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 try the original query

Do I need to tweak my server variables for this SELECT statement?

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 already. What should I look for first? Thanks, Grant

Can I weight full-text searches in boolean mode?

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 iPod (brand: Belkin) (score=2) Is this possible? Thanks, Grant

Can I weight full-text searches in boolean mode?

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 iPod (brand: Belkin) (score=2) Is this possible? Thanks, Grant

Need help with fulltext search and left join

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:http://lists.mysql.com/[EMAIL

QUERY ordering clarification

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: http

SELECT help

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 feature? Thanks, Grant

Re: Retrieving partial field values

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. If

Re: InnoDB: Error: tablespace size stored in header is 17024 pages,

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

Re: Retrieving partial field values

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 enter these

Re: InnoDB: Error: tablespace size stored in header is 17024 pages, but

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 the

InnoDB: Error: tablespace size stored in header is 17024 pages, but ...

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

Need help figuring out indexes for faster SELECT queries

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]

Need help optimizing full-text searches

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 __ Do You Yahoo!? Tired

Need help with mysql search engine

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 __ Do You Yahoo!? Tired

conflicting messages

/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.yahoo.com/new_mail -- MySQL General Mailing List For list archives

Insert data if not duplicate based on order

would be appreciated, Thanks, Grant __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: SELECTing to Substitute Text for Refc Codes

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... Try: SELECT cn.name

vb.net and mysql training

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]

Finding Empty Records

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:

MySQLDriverCS-n-EasyQueryTools-3.0.11

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:

Update is deleting data

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]

Re: LOAD DATA INFILE..

Grant [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Connection Refused by Linux Server

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

Re: Mysql daemon dies on startup

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

Trouble installing MySql 4.0 or 4.1 on RH 9.0 Linux

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

SEC_TO_TIME not working?

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.

Re: How do you ORDER BY two columns as one?

Grant [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

listing all people who have the same firstname and lastname

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

array vs. more table cells

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

Is query possible? (Newbie)

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

RE: unique identifier using mysql_connect

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 script? I

unique identifier using mysql_connect

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

Configuring Database Server

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

RE: creating table type innodb

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

RE: RAID hardware suggestions/experience

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 the different types

Re: checking NULL or ''

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 = ''; The second one run faster

RE: money field

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

updating database query

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

Update works in Netscape, doesn't in Explorer

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] - Before posting, please check

Re: Update works in Netscape, doesn't in Explorer

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_introVw.lasso). When a visitor first comes to the site, a record

storing a picture in a file or database (newbie)

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:

RE: Access to MySQL

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]]

Re: access-mysql

MySQL-Front was super and has a built in utility. Can do it remotely or locally. To bad they stopped supporting it. - Original Message - From: Sandeep Murphy [EMAIL PROTECTED] To: Crercio O. Silva [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 5:06 AM

Connecting M. Access Forms to insert data into mysql

I am trying to find a package to insert data. And was wondering if I can use odbc drivers to connect Access to mysql in real time? - Before posting, please check: http://www.mysql.com/manual.php (the manual)

  1   2   >