stop and restart mysql on freebsd?

I made a change to my.cnf and want it to restart mysqld_safe so it will re-read my.cnf. How do I do this? Thanks, Chip -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

adding an incremented count from page hits

I have an existing database/tables and would like to add a counter to a table that would increment when a document is downloaded from the database. I am sure it is an easy addition to the php page but struck-out looking for info not related to auto-increment in the mysql manual. I tried adding

query of two tables returns far too many rows, more than the two tables contain

rows that are in the dealers table but not in the blackgate_users table. Thanks for any help, Chip Wiegand Computer Services Simrad, Inc 425-778-8821 425-771-7211 (FAX) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: query of two tables returns far too many rows, more than the two tables contain

ULL values, you find the non-matching rows. Get it? > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > Chip Wiegand <[EMAIL PROTECTED]> wrote on 11/11/2004 04:29:08 PM: > > > I have two tables I want to get out the rows that are different be

copy data only from one table to another table

How do I copy all data only from one table into another table? Both tables are in the same database. I have phpMyAdmin and it suppossedly does this, but it is not working, and there are no error messages. Thanks, -- Chip -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

problem importing .csv (excel format) into mysql

could cause it to fail on a non-existant key? Is there a trick to loading Excel .csv files into mysql? Thanks -- Chip Wiegand Computer Services Simrad, Inc www.simradusa.com www.simrad.com [EMAIL PROTECTED] "When I'm working on a problem, I never think about beauty. I think only how to s

Re: problem importing .csv (excel format) into mysql

"Joshua J. Kugler" <[EMAIL PROTECTED]> wrote on 07/08/2004 04:24:41 PM: > On Thursday 08 July 2004 02:35 pm, Chip Wiegand said something like: > > I was sent an excel file from a remote office, and need to put the data > > into a mysql database to be displayed o

I can delete, add, but not update

t up correctly in MySQL? Thanks, Chip Wiegand Computer Services Simrad, Inc 425-778-8821 425-771-7211 (FAX)

RE: I can delete, add, but not update

pt. I double checked my update script to make sure there were no spelling errors in the field names, and all looks good. It's just really strange. -- Chip > -Original Message- > From: Chip Wiegand > To: [EMAIL PROTECTED] > Sent: 8/17/04 11:29 AM > Subject: I can delete,

RE: I can delete, add, but not update

01:09:25 PM: > Can you log on as the web account and try to insert, update, select directly > from the MySQL monitor? > > -Original Message----- > From: Chip Wiegand > To: Victor Pendleton Cc: '[EMAIL PROTECTED] ' > Sent: 8/18/04 2:41 PM > Subject: RE:

select statement not working in a php page

I am trying to get a single result from a database, which works fine at the sql command line. I have tried several versions of code, this being the most recent - \n"; echo "Warranty ID:\n"; echo "$WarrantyID\n"; echo "\n"; } ?> No matter what I do I do not get the desired max id number from the c

Re: select statement not working in a php page

is a table header. > > Second, if you are expecting a single result row, then you do not > need the while() loop. Do a > single fetch and display the result. > > rick > "People will forget what you said. People will forget what you did. > But people will never forget how y

out of memory error and update problem

su-2.05b# df -H FilesystemSize Used Avail Capacity Mounted on /dev/ad0s1a 508M 346M 121M74%/ devfs 1.0K 1.0K 0B 100%/dev /dev/ad0s1d14G 2.9G 9.9G22%/usr File system is not full, what's it talking about? What would be the rec

Plz help quick - mysql/php/web server undefined function all of a sudden

either today or over the weekend, I know it worked friday when I left the office. This particular machine has been up for 151 days 22 hours without a hiccup. thanks for the help, -- Chip Wiegand Computer Services Simrad, Inc www.simradusa.com [EMAIL PROTECTED] "There is no reason anyone

Re: [PHP] Plz help quick - mysql/php/web server undefined function all of a sudden

"John W. Holmes" <[EMAIL PROTECTED]> wrote on 05/03/2004 10:59:15 AM: > From: "Chip Wiegand" <[EMAIL PROTECTED]> > > > I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4 on > > freebsd-5.1. > > It has been working fine for

Re: Plz help quick - mysql/php/web server undefined function all of a sudden

I hope not. -- Chip > On Monday 03 May 2004 09:20 am, Chip Wiegand said something like: > > I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4 on > > freebsd-5.1. > > It has been working fine for the past few years, now all of a sudden today > > I get an

load data infile command not allowed problem

or without? Evidently it defaults to not enabled. The server is running MySQL-3.23.52. How do I run phpMyAdmin to give me the ability to upload a local data file to a mysql server that doesn't allow this? thanks, -- Chip Wiegand Computer Services Simrad, Inc www.simradusa.com [EMAIL P

load data infile command not allowed problem - revised

r that doesn't allow this? thanks, -- Chip Wiegand Computer Services Simrad, Inc www.simradusa.com [EMAIL PROTECTED] "There is no reason anyone would want a computer in their home." --Ken Olson, president, chairman and founder of Digital Equipment Corporation, 1977

update question

I need to make a change to a field in a table and don't know how to write the correct sql statement. I made an error and now have a date field with the year repeated twice - 01-01-03-03 - there are aproximately 100 rows like this, and maybe 20 or so that are formatted properly. How can I remove the

Re: update question

ks for the help, worked great. I didn't know about the underscore being a wildcard character. I should look for a better MySQL book, the ones I have don't cover that info. Any suggestions for one that does? -- Chip > HTH, > Tore. > > - Original Message - > From: &qu

Re: update question

or two on MySQL. So, I'll have to buy a SQL book specifically. Regards, Chip > - Original Message - > From: "chip wiegand" <[EMAIL PROTECTED]> > To: "Tore Bostrup" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Sunday, March 02,

Finding out whos using the database

Is there a command that I can use to find out how many people, or more specifically, who, is using the database? I tried the mysql web site but the search result are more irrelevant than relevant. Thanks, Chip W www.wiegand.org [EMAIL PROTECTED] --

export table?

Where is info on exporting a table? I checked the mysql docs and the only reference to export has nothing to do with exporting a table. I want to copy a table from one server to another, should be simple enough, right? -- Chip [EMAIL PROTECTED] www.wiegand.org ---

Re: export table?

On Mon, 2002-07-08 at 04:42, Victoria Reznichenko wrote: > > What about mysqldump? > http://www.mysql.com/doc/m/y/mysqldump.html > > You can make dump file of your table, copy from one server to > another and restore table or > mysqldump database_name table_name | mysql -hhost_name

select box result on page1 to insert statement table name on page2- not working

I first posted this on the php-db list, but am not getting the proper results yet, so I am copying here, hopefully someone can help me figure this one out... I have a form with a select list and a hidden field to save the selected item. On submit another page is loaded with a few fields to be fil

using a variable to search a database

match (body,bulletin_subject) against ('request')"; I want 'request' to be the variable from the form input=text field. Does mysql have something similar to perl's $variable=? Just how do I do this type of search? Thankyou, Chip Wiegand Computer Services www.simradusa

web search form for a mysql database

without any problem from the mysql command line by entering the word I am interested in searching on. The problem seems to be with the part after against, just how do I get the user input data into that field? Chip Wiegand Computer Services www.simradusa.com [EMAIL PROTECTED] Simrad, Inc Lynnwood, W

Re: web search form for a mysql database

essage- > FROM: [EMAIL PROTECTED] > TO: [EMAIL PROTECTED] > DATE: Thu 7/5/01 10:13 > SUBJECT: web search form for a mysql database > > I have mysql 3.23.38, php4.03, apache1.3.14. I have a small database of > dealer bulletins. > I have created a web page to allow easy inpu

Re: web search form for a mysql database

is empty. Go back and type a string to search"; > } > include ('links.x'); > ?> > > > -Original Message- > FROM: [EMAIL PROTECTED] > TO: [EMAIL PROTECTED] > DATE: Thu 7/5/01 10:13 > SUBJECT: web search form for a mysql database > > I ha

can't connect from web page, but works fine from command line

just continue to the next web page as if all is well and good. I can add data from the mysql command line, and also from within webmin, just not from the web page. Is it a permissions problem, or access rights problem, or something like that? The only change made recently was to the web server, ap

Please help - does changing the port the web server listens on affect mysql?

I am having a problem with inserting data into a table via a web form, which was working just fine prior to changing the port the web server is listening on from 80 to 8080. I can insert data via the mysql command line just fine, just not from the web form. Below are the forms and table def for re

Solved! The a href link to a table data problem

elieve I found the answer. I just wonder why something so obvious (now that I see it working) is not in the books, or why none of the suggested answers included this. Is this not a 'proper' way to do such a link? Chip Wiegand Computer Services www.simradusa.com [EMAIL PROTECTED] Simrad,

Search results are differant on console and in webmin

all their characters. Any idea what the problem could be? (Or is it actually a problem?) Chip Wiegand Computer Services www.simradusa.com [EMAIL PROTECTED] Simrad, Inc Lynnwood, WA 425-712-1138 "There is no reason anyone would want a computer in their home." --Ken Olson, president, ch

Import data question

your SQL syntax near 'fields terminated by ','' at l ine 3 mysql> Regards, Chip Wiegand Computer Services www.simradusa.com [EMAIL PROTECTED] Simrad, Inc Lynnwood, WA 425-712-1138 "There is no reason anyone would want a computer in their home." --Ken Olson, pr

My databases got hosed when the server went down hard!

x27; at line 1 Obviously I don't know how to use myisamchk properly. In Webmin I see the icons for the database, but when I select it the screen changes and shows This database has no tables. Hopefully these files can be restored, I can view them with cat and they do contain the d

Re: My databases got hosed when the server went down hard!

Thankyou, that fixed it. Man, I was concerned I'd have to rebuild those databases and re-enter all the data. thanks for the help, -- Chip [EMAIL PROTECTED] on 08/07/2001 11:35:31 PM Internet mail from: To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject: Re: My databases got hosed whe

I blew it big time... locked myself out of mysql

line, with -uroot -ppassword and get the same results. Please help ASAP. I have always been able to connect as root with just 'mysql' at the prompt. -- Chip Wiegand Computer Services www.simradusa.com [EMAIL PROTECTED] Simrad, Inc Lynnwood, WA 425-712-1138 "There is no reason anyone would

Re: I blew it big time... locked myself out of mysql

-uroot -ppassword and get the same results. Please help ASAP. > I have always been able to connect as root with just 'mysql' at the prompt. > > -- > Chip Wiegand > Computer Services > www.simradusa.com > [EMAIL PROTECTED] > Simrad, Inc > Lynnwood, WA > 425

Re: I blew it big time... locked myself out of mysql

[EMAIL PROTECTED]@bellsouth.net on 08/14/2001 10:03:13 PM Internet mail from: Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: I blew it big time... locked myself out of mysql On Tue, 14 Aug 2001 12:16:59 -0700, [EMAIL PR

Re: I blew it big time... locked myself out of mysql

Werner Stuerenburg <[EMAIL PROTECTED]> on 08/14/2001 11:55:37 PM Internet mail from: Please respond to Werner Stuerenburg <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: Re: I blew it big time... locked myself out of mysql I think it is grant all on *.* to 'root'@'localhost' id

linking to a database id

I have a database of dealers. A web page loads a list of states, a user clicks on the state and the database is queried and lists in a table the dealers for that state. Simple enough. When the dealers page is first loaded, it shows all dealers in the database, name, address, phone, etc. I want to

getting multiple columns per row from databse query

I have a database that is names and addresses. I want to make a web page that will display those names and addresses in a table with 4 columns per row, as many rows as necessary. The little if statement below works to make 2 columns, but when I change the number to 3 or higher it no longer works

Re: getting multiple columns per row from databse query

Thanks Bill, That works great. Much appreciative, Chip Bill Adams <[EMAIL PROTECTED]>@tqs.com on 11/15/2001 10:31:45 PM Internet mail from: Sent by: [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject: Re: getting multiple columns per row from databse query Try

Rename a Database?

I searched the archives and the manual online but could not find the answer, I believe this has been covered in the list though. Is it possible to rename a database? If not, is it possible to move/copy a table from a database to a new database? Could someone point me to the details on this? -- Ch

select statement group by unusual results

I have a database with 12 tables. I am running a query to select certain fields from 3 of the tables, like this - select Title, Details, StartDate, City, State from phpCalendar_Details, phpCalendar_Daily, phpCalendar_EventLocations where phpCalendar_Details.EventLocationID = phpCalendar_EventLoca

Re: select statement group by unusual results

"DL Neil" <[EMAIL PROTECTED]> on 12/05/2001 11:35:46 PM Internet mail from: Please respond to "DL Neil" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> cc: Subject: Re: select statement group by unusual results Chip, > I have a database with 12 tables. I am running a q

Re: select statement group by unusual results

"DL Neil" <[EMAIL PROTECTED]> on 12/06/2001 12:26:45 AM Internet mail from: Please respond to "DL Neil" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> cc: <[EMAIL PROTECTED]> Subject: Re: select statement group by unusual results Chip, > > I have a database with 12 tables. I am running

Re: select statement group by unusual results

"DL Neil" <[EMAIL PROTECTED]> on 12/06/2001 05:27:55 PM Internet mail from: Please respond to "DL Neil" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> cc: <[EMAIL PROTECTED]> Subject: Re: select statement group by unusual results Hi Chip, > Thanks for the tips. So here's my latest attem

I know it's not supposed to be this difficult to install

I am trying to get mysql-server installed from the FreeBSD port but keep getting this dog-gone error - mysqld started Can't start server: Bind on unix socket: Permission denied Do you already have another mysqld server running on socket: /tmp/mysql.sock? Aborting Okay, so, I do a ps -aux | grep

Re: I know it's not supposed to be this difficult to install

led previous versions of mysql a dozen times and have never had this trouble. -- Chip > ---- > > At 04:19 PM 9/17/2002 -0700, Chip Wiegand wrote: > >I am trying to get mysql-server installed from the FreeBSD port but keep > >getting this dog-gone error - > > > >mysql

db dump question

I need to copy a database and all its tables and contents to a backup server. The server they live on is on an ISP, the server I want to back the up on is in my office in another town. I can access the ISP's server via phpMyAdmin and dump the data to a .sql file, but then what do I do to recre

Re: db dump question

On Thu, 2002-09-26 at 18:28, Mihail Manolov wrote: > mysql < datadump.sql Thanks, I finally found it. the mysql manual doesn't have anything about exporting/importing, I was using the wrong words for searching. -- Chip > - Original Message - > From: <[EMAIL PROTECTED]> > To: <[EMAIL PR