ERROR 1063 (4200) when trying to drop a user

2005-05-06 Thread Eric Wagar
I am trying to drop a user via: mysql> drop user 'wiki_user'; ERROR 1268 (HY000): Can't drop one or more of the requested users The relevant user table: mysql> select host,user from user; +---++ | host | user | +---+

Re: Using epoch date instead of calendar date

2004-11-28 Thread Eric Wagar
> > 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

2004-11-28 Thread Eric Wagar
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

Using epoch date instead of calendar date

2004-11-28 Thread Eric Wagar
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

table field order

2004-11-22 Thread Eric Wagar
>> I am moving a table from a 3.23.56 db to a 4.1.7 db.  I currently only >> testing to see if I can.  So far, I have been able to create the receiving >> table, but not be able to insert the data.  (The only difference I see when >> using phpMyAdmin is the collation column on the 4.1.7 server) ...

Re: loading data file causes errors

2004-11-21 Thread Eric Wagar
> I am moving a table from a 3.23.56 db to a 4.1.7 db. I currently only > testing to see if I can. So far, I have been able to create the receiving > table, but not be able to insert the data. (The only difference I see when > using phpMyAdmin is the collation column on the 4.1.7 server) > > Whe

loading data file causes errors

2004-11-21 Thread Eric Wagar
I am moving a table from a 3.23.56 db to a 4.1.7 db. I currently only testing to see if I can. So far, I have been able to create the receiving table, but not be able to insert the data. (The only difference I see when using phpMyAdmin is the collation column on the 4.1.7 server) When I try

Where to start for performance issues?

2004-06-20 Thread Eric Wagar
I have a Sun Netra T1 with 512MB of ram and 2 x 9G drives. (One is exclusively the MySQL 3.23.56 files, and the other is OS, Apache, etc.) I am also using the default medium (I think) my.cnf. Currently, the complaints are coming from a php Forum and a php picture Gallery. From the OS side, I

RE: Migrate from one MySQL table format to another

2004-02-16 Thread Eric Wagar
rigues - Original Message - From: "Eric Wagar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 16, 2004 10:43 PM Subject: Migrate from one MySQL table format to another Where do I find information on how to move data from one table format to

Migrate from one MySQL table format to another

2004-02-16 Thread Eric Wagar
Where do I find information on how to move data from one table format to another? I have a phpnuke site that uses a certain Journal program, and we'd like to use a new Journal program. Unfortunately, the tables and resulting structure are not the same. And, since they don't use the same tables/s

RE: Log Files in MySQL

2003-12-30 Thread Eric Wagar
> I think I am confused. I have many bin index files, but I have not gotten rid of them. > > I read somewhere that I should not remove them...or I should not remove the entries in the index file. > > Since I am unsure of which one above is correct, I am posting to the list. > > Can someone let