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 |
+---+
> > 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,
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
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
>> 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)
...
> 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
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
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
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
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
> 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
11 matches
Mail list logo