Dan Nelson wrote:
In the last episode (Sep 14), John Meyer said:
I'm pulling in a date with the following format
9/14/2009 2:12:48 PM
And using this mask to convert it using the str_to_date() function:
%e %m %Y %r
but it keeps giving me an error. Do I have the right mask?
Nope. Assu
In the last episode (Sep 14), John Meyer said:
> I'm pulling in a date with the following format
> 9/14/2009 2:12:48 PM
> And using this mask to convert it using the str_to_date() function:
> %e %m %Y %r
>
> but it keeps giving me an error. Do I have the right mask?
Nope. Assuming your input st
I'm pulling in a date with the following format
9/14/2009 2:12:48 PM
And using this mask to convert it using the str_to_date() function:
%e %m %Y %r
but it keeps giving me an error. Do I have the right mask?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubs
On Mon, Sep 14, 2009 at 11:15 PM, Kaushal Shriyan
wrote:
> Hi,
>
> I have enabled ubuntu backports in Ubuntu 8.04 to install mysql-5.1
> server, but i dont find it after apt-get update ?
>
> Please suggest/guide
>
> Thanks,
>
> Kaushal
>
Hi, the options from discussion in Ubuntu Forums [0]
1
I tried this but when I upload the backup it just does not look the same.
Thanks,
Nestor :-
On Mon, Sep 14, 2009 at 8:04 AM, wrote:
> Use sqlyog its a freeware
> Sent from my BlackBerry® on Reliance Mobile, India's No. 1 Network. Go for
> it!
>
> -Original Message-
> From: Néstor
> Da
I did it again and using sqlyog did work.
I also found out that the tool that comes with mysql admin 1.1 also has
a backup tool that works.
Thanks to all,
Nestor :-)
On Mon, Sep 14, 2009 at 9:16 AM, Néstor wrote:
> Sorry, I meant to say that the backup DB does not look the same as the
> origi
Hi,
I have enabled ubuntu backports in Ubuntu 8.04 to install mysql-5.1
server, but i dont find it after apt-get update ?
Please suggest/guide
Thanks,
Kaushal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=ar
On Mon, Sep 14, 2009 at 8:28 AM, Michael Dykman wrote:
> If I may,
>
> If you have foreign keys on your InnoDB, you can still import your
> data to MyISAM but foreign keys will be lost. Otherwise, the data
> will load just fine.
Very good point. My comment was based on the possibly erroneous
as
If I may,
If you have foreign keys on your InnoDB, you can still import your
data to MyISAM but foreign keys will be lost. Otherwise, the data
will load just fine.
- michael dykman
On Mon, Sep 14, 2009 at 11:14 AM, Todd Lyons wrote:
> On Mon, Sep 14, 2009 at 7:44 AM, Néstor wrote:
>> Maybe o
Sorry, I meant to say that the backup DB does not look the same as the
original DB.
Maybe it has to do with what Todd and Mychael mentioned.
The percona tool does not work on Windows OS. I could not find a windows
executable.
Thanks,
Nestor :-)
On Mon, Sep 14, 2009 at 9:13 AM, Néstor wrote:
>
On Mon, Sep 14, 2009 at 7:44 AM, Néstor wrote:
> Maybe one of you experts know the answer.
>
> I have a Innodb database that I want to back up. Is there a free tool to
> do this?
> mysqlhotbackup is a paid tool, is that the only one available?
You can also use the free tool from Percona which c
Maybe one of you experts know the answer.
I have a Innodb database that I want to back up. Is there a free tool to
do this?
mysqlhotbackup is a paid tool, is that the only one available?
If I do a mysqldump of the innodb databse, will I be avail to uploaded into
a myisam
database and will it wo
A mysqldump will work just fine. By default, that dump is going to
explicitly specify the table type .. you will have to edit it if you
want to import to MyISAM.
- michael dykman
On Mon, Sep 14, 2009 at 10:44 AM, Néstor wrote:
> Maybe one of you experts know the answer.
>
> I have a Innodb d
Hi everyone,
I have an application that spawns various threads for inserting into various
table. Additionally, another thread is launched to delete old records.
They all use JPA and entity managed transactions. I think I'm getting
locking issues, but I'm not sure. So, I'd like to get your thoug
>-Original Message-
>From: AndrewJames [mailto:andrewhu...@gmail.com]
>Sent: Saturday, September 12, 2009 1:20 AM
>To: Kyong Kim; Arthur Fuller
>Cc: Claudio Nanni; mysql
>Subject: Re: database design
>
>thank you all, i think
>
>"You probably wouldn't need Article_Type table if you're going
You can't make the database, table or field names dynamic with
prepare, only values. Prepare allows you to cache the execution plan,
which wouldn't be valid on a different table.
On Mon, Sep 14, 2009 at 7:09 AM, Manasi Save
wrote:
> Hi All,
>
> I have a query about prepare statement of mysql. I w
Hi guys,
I am getting very frequent deadlock in mysql 5.1.37. I am not able to
understand why this below deadlock is coming.
*** (1) TRANSACTION:
TRANSACTION 0 1036157191, ACTIVE 0 sec, process no 4101, OS thread id
1908412736 fetching rows
mysql tables in use 1, locked 1
LOCK WAIT 3 lock struct(
17 matches
Mail list logo
