Hi All,
We have an application where we load data on a daily basis and then do some
analysis and the move this data into different tables.
Data is comming in files. The date format in the file is "dd-mon-
hh24:mi:ss', but as you all know, in mysql , the default date format is
"-mm-dd hh
In the last episode (Jul 10), Andrey Dmitriev said:
> How do I view and backup my procedural code?
>
> In oracle it would be something like
> Select text from user_source where name='MY_PROCEDURE' order by line;
>
> I did mysqldump, and didn't see any of the functions or procedures
> created.
>
How do I view and backup my procedural code?
In oracle it would be something like
Select text from user_source where name='MY_PROCEDURE' order by line;
I did mysqldump, and didn't see any of the functions or procedures
created.
In Oracle they'd be backed up either via RMAN or EXP.
Thanks,
Andr
A quick script solution:
create a dump pr. table in .
#!/bin/bash
for tbl in `echo "use ;show tables;"|mysql -s -u -p`
do
mysqldump -u p db $tbl > $tbl.sql
done
and the other way:
cat | mysql -u -p
On Tue, July 10, 2007 15:47, Rolando Edwards wrote:
> When the mysqldump ran against all
#!/usr/bin/perl
#dump all files
@db=`mysql -e -ppassword "show databases" | sed "s/-//g" | sed "s/
//g"`;
foreach $db(@db){
chomp($db);
`mysqldump $db -ppassword > $db.sql`;
}
#multiple files will load simultaneously. multiple processes should run
much faster
foreach $db(@db){
hey all. Let me throw out a quick question. We are upgrading from some version
of 4.1 to the latest version of 5.0. MySQL recommends that you dump and
re-import data with this type of move. Not only do they recommend the
dump/import - it would be nice to optimize all our tables at the same time!
No.
Transactions involve only one machine.
Furthermore, writing to the master and then reading from a slave runs the
risk of replication delays. Granted, delays are usually sub-second, but if
something big goes thru replication, it can get behind. Your application
should understand the delay an
Hi Scott,
Scott Haneda wrote:
Is it possible to use user variables in an update statement, I can find only
scant docs on it, but they do not pertain to what I am trying to do.
Given this select:
SELECT user_id, order_status, quantity_chosen, month_price, each_price,
sales_tax, sales_tax_rate,
On 7/10/07, Octavian Rasnita <[EMAIL PROTECTED]> wrote:
I have exported a database using mysqldump from MySQL 5.0.27, and I have
tried importing it in a MySQL 5.0.41, but it gives the following error:
ERROR 1071 (42000) at line 483: Specified key was too long; max key length
is 1000 bytes
Hi
Is it possible to use user variables in an update statement, I can find only
scant docs on it, but they do not pertain to what I am trying to do.
Given this select:
SELECT user_id, order_status, quantity_chosen, month_price, each_price,
sales_tax, sales_tax_rate,
@NEW_each_price:=(each_price + .0
On Tue, 10 Jul 2007 [EMAIL PROTECTED] wrote:
=>Thanks for your response, Rolando. I know all the DML to create the
=>database is in the mysqldump. I was looking for a command or command
=>options, if there are any, to extract the DML for the database, like what
=>you can do with mysqlbinlog.
=>
Prepared Statements with the IN function worked beautifully. Performance
is slightly degraded, but I get the functionality I want and can live with
the slight performance hit.
Thanks again.
Dave
> Hi Dave,
>
> Dave G wrote:
>> Hello all,
>>
>> I'm trying to do some processing on the front end t
Thanks for your response, Rolando. I know all the DML to create the
database is in the mysqldump. I was looking for a command or command
options, if there are any, to extract the DML for the database, like what
you can do with mysqlbinlog.
- Message from Rolando Edwards <[EMAIL PROTECTED]> o
Thank you Baron, I'll give that a shot, and thanks for the IN() list tip
... much appreciated.
Dave
> Hi Dave,
>
> Dave G wrote:
>> Hello all,
>>
>> I'm trying to do some processing on the front end to optimize my query
>> on
>> the backend. I would like to generate a list of id's for this query
Hi Dave,
Dave G wrote:
Hello all,
I'm trying to do some processing on the front end to optimize my query on
the backend. I would like to generate a list of id's for this query like
so:
SELECT REPLACE('3,4,5,6,7,8,9',',',' OR element_id=') INTO @tmp;
Then use it like:
mysql> select @tmp;
+--
Hello all,
I'm trying to do some processing on the front end to optimize my query on
the backend. I would like to generate a list of id's for this query like
so:
SELECT REPLACE('3,4,5,6,7,8,9',',',' OR element_id=') INTO @tmp;
Then use it like:
mysql> select @tmp;
+
I am running a fairly large Innodb database on mysql 5.x and would like
to know what would be the best variables to monitor (for Nagios)- for
instance: threads
connected,Innodb_data_pending_reads,Innodb_data_pending_writes, slow
queries etc
Aborted_clients
Aborted_connects
Binlog_cache_disk_
When the mysqldump ran against all databases, the USE command should
have appeared above each section of that databases dump. Try using Perl or the
head or tail Unix command to hunt down the Database you are dumping. Read all
lines until the next USE command.
Example: If you mysqldumped datab
Question: How do I restore 1 database from amysqldump of all databases?
Obviously a newbie. I've searched the list but couldn't find the answer.
Can someone help?
Waldo Tumanut
Database Analyst
CONFIDENTIALITY NOTICE: This electroni
Are you using MySQL Administrator for Windows ?
Are you using it against MySQL running in Linux ?
If so, you may prefer MySQL Administrator for Linux.
Just a couple more thoughts ...
- Original Message -
From: "cfaust-dougot" <[EMAIL PROTECTED]>
To: "Weiqi Wang" <[EMAIL PROTECTED]>, mysq
Hi,
I have exported a database using mysqldump from MySQL 5.0.27, and I have
tried importing it in a MySQL 5.0.41, but it gives the following error:
ERROR 1071 (42000) at line 483: Specified key was too long; max key length
is 1000 bytes
Isn't mysqldump exporting the data correctly?
Can I
Hi,
Is it possible to have a transaction with an update statement pointed to
the master and a select statement pointed to the slave. If the isolation
level of this transaction is REPEATABLE_READ or SERIALIZABLE, will a
commit involve 2PC?
Thanks,
Darpan
--
MySQL General Mailing List
For list
22 matches
Mail list logo
