- Original Message -
From: Halász Sándor h...@tbbs.net
Therefore, it well may be easier to do it all in PHP, since therewith
I agree with the assessment, but I take issue with this whole do it in
PHP/Python/language-of-the-month.
Why would I want to install PHP, Python or whatever on
The original problem is traditionally resolved by partitioning the tables by
historical range and creating a database job/event to drop older partitions and
add the new ones. Depending on the environment, some might prefer shell
scripts to do essentially the same.
On Jan 27, 2012, at 3:08
Am 26.01.2012 18:45, schrieb HalXsz SXndor:
20120126 10:34 AM +0200, a bv
Database contains
tables (structures?) which gets montly data , and these tables are
named as
name1_name2_ yearmonth . I only want to have the whole database system
for last 2 years, and automaticly clean the data
20120126 10:34 AM +0200, a bv
Database contains
tables (structures?) which gets montly data , and these tables are
named as
name1_name2_ yearmonth . I only want to have the whole database system
for last 2 years, and automaticly clean the data which became more
than 2 years old , so i need a
On Fri, Nov 18, 2011 at 1:32 PM, a bv vbavbal...@gmail.com wrote:
Hi,
I have a linux box running mysql plus phpmyadmin which has tables
getting montly data and when a new month starts a new table is
created. I want to store only 2 years of data so when a new month
starts i need to drop
Hi unknown,
Have a look at database information_schema.TABLES:
SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA='database';
As long as your MySQL version is = 5.1, you don't need a cron script,
you can use the MySQL scheduler, create a stored procedure that will run
each month. You'll
- Original Message -
From: Adarsh Sharma adarsh.sha...@orkash.com
Please check the attachment for the script output.
Thanks for your password :-)
Now I just want to mail the output of my script to some persons
e-mail-ID
Assuming you run this from crontab, just set
Hi Travis,
Thanks a lot for your help,
Can i have a same scrip for windows OS.
On Sat, Jul 31, 2010 at 3:29 AM, Travis Ard travis_...@hotmail.com wrote:
Something like this mysql-summary script might be useful:
http://code.google.com/p/aspersa/wiki/mysql_summary
-Travis
Sorry, I am not aware of a windows-specific version. You might check with the
script author, or you may be able to get this to work on windows by installing
cygwin and using a bash shell.
-Travis
Date: Mon, 2 Aug 2010 12:20:57 +0100
Subject: Re
PRATIKSHA JAISWAL schrieb:
Hi List,
Can somebody please help me if they have a script using which we can get an
idea for installed mysql server, backup, created databases, indexes, tables,
engines, replication etc...
I will appreciate your help in advance
You can find tons of
Something like this mysql-summary script might be useful:
http://code.google.com/p/aspersa/wiki/mysql_summary
-Travis
Date: Fri, 30 Jul 2010 12:19:07 +0100
Subject: script of mysql
From: pratikshadjayswa...@gmail.com
To: mysql@lists.mysql.com
Hi
If you want to track the schema level changes, updates, inserts etc you
always have the binlogs/update logs. If you want to track select queries
also you have the general query log. Check out
http://dev.mysql.com/doc/refman/4.1/en/log-files.html for the different logs
available. Of course be wary
Hi Krishna,
you can use MySQL binlog to see queries that made changes to db data
Hope it helps
Regards
Krishna Chandra Prajapati ha scritto:
Hi All,
Is there is any script or tool that generate the report and send an email
for changes done in the databases;
There is any otherway
Hi All,
Also, i guess u can use tools like TOAD or sqltools to get reports on db
changes.
regards
anandkl
On 8/29/07, Edoardo Serra [EMAIL PROTECTED] wrote:
Hi Krishna,
you can use MySQL binlog to see queries that made changes to db
data
Hope it helps
Regards
Krishna Chandra
perl ?
just quickly throwing something together - this is untested.
$done = 0;
$count = 0;
while ($done) {
$dbh-do(analyze table t1);
my $info = $dbh-{mysql_info};
if ($info =~ /some kind of error message/) {
$dbh-do(repair table t1);
my $info2 =
Jon Miller wrote:
Having an error in a script that I cannot figure out why it's not working. The problem
is on line 15 while ($row = mysql_fetch_object ($result)).
What, exactly is the error?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
A couple of things.
first: as documented in http://ca3.php.net/mysql_connect, the third
(optional) parameter is supposed to be the password, so if the password
for root has been left blank, this connect statement cannot succeed. It
may well be the only immediate problem.
second:
Philippe Poelvoorde wrote:
mysql system echo hi there;
mysql system ls -ls;
mysql system uname-a;
all work on the 2.4.22-10mdk kernel and
the semi-colon is optional.
mysql system echo hi there
should be also working, the first parameters 'echo' is recognized as the
command to execute, and the
Just so everyone is up to speed: The system client command is only
available on Unix-like systems.
To quote: http://dev.mysql.com/doc/mysql/en/mysql_Commands.html
The edit, nopager, pager, and system commands work only in Unix.
So depending on your OS, that command may or may not be
mysql system echo hi there;
mysql system ls -ls;
mysql system uname-a;
all work on the 2.4.22-10mdk kernel and
the semi-colon is optional.
mysql system echo hi there
should be also working, the first parameters 'echo' is recognized as the
command to execute, and the folowings strings the
Hi Rhino,
This works, however I can't remember how to suppress the column heading.
If you can do that, you can put anything you like in.
[EMAIL PROTECTED] loganda]$ echo set @thing='here we go';select
@thing| mysql -u root -p outfile
Enter password:
[EMAIL PROTECTED] loganda]$ cat outfile
After re-reading your email in not so quite a rush 8-)
Further to that, you can use the system command to run an OS command
eg. system echo thing;
mysql system echo thing;
thing
mysql
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
- Original Message -
From: Logan, David (SST - Adelaide) [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; mysql [EMAIL PROTECTED]
Sent: Monday, October 18, 2004 8:09 PM
Subject: RE: Script question
After re-reading your email in not so quite a rush 8-)
Further to that, you can use the system
Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 19 October 2004 9:53 AM
To: Logan, David (SST - Adelaide); mysql
Subject: Re: Script question
Sorry, you still
executed successfully via:
mysql -u myid -pmypass Load.sql Load.out
Rhino
- Original Message -
From: Logan, David (SST - Adelaide) [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; mysql [EMAIL PROTECTED]
Sent: Monday, October 18, 2004 8:09 PM
Subject: RE: Script question
After re-reading your
of the Unix platforms but not Mandrake
9.1??
Rhino
- Original Message -
From: Logan, David (SST - Adelaide) [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; mysql [EMAIL PROTECTED]
Sent: Monday, October 18, 2004 8:31 PM
Subject: RE: Script question
The only way to mix and match with an .sql
PROTECTED]; mysql [EMAIL PROTECTED]
Sent: Monday, October 18, 2004 8:31 PM
Subject: RE: Script question
The only way to mix and match with an .sql script would be to use the
system command. The example I showed below would echo the text required
and that would be diverted to Load.out file eg
-
From: Brian [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Cc: Logan, David (SST - Adelaide) [EMAIL PROTECTED]; mysql
[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 9:09 PM
Subject: Re: Script question
try:
system echo hi there;
without the single quotes :)
On Mon, 18 Oct 2004 21:04:19 -0400
- Adelaide) [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; mysql [EMAIL PROTECTED]
Sent: Monday, October 18, 2004 8:31 PM
Subject: RE: Script question
The only way to mix and match with an .sql script would be to use the
system command. The example I showed below would echo the text
required
9:09 PM
Subject: Re: Script question
try:
system echo hi there;
without the single quotes :)
On Mon, 18 Oct 2004 21:04:19 -0400, Rhino [EMAIL PROTECTED] wrote:
I thought you'd nailed it when I read your note but I found that your
suggestion didn't work.
When I tried
Thanks, Charles! Your suggestion about removing the quotes and apostrophes
altogether did the trick!
Rhino
- Original Message -
From: Sweet, Charles E [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]
Sent: Monday, October 18, 2004 9:22 PM
Subject: RE: Script question
Brian mailto:[EMAIL
Hi Luis,
I've made a small script to do this, it's in the 'backing up mysql
databases' on http://www.control-alt-del.org/code
Basically, you probably want to save the binary logs by archiving
them (in case of a database crash). On a binary log I get about
60-80% compression ratios, so it's worth
We delete all binlogs over 7 days old.
We figure that if a slave gets that far behind, it is easier and faster to
restore last nights master backup and edit the master.info file on the
slave to
point to todays log file.
Luis Mediero wrote:
Hi,
I would like write a script to purge every
On Wed, Jul 07, 2004 at 07:42:46PM +0200, Luis Mediero wrote:
Hi,
I would like write a script to purge every nigth the master log with a cron
process. I need do it every nigth after load a lot of data into the master.
I know if i do 'show master status' i can see the file_name of the
Joseph Maxwell wrote:
Hello,
Could someone recommend a decent php script that could be used for
database[MySQL]::Web interfacing and management. Preferably open source,
freeware or otherwise [I'll just have to grin bare it]
phpMyAdmin - www.phpmyadmin.net
--
Sebastian Mendel
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 25, 2002 9:51 AM
To: Mysql maillist
Subject: script
Hi All.
I have written a SQL script that should retrieve all the rows from a
table that match a value given as parameter by the
I suggest you to copy the database files. If you are
the administrator in a Linux system make a cron once
(for example) a week to copy this files to somwere
else.
--- Kai Vermehr [EMAIL PROTECTED] : is there any
single MySQL script that would backup
my complete database?
thanks! Kai
use mySQLdump.
c:\mysql\bin\mysqldump.exe
there is a switch for dumping the whole DB.
heh,
.b
-Original Message-
From: Kai Vermehr [mailto:[EMAIL PROTECTED]]
Sent: 03 September 2002 13:10
To: MySQL List
Subject: script for complete Database dump?
is there any
Kai,
Tuesday, September 03, 2002, 3:09:45 PM, you wrote:
KV is there any single MySQL script that would backup my complete database?
What about mysqldump?
http://www.mysql.com/doc/en/mysqldump.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This
Here's a trivial example. Run something like this out of cron every
night.
--- cut
#!/bin/sh
DATE=`/bin/date +%Y-%m-%d`
mysqldump -u root -p [password] --all-databases --opt \
/path/to/large/partition/backup_${DATE}.sql
--- cut
-Original Message-
From: adi [mailto:[EMAIL
: Gerald R. Jensen [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 9:49 PM
To: Chetan Lavti; [EMAIL PROTECTED]
Subject: Re: Script for Data base backup and recovery : Very essential
This has been covered here a number of times before ... a search of the
archive avoids the need to repeat
This has been covered here a number of times before ... a search of the
archive avoids the need to repeat the same info.
That being said ...
We use a cronjob (root) that calls a shell script at 3am daily.
The line in the cronjob is:
* 3 * * * /usr/local/bin/dbbakup.sh username password
The
One way is to include it in your mysql start command:
mysql -u user -ppassword scriptfilename
You may have to include the path with the scriptfilename.
regards,
det
On Sat, 23 Feb 2002 13:21:27 +0530, Chetan Lavti wrote:
hi,
I have written a script for database creation and table creation.
43 matches
Mail list logo