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.
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 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
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
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
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
mysql subdirectory from the old version)
Guy Smith wrote:
I just upgraded from 3.23.27 to 3.23.32 (can't
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