Re: Bizarre table type switch

--- Stuart Felenstein <[EMAIL PROTECTED]> wrote: > I'm not sure what happened but when I ran some test > yesterday on a "transaction" it failed. Being > puzzled > I started digging around. I have come to find out > that all the tables involved were now set to MyISAM. > > Obviously transactions

Re: about berkeley db

In the last episode (Nov 29), ?? ?? said: > i create some .db files with berkeley db programm(the berkelek just create > db files,without frm files).the problem is i can't use mysql to open it > .and the mysql create a berkeley db with db files and the frm flie.how can > i use the mysql to open

Bizarre table type switch

I'm not sure what happened but when I ran some test yesterday on a "transaction" it failed. Being puzzled I started digging around. I have come to find out that all the tables involved were now set to MyISAM. Obviously transactions wouldn't work. The odd thing that I'd like to figure out is ho

about berkeley db

i create some .db files with berkeley db programm(the berkelek just create db files,without frm files).the problem is i can't use mysql to open it .and the mysql create a berkeley db with db files and the frm flie.how can i use the mysql to open an berkeley db files??? the version of mysql i use

Re: Using epoch date instead of calendar date

So phpnuke just a a string representation... As far as I know, It's not possible to do it with just MySQL, though there may be some function I'm not aware of. The Unix binary `strtotime`, used to convert a multitude of readable date formats into a Unix timestamp, should be able to do that. So yo

Re: timestamp and DST: impossible to backup database? *AND* bugs in TIMEDIFF, FROM_UNIXTIME, et.al.?

Peter Valdemar Mørch wrote: From the lack of responses I take it that nobody disagrees that the handling of the timestamp type is fundamentally broken in every version of MySQL. Silence does not necessarily indicate assent. You asked a complicated question (when the U.S. list members were on h

Re: How to retrieve constraints and links from MySQL tables?

Varakorn Ungvichian wrote: --- Michael Stassen <[EMAIL PROTECTED]> wrote: Varakorn Ungvichian wrote: Just realised something: my table was MyIsam. I switched it to InnoDB (which support FKs), but now: 1. "Show Create Table" still doesn't show reference links, and Well, of course not. It won't sh

Re: Using epoch date instead of calendar date

> > I am testing moving from a phpnuke site to a xoops site. In doing so, I > > am trying to get the user table moved over. > > > > I see in the phpnuke tables (which a similar table exists in xoops) > > that the users have a sign up date. The date in phpnuke is the > > calendar day, May 1, 2004,

Re: Using epoch date instead of calendar date

In the last episode (Nov 28), Eric Wagar said: > I am testing moving from a phpnuke site to a xoops site. In doing so, I am > trying to get the user table moved over. > > I see in the phpnuke tables (which a similar table exists in xoops) > that the users have a sign up date. The date in phpnuk

Re: How to retrieve constraints and links from MySQL tables?

--- Michael Stassen <[EMAIL PROTECTED]> wrote: > > Varakorn Ungvichian wrote: > > Just realised something: my table was MyIsam. I > > switched it to InnoDB (which support FKs), but > now: > > 1. "Show Create Table" still doesn't show > reference > > links, and > > Well, of course not. It won't

Re: Using epoch date instead of calendar date

Looking at the structure of xoops.users shows the users_regdate as int(10), and phpnuke.users is varchar(20). This means that phpnuke.users would need to be ||UNIX_TIMESTAMP(). And, I see in the MySQL book (2nd ed., pg 828) that UNIX_TIMESTAMP works with date-time or timestamp format of ccyymm

Re: Using epoch date instead of calendar date

I don't have experience with either of those programs, but I think you can convert them. It looks like phpnuke is keeping the date in a DATE (or maybe a DATETIME or TIMESTAMP) column and xoops is keeping the date in an INTEGER column in Unix timestamp format. If both of those are true then you

Using epoch date instead of calendar date

I am testing moving from a phpnuke site to a xoops site. In doing so, I am trying to get the user table moved over. I see in the phpnuke tables (which a similar table exists in xoops) that the users have a sign up date. The date in phpnuke is the calendar day, May 1, 2004, for example. In xo

Re: Fatal error: Can't open privilege tables: File '/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2)

Have you run mysql_install_db yet? Have you read the freebsd platform notes and the post-install instructions ? If not, I'd suggest starting there. If that doesn't help, write back with s

Re: latin1/utf-8 problem

--- On Saturday 27 November 2004 12:52, Gleb Paharenko wrote: | Hello. | | Strange behavior. You said that both servers configured to use latin1? | What output produced Can only do with for the local server, access is denied to the mysql shell on the shared hosting. But it's the l

Fatal error: Can't open privilege tables: File '/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2)

Hi I am trying to run mysql 4.0.21 server on a freeBSD 5.3 box. I tried to run mysqld_safe to add a root password but i can't seem to run the safe command because it shuts down immediately. The following error is presented to me: Fatal error: Can't open privilege tables: File '/usr/local/share/m

Problems with MySQL 4.1.7 under Solaris 9

Hello I have two problems with latest MySQL (4.1.7) under Solaris 9. I am using SUN provided C compiler (cc: Sun C 5.6 2004/07/15) to compile packages. I need urgently to use MySQL, so any fast response will be highly appreciated. First problem is, that when I try to compile MySQL 4.1.7 from sou

Re: Newbie: How to deal with multiple languages

- Original Message - From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, November 27, 2004 5:36 AM Subject: Re: Newbie: How to deal with multiple languages > Hello. > > You can find an answer here: > > http://dev.mysql.com/doc/mysql/en/Charset.html > > M

Re: How to retrieve constraints and links from MySQL tables?

Varakorn Ungvichian wrote: Just realised something: my table was MyIsam. I switched it to InnoDB (which support FKs), but now: 1. "Show Create Table" still doesn't show reference links, and Well, of course not. It won't show them until you create them, which you haven't done according to #2. 2.

Re: latin1/utf-8 problem

Hello. Strange behavior. You said that both servers configured to use latin1? What output produced show variables like '%char%'; show variables like '%colla%'; show create database 'database_name'; show create table 'table_name'; on both servers? Also send your my.cnf files.

Re: I want cluster, can I use MySQL?

Koon Yue Lam <[EMAIL PROTECTED]> wrote: Hello. You should have more than 4GB RAM total on your nodes. There is a very interesting thread, which will give you answers on many of your questions. http://lists.mysql.com/mysql/166116 >Thanks, >and I know if I use MySQL cluster, I need to h

Re: Newbie: How to deal with multiple languages

Hello. You can find an answer here: http://dev.mysql.com/doc/mysql/en/Charset.html MySQL supports column character sets on columns of some types (char,varchar,text). Probably if I were you I would use Unicode in my application. Graham Anderson <[EMAIL PROTECTED]> wrote: > I have

Re: How to retrieve constraints and links from MySQL tables?

> Just realised something: my table was MyIsam. I > switched it to InnoDB (which support FKs), but now: > 1. "Show Create Table" still doesn't show reference > links, and > 2. I can't seem to make foreign keys, because it > generates the error: "ERROR 1005: Can't create table > '.\ltab\#sql-60c_1

--flush option and fsynch option for innodb engine

Dear All, We are using mysql ver 4.0.17 on lunux with external SCSI media for db storage. We are using innodb engine and we experience that the db processes still services some transactions even when the scsi media on which db resides is physically disconnected. Would anybody throw lig

Re: How to retrieve constraints and links from MySQL tables?

Just realised something: my table was MyIsam. I switched it to InnoDB (which support FKs), but now: 1. "Show Create Table" still doesn't show reference links, and 2. I can't seem to make foreign keys, because it generates the error: "ERROR 1005: Can't create table '.\ltab\#sql-60c_11.frm' (errno: 1