Hello,
I'm having trouble copying a database from MySQL 4.1.22 to 5.1.19-
beta. Both are FreeBSD i386-based machines. I have run the
following commands:
mysqlcheck --check-upgrade --all-databases --auto-repair
mysql_fix_privilege_tables
Both executed with no problems. (mysqlcheck
On Jun 21, 2007, at 12:21 PM, Gerald L. Clark wrote:
Seth Seeger wrote:
Hello,
I'm having trouble copying a database from MySQL 4.1.22 to 5.1.19-
beta. Both are FreeBSD i386-based machines. I have run the
following commands:
mysqlcheck --check-upgrade --all-databases --auto-repair
I have successfully used this technique on a RedHat server. (I have
also seen it fail on Mac OSX running VirtualPC.)
What are you using to access MySQL? The command line? (Make sure
it's configured to use port 3306 and not looking for a local socket
file.)
What are the errors given? Can you
Could this be a 'register_globals' issue? (Check your php.ini file.)
Are you sure that the queries you're sending are correct? Is
mysql_query() returning any errors?
Some more information, please!
Seth
On Fri, 1 Oct 2004 23:35:09 -0500, tom miller [EMAIL PROTECTED] wrote:
i'am not sure if
Hi,
I just encountered a similar problem on one of my production servers
this morning. (I'm still investigating the cause.) After doing a
quick bit of Google-searching, this solved my problem:
mysqladmin -u username -p flush-tables
By the way: All directories in /var/lib/mysql should have
I have been experiencing a small problem with altering a table, once it
has been locked. If you alter a table (adding a column) while that table
is locked, subsequent calls to that table result in MySQL erroring, saying
the table was not locked.
I have reproduced this under Windows 2000, running
