rejected by oracle.
-Syd
- Original Message
From: Kevin (Gmail)
To: Johan De Meersman ; Shawn Green (MySQL)
Cc: Sydney Puente ; mysql@lists.mysql.com
Sent: Wed, 17 November, 2010 18:17:38
Subject: Re: export db to oracle
Hello,
It should be possible to connect Oracle to the MySQL
Hello,
How can I export a mysql 5.0.45 db to Oracle? mysql is going to stau but I need
to pass the data to oracle, just so the data can be transfered.
I have carried out a mysql dump. This seems fine.create table etc. about 20 MB
in total.
Any ideas? It is on Redhat if that makes a difference.
| ON |
| innodb_thread_concurrency | 8 |
| innodb_thread_sleep_delay | 1 |
+-++
36 rows in set (0.00 sec)
From: Johan De Meersman
To: Sydney Pue
,0),('Test1',1258368158,4,0),('Test1',1258368169,1,0)...
...
TIA
Syd
From: Johan De Meersman
To: Sydney Puente
Cc: a.sm...@ukgrid.net; mysql@lists.mysql.com
Sent: Wed, 26 May, 2010 11:35:22
Subject: Re: source backup.sql - troubleshoot
The "use event" statement
: Johan De Meersman
To: a.sm...@ukgrid.net
Cc: Sydney Puente ; mysql@lists.mysql.com
Sent: Wed, 26 May, 2010 10:15:47
Subject: Re: source backup.sql - troubleshoot
On Wed, May 26, 2010 at 10:54 AM, wrote:
>
>Actually Im assuming a DB name of "source", which I mentioned in
Hello,
I have a mysqldump file created by AutoMySQLBackup.
And it hangs when I do a
mysql > source backup.sql
It is 32 MB - it creates 4 tables and after creation of each table it populates
it.
Actually it only creates the 1st table before hanging.
My first thought is it would be nice to echo e
query log for
identifying problems and performance tuning.
Take a look at the manual(http://dev.mysql.com/doc/refman/5.1/en/)! You
can get answers to questions like this so much quicker from there.
Regards
John Daisley
On Fri, 2009-11-13 at 16:43 +, Sydney Puente wrote:
> OK thanks to some he
OK thanks to some help from this list I now have a blank my.cnf file in /etc
And I want to set up logging of all sql queries.
So I have tried:
SET GLOBAL general_log = 'ON';
and/or putting (only) /var/log/mysql/mysql.log
in my.cnf and doing a restart via /etc/init.d
(have a pid file now -Ta!)
Yes I enter the password manually into the remote mysql client (actually
Oracle's SQL developer) when I login.
I thought I would restart mysql with the /etc/init.d/mysql script and go back
to the original "default" settings without any my.cnf present. Just to check it
was some setting in my.cnf
|
+--+
mysql> select host from mysql.user where user = 'root';
+---+
| host |
+---+
| % |
| 127.0.0.1 |
| localhost |
| object01 |
+---+
Sydney Puente schrieb:
> Hello,
> I want to log all sql queries made against a mysql db.
> Goo
Hello,
I want to log all sql queries made against a mysql db.
Googled and found I should add a line to my.cnf.
However I cannot find a my.cnf file
[r...@radium init.d]# ps -ef | grep mysql
root 13614 1 0 Sep24 ?00:00:00 /bin/sh /usr/bin/mysqld_safe
--datadir=/var/lib/mysql --pid-
Hello,
I am getting an error
#HY000Incorrect string value: '\xE9l\xE9tra...' for column '
Not quite sure why. hex E9 is a lower case e acute found in CP1252
and googling seems to tell me that the latin1 charset that I have set for the
table should display this OK.
mysql V 5.0.54a on Redhat 5.
At 05:57 AM 11/5/2009, you wrote:
>Hello, I am currently inserting about 10 rows (2 varchar 50 fields ) a sec
>into modern 4 processor RH 5.x box using perl Net::Mysql from another box
>of similar spec. This is rather less than expected. I suspect I
>could push the inserts from the source box
ou working in?
>- michael dykman
>On Fri, Oct 30, 2009 at 12:06 PM, Sydney Puente wrote:
>> Hello,
>>
>> I am populating mysql with data, from an external source, that now and again
>> in
>> different fields has single quotes within the data intended to be ins
Hello,
I am populating mysql with data, from an external source, that now and again in
different fields has single quotes within the data intended to be inserted into
varchars.
This causes a sql parse error.
Is there are smart way of dealing with this?
TIA
Syd
worst I could tail a log file.
TIA
Syd
>Hi,
>mysql> show warnings;
>BR
>johan
Sydney Puente wrote:
> Hello,
>
> I have an application which is inserting rows into a Mysql 5.024 db.
> It seems to stop when an insert generates a warning.
> when I insert the suspect
Hello,
I have an application which is inserting rows into a Mysql 5.024 db.
It seems to stop when an insert generates a warning.
when I insert the suspect line on the mysql commandline I get this:
Query OK, 1 row affected, 1 warning (0.05 sec)
Other inserts that succeed seem not to generate warni
> However sync's from MS SQL to MYSQL are required every 24 hours after the
> initial
> dataload.
> And this has me puzzled.
> Advice anyone?
> Please ;-)
If there's a auto-inc key, you can find the last one from the
MySQL_table then SELECT ... from MSSQL_table where key > found_key.
Otherwise
Hello,
I have a task in hand to pull 3 tables of data from a MS SQL db and populate a
mysql 5.x db.
So I plan to use perl DBI for yank the data out of MS SQL and push it into
MYSQL.
I think I can handle the mysql table creation and any tweaking that might be
required to carry out the initial da
19 matches
Mail list logo
