RE: Upgrading How To

Reindl, I am sorry, in my original post, I forgot to mention that the OLD box and the NEW box are the same physical machine. I need to be able to save all data into files on a memstick or portable disc and restore them to the newly staged machine (with the new version of mysql). -Grant --

Re: Upgrading How To

Shawn all, Thank you for taking to time to reply. So, to be clear, what I understand from your post is that replacing the new build's grant/system tables with the archived ones from the previous version, generally works fine, upgrade issues not withstanding. This is the answer I

Upgrading How To

Hi all, I was wondering if anyone knows of a concise tutorial on how to upgrade (by moving from one box (old) to another box (new) mysql in a virtual environment (many mysql users, many databases). Example: Mysql 5.x setup on freebsd 8.x (x86/32b), call this box A. Want to move to

Mysql 4 to 5

Hi all, I recently migrated a script called perldesk from mysql 4 to mysql 5. When I envoke the script from the web, I am now getting an error. I suspect its a version syntax thing. Here is what I see: Couldn't execute statement: You have an error in your SQL syntax; check the manual that

Re: Mysql 4 to 5

- Original Message - From: Michael Dykman mdyk...@gmail.com To: Grant Peel gp...@thenetnow.com Cc: mysql@lists.mysql.com Sent: Sunday, July 11, 2010 9:20 PM Subject: Re: Mysql 4 to 5 One problem you might be having is the column named 'call'.. It's a keyword, so perhaps you might get

Re: Mysql 4 to 5

- Original Message - From: Grant Peel gp...@thenetnow.com To: Michael Dykman mdyk...@gmail.com Cc: mysql@lists.mysql.com Sent: Sunday, July 11, 2010 9:25 PM Subject: Re: Mysql 4 to 5 - Original Message - From: Michael Dykman mdyk...@gmail.com To: Grant Peel gp

Re: Updating 4 to 5

- Original Message - From: Rob Wultsch wult...@gmail.com To: Grant Peel gp...@thenetnow.com Cc: mysql@lists.mysql.com Sent: Friday, July 02, 2010 3:57 AM Subject: Re: Updating 4 to 5 On Thu, Jul 1, 2010 at 5:44 PM, Grant Peel gp...@thenetnow.com wrote: Hi all, I have serveral

Updating 4 to 5

Hi all, I have serveral servers running mysql 4, and need to update to mysql 5. I have version 5 setup on a new dev server and will be cloning that to the old servers, then restoring all the data from backups (mysql databases included). Once I have restored the data from backups, I will

Re: Updating from 4 to 5

nilnandan, I meant to say Mysqlupgrade :-) Further, I can use the old mysql tables, (the mysql gant tables, user/passwd/host tables etc) and the mysqlupgrade will update them as necessary? -Grant - Original Message - From: Nilnandan Joshi To: Grant Peel Cc: mysql

Updating from 4 to 5

Hi all, I am about to move from FreeBSD 6 to FreeBSD 8. With that, the mysql server version will be changed from 4 to 5. I am assuming I can load all the users tables, and the mysql database (grant tables and all) to the new server, then run mysqlupdate, and everything that needs to be

Bin Files.

Hi all, I had a server pretty much locked up this morning due to the mysql bin logs filling up the /var filesystem. I had been investigating the my.cnf settings file a white back, got sidetracked, and never finished it. The bin logs are named: /var/db/mysql/myserver-bin.01

Permissions

Hi all, I run a shared Apache, Perl, PHP, Mysql, on FreeBSD environment. Here is a question: IF I have a user, that has no permissions, but with a decent password, (in the mysql 'Users' table), AND that user only has access to his/her database through the local host (i.e. perl or PHP

Help!

Hi all, I have a table I needed to prune because it had grown to 5 million rows and it appeared that that app that uses it couldnt anymore. I am in the process of: DELETE FROM mytable WHERE id 300; the above has been running for close than an hour and I am starting to get a little

Re: Unable to restart after crash

Have you looked at the results of netstat -an ? -Grant - Original Message - From: Ross Crawford To: mysql@lists.mysql.com Sent: Saturday, January 12, 2008 5:12 PM Subject: Unable to restart after crash Hi, My mysql server crashed last night, and when it rebooted,

Virtual Hosting Privileges

Hi all, This is my first post to this list so bear with me if I ramble on a bit. I have been reading as much as I can on this subject and am yet to feel confident about an answer so I thought I would throw it at this list and see what comes back. One thing I should mention up front is