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
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
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
mysql dump
% for a db that is hosted remotely - IE
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
mysql dump
% for a db that is hosted remotely - IE
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
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\binmysqldump -u uipcontent -p test
c:\testdump.sql
the file testdump.sql gets created in the appropriate place but the
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\binmysqldump -u uipcontent -p test
c:\testdump.sql
the file testdump.sql gets created in the appropriate place but the
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\binmysqldump ?
thanks
MS
On Fri, Jan 17, 2003 at 04:12:58PM -0700, Mark Stringham wrote:
sql, query
I'm trying
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\binmysqldump ?
thanks
MS
On Fri, Jan 17, 2003 at 04:12:58PM -0700, Mark Stringham wrote:
sql, query
I'm trying
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
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
-
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,
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
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
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]
To:
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?
Thanks...
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
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 marketing software suite that works well
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, 2002 9:35 PM
Subject: Re: email marketing software
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: Backup
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
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: Wednesday, June 05, 2002 12:25 PM
To: [EMAIL PROTECTED]
Subject: Looking for some help
I am
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 it is
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:
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 your
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
Subject: Re: backup databases
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
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, March 28, 2002 11:52 AM
Subject: Re: SQL query question
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:[EMAIL PROTECTED]]
Sent: Friday, March 22, 2002 3:11 AM
To: MySQL
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 wrote:
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
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 12,
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 password dbname /path/to/copy/the/data/to
so, if you want to copy the db foobar, you do
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 ,
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
[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 which can easily do your MySQL
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 to
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
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
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] [EMAIL PROTECTED]
Date: Tuesday
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 Access
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
47 matches
Mail list logo
