I'd like to use the _rowid capability of MySQL to improve the efficiency of a project,
but I have concerns about the reliability of the number it returns. I understand that
_rowid "may change over time depending on many factors," but I'd like to know whether
this is true if the row is locked.
Not sure I'll be helpful, but I ran into something similar yesterday. Not
exactly sure how I fixed it, but this is what I believe.
1) You should create a virgin data directory per the standard procedures on
the production machine (install_db and safe_mysqld).
2) Then, if you have existing data,
OS: RedHat 6.2 on master and slave
mySQL:3.23.32 on master and slave
Problem: Replication is not working. Symptoms include:
* Connecting OK. 'Show slave status' reports nominally.
* Position on the log file increments correctly when updates occur on the
master.
* The tables do not
: Re: Upgrade and start-up failures
>
>
> It's looking for the "host" table (physical files) within the
> 'mysql' data area
> (not your own data area).
>
> Did you run "mysql_install_db" after installing the new version ?
> (or copy the
> &q
I just upgraded from 3.23.27 to 3.23.32 (can't go higher than that - have to
sync development with production systems).
I copied the /data directory to the new home. When I try to start mySQL, it
halts and the log file has the entry "Can't find file: 'host.ISM' (errno:
2)". I checked the old my
I just upgraded from 3.23.27 to 3.23.32 (can't go higher than that - have to
sync development with production systems).
I copied the /data directory to the new home. When I try to start mySQL, it
halts and the log file has the entry "Can't find file: 'host.ISM' (errno:
2)". I checked the old my
Thanks to Apollo and Lee for fast responses. Both recommended adding
TimeStamp columns to the table. Lee also recommended adding an
auto_increment column.
What actually was the culprit was that in the suspect tables, I had a
Primary Key on a TinyText field. I have not tried (a) converting the
OS: NT 4.0, SP6
MDAC: 2.6
MyODBC: 2.50.36
MS-Access: 2000 (9.0.3821 SR-1)
MySQL-OS: Linux, RedHat 6.2
MySql: 3.23.27-beta
Symptom: Two of seven tables return all columns and rows as "#Deleted" (and
wouldn't you know it, the two most important tables in the database). have
been throu
