I'm querying a table of approximately 42 records based on 3 criteria. The results are
then displayed in a pop-up window. When the query is executed the first time - the
window opens and stalls for about 3 seconds before the results are displayed.
An example query would be : select * from $tabl
Hi -
Can anyone give the command line syntax for optimizing the entire db?
thanks in advance.
MS
sql, query
I'm not sure about perl, but I know in JSP you can substitue ? for values to
avoid getting SQL syntax errors from variable values that have funky
characters, apostrophes and the like.
I'm not sure if Perl implements the same SQL statement syntax but with php
and stripslashes - it's not
;t let me run a task from the server.
What about running a script from an exe ?
thanks
MS
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Mark --
>
> ...and then Mark Stringham said...
> %
> % Does anyone have a suggestion as to how I could run a periodic
;t let me run a task from the server.
What about running a script from an exe ?
thanks
MS
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Mark --
>
> ...and then Mark Stringham said...
> %
> % Does anyone have a suggestion as to how I could run a periodic
Does anyone have a suggestion as to how I could run a periodic mysql dump
for a db that is hosted remotely - IE a web host. I do know that this host
does not support crons.
Any help is appreciated.
thanks
MS
sql, query
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECT
I'm not sure what you mean but the file gets created and when I open
it - there is nothing in it.
Do I need the path to mysql at the beginning ? IE
c:\apache\mysql\bin>mysqldump ?
thanks
MS
> On Fri, Jan 17, 2003 at 04:12:58PM -0700, Mark Stringham wrote:
> > sql, query
&g
I'm not sure what you mean but the file gets created and when I open
it - there is nothing in it.
Do I need the path to mysql at the beginning ? IE
c:\apache\mysql\bin>mysqldump ?
thanks
MS
> On Fri, Jan 17, 2003 at 04:12:58PM -0700, Mark Stringham wrote:
> > sql, query
&g
sql, query
I'm trying to utilize the mysqldump utility to backup my db on a WIN2k
advanced server. I'm running a BAT file with the following syntax
c:\apache\mysql\bin>mysqldump -u uipcontent -p test >
c:\testdump.sql
the file testdump.sql gets created in the appropriate place but the
fi
sql, query
I'm trying to utilize the mysqldump utility to backup my db on a WIN2k
advanced server. I'm running a BAT file with the following syntax
c:\apache\mysql\bin>mysqldump -u uipcontent -p test >
c:\testdump.sql
the file testdump.sql gets created in the appropriate place but the
fi
I have a php/mysql application that allows a user to
add/remove/update/delete text and records from various tables. To avoid
table overhead that comes when column sizes change etc - I am
considering implementing an optimization query that will optimize all
tables in the db every time the use
I know the MySQL password( ) function is irreversible. I have also been told
that storing passwords in plain text is a bad idea. Can a get a few
suggestions of good ways to store passwords in the db?
Thanks
Mark
sql, query
-
B
Howdy -
I have heard that periodically optimizing tables can be helpful in the
overall maintenance of the table space in the db. Is this correct and how
often should it be done?
Thanks
Mark
sql,query
-
Before posting, please
>
> Howdy -
>
> I wonder if there is an more efficient way to do the following:
> I have 2 tables -
>
> The user submits a new record into table A and an id (primary key) is
> created using the auto-increment.
> At the time that the new record is created in table A I need to insert the
> newly crea
Howdy -
I wonder if there is an more efficient way to do the following:
I have 2 tables -
The user submits a new record into table A and an id (primary key) is
created using the auto-increment.
At the time that the new record is created in table A I need to insert the
newly created id from table
Unfortunately, when people suggest that they "avoid PHP when they can" it
usually means they don't understand much about the language or how to use it
appropriately.
That being said, I personally avoid .NET and FrontPage
MS
- Original Message -
From: "Thomas Seifert" <[EMAIL PROTECTED]>
Does anyone have any good maintenance tips for MySQL that should be done on
a regular basis?
I know table optimization is good to do from time to time but I would like
to know of there is anything else I can do to help keep MySQL stable and
running smoothly.
Thanks
Mark
I have used the mysql password(\"$pass \") function in the past to encrypt
passwords into the db. but can not decrypt them if needed. I know this is
not something new.
Is there a better way to protect passwords in the db and then decrypt them
if needed ?
Thanks
Mark
-
Anyone done it on widows?
Thanks
Mark
- Original Message -
From: "Ilyas Keser" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 26, 2002 4:26 PM
Subject: backup script
> Has anyone a shell script example to backup all mysql databases at 3
> o'clock at the night?
>
> Tha
other than a hard-core SQL
or development issue. Go blow your steam somewhere else.
Thanks to those who have responded.
MS
- Original Message -
From: "Curtis Maurand" <[EMAIL PROTECTED]>
To: "Mark Stringham" <[EMAIL PROTECTED]>
Sent: Thursday, August 15,
My bad about the subject line .
MS
- Original Message -
From: "Mark Stringham" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 15, 2002 6:57 PM
Subject: Re: Transactions not supported by database - Perl
> Anyone know of an email mark
Anyone know of an email marketing software suite that works well with MySQL
on the
backend?
I've seen stuff that works with ODBC db connectivity but I'm not interested
in moving to MS SQL or Access.
Any feedback is appreciated
Thanks
Mark
-
I am also using win2k advanced server - what does the back-up syntax look
like if I wanted to to it on Windows?
thanks
Mark
- Original Message -
From: "Nicholas Stuart" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, July 31, 2002 8:54 AM
Subject: RE:
if you enter no parameters to invalid parameters. (or the
>parameter --help)
>
>=C=
>
>*
>* Cal Evans
>* Journeyman Programmer
>* Techno-Mage
>* http://www.calevans.com
>*
>
>-Original Message-
>From: Mark Stringham [mailto:[EMAIL PROTECTED]]
>Sent: We
I am running MySQL 3.23 on WIN 2k server and would like to create a daily
scheduled task that will utilize mysqlhotcopy (or other back up method) to
back up my db. I understand that I need to create a .BAT file that contains
the command to run hotcopy but I'm a bit confused as to the syntax. What
Maybe the poster of the message is an imposter developer too?
MS
-Original Message-
From: Steve Buehler <[EMAIL PROTECTED]>
To: mysql <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, May 09, 2002 3:01 PM
Subject: RE: newbie help
>What makes you think that i
I stll think it was that crazy worm.
MS
-Original Message-
From: Keith C. Ivey <[EMAIL PROTECTED]>
To: mysql <[EMAIL PROTECTED]>
Cc: Steve Buehler <[EMAIL PROTECTED]>
Date: Tuesday, April 30, 2002 11:23 AM
Subject: Re: confirm unsubscribe from [EMAIL PROTECTED]
On 30 Apr 2002, at 11:00,
Why store the pic in the DB?
I know there is an ASP upload utility avaliable.
Try www.asp101.com or www.hotscripts.com
HTH
Mark
-Original Message-
From: Zill-e-Hassan <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, April 25, 2002 1:48 PM
Subject: Blobs+ASP+
I want to run a scheduled task (WIN 2K Server) to backup a db (using
MySQLhotcopy) and need help -
Is this correct?
C:\mysql\mysqlhotcopy -p"password" database table > backup.db
xcopy [flags] C:\mysql\backup.db C:\backup\backup.db.
Is there a better MySQL feature to backup the db that someone w
Could I run something similar as a BAT file?
-Original Message-
From: Russell E Glaue <[EMAIL PROTECTED]>
To: Mark Stringham <[EMAIL PROTECTED]>
Cc: Rodney Broom <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Date: Tuesday, April 02, 2002 4:25 PM
Subje
What would the script look like if I'm on Win2k ?
Mark
-Original Message-
From: Rodney Broom <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, April 02, 2002 12:22 PM
Subject: Re: backup databases
>From: David McInnis <[EMAIL PROTECTED]>
>
>> Could you share
en me
enough to work with.
But I am certainly open for more suggestion/ feedback.
Thanks
Mark
-Original Message-
From: DL Neil <[EMAIL PROTECTED]>
To: Peter Lovatt <[EMAIL PROTECTED]>; Mark Stringham
<[EMAIL PROTECTED]>; MySQL <[EMAIL PROTECTED]>
Date: Thursday, Ma
I have a simple search form that allows the user to search a contact db
based on criteria that they choose.
Search by -
first name - text box
last name - text box
region - drop down
loan officer - drop down
I want the user to be able to receive results if they choose all possible
criteria or jus
all possible?
Any ideas?
Thanks
Mark
At Friday, 22 March 2002, "Chuck Roberts" <[EMAIL PROTECTED]>
wrote:
>I'm doing something similar, with an Access front-end and mysql
>back-end.
>
>> -Original Message-
>> From: Mark Stringham [mailto:[E
I have a project where I may need to connect an MS ACCESS db and MySQL. I
have read some pretty good documentation and know that is possible to take
an existing Access db and export it to MYSQL. I have a few questions and
wondered if someone might offer some insight.
1. Where must the Access db
http://www.cqhost.com/
I have a JSP app hosted there and they are pretty good. They also provide a
MSQL DB
Mark
-Original Message-
From: Ken Anderson <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, March 21, 2002 2:39 PM
Subject: Re: JSP or PHP?
>Klym wro
-
From: Dan Patnaude <[EMAIL PROTECTED]>
To: Mark Stringham <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Wednesday, March 13, 2002 10:41 AM
Subject: Re: mysql hotcopy
>Try the following:
>
>mysqlhotcopy -u root -p /path/to/copy/the/data/to
>
&g
Can anyone give me an example of how to run mysqlhotcopy from the command
line? What can I expect as the output and where is the file created/ stored?
Thanks
Mark
-Original Message-
From: Michael Grassman <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, March 1
Done it with JSP and works very nicely. PHP works fast but I like some of
the JSP functionality better -
Mark
-Original Message-
From: shruti selvaraj <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, February 28, 2002 1:43 PM
Subject: Java and MySQL?
>Hello
www.phpbuilder.com
www.hotscripts.com
www.devshed.com
Good Luck
Mark
-Original Message-
From: Floyd Baker <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, February 26, 2002 6:03 PM
Subject: running mysql w/php..
>
>Hi.. Can anyone tell me some good places
<[EMAIL PROTECTED]>
To: Mark Stringham <[EMAIL PROTECTED]>; MySQL
<[EMAIL PROTECTED]>
Date: Tuesday, February 26, 2002 10:53 AM
Subject: Re: table backups
>1. Task Scheduler. Every 32-bit flavor of Windows has a task scheduler, and
you can have it execute
>batch scripts
2 quick questions -
1. What is the Windows equivelant to a cron job. I would like to perform an
automated back-up of MySQL tables and data on a Win 2K server..
2. Is mysqlhotcopy always performed from the command line?
Thanks
Mark
-Original Message-
From: Victoria Reznichenko <[EMAIL
I am relatively new to MySQL I need to edit my db variables.
How is this done ? From the command line or by editing a file?
My OS is Windows.
Thanks
Mark
-
Before posting, please check:
http://www.mysql.com/manual.php
Anyone know what causes "overhead" on a MySQL table?
I wrote a JSP application using MySQL that uses updates and Inserts and have
found that a lot of "overhead" exists.
Of course if the table is optimized - the overhead is cleared.
Anyone had similar issues?
Thanks
Mark
-
If I run optimize on the table once - will I have to come back and so it
again?
If so - how often?
Thanks
Mark
-Original Message-
From: Matthew Walker <[EMAIL PROTECTED]>
To: Mark Stringham <[EMAIL PROTECTED]>; Scott Wang
<[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[E
Scott -
I recently had a similar problem with a JSP application I built using MySQL
on the backend.
Don't know what the issue is/was but I did notice that if I was updating
rows in a table on a regular basis - PHPmyAdmin 2.2 says I have a lot of
"overhead" in the table. I'm not sure what is causi
What about converting MySQL data to Oracle ?
Thanks
Mark
-Original Message-
From: theOtherOne <[EMAIL PROTECTED]>
To: Ed Lazor <[EMAIL PROTECTED]>; Paul DuBois <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Saturday, January 26, 2002 2:34 PM
Subject: Re: Converting MS
I am running MySQL and using phpmyadmin 2.2 as the GUI.
I noticed that if there is a lot of db activity - the "overhead" increases
on various tables.
What causes "overhead" ? I have looked into the MySQL docs and haven't
really found much of an answer.
Any help is appreciated.
Mark
---
48 matches
Mail list logo