This is the way I upgraded from 3.8 -> 4.0.x. I think you could pipe the dump without creating the database first, but is seems like I had an issue with MySQL throwing an error back at me saying database rt4 does not exist. So, to answer your question, yes. If you have a database already created and you pipe the dump using the mysql -u root -p rt4 < mysqldump.sql command, it will put your dump into the database named rt4. Then you can go about the database upgrade procedures you have read in the UPGRADE_READMEs.
Hope this helps. -----Original Message----- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Jeff Blaine Sent: Friday, December 23, 2011 2:42 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] 3.4.2 to 4.x On 12/23/2011 3:03 PM, Izz Abdullah wrote: > Just (within MySql): > create database rt4; > Then, from the command line, using the dump from your current mysql > server, mysql -u<username> -p rt4< <name_of_sql_dump.sql> Thanks. That will override the 'CREATE DATABASE' in the rt3 dump file? > -----Original Message----- > From: rt-users-boun...@lists.bestpractical.com > [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Jeff > Blaine > Sent: Friday, December 23, 2011 2:00 PM > To: rt-users@lists.bestpractical.com > Subject: Re: [rt-users] 3.4.2 to 4.x > > I've read and re-read docs/UPGRADING*. > > Things are going quite smoothly so far, as this is a pretty stock old install > of 3.4.2 heading to 4.0.4 on a totally different box. > > Question: > > Importing the old MySQL 'rt3' database as 'rt4' > > How? Edit the dump file? > > Thanks for any further help! > > On 12/22/2011 4:55 PM, Thomas Sibley wrote: >> On 12/22/2011 03:45 PM, Jeff Blaine wrote: >>> Before I waste a bunch of time, is there any chance this is likely >>> to work? >>> >>> 1. Dump all RT 3.4.2 data from MySQL 4.1 (database 'rt3') 2. Stand >>> up new server with RT 4.x and modern MySQL 3. Import old data >> >> Not with just those steps, but yes, of course you can upgrade from >> 3.4.2 to 4.0.4. Carefully read and follow the instructions in the >> UPGRADING.mysql, UPGRADING-3.4, UPGRADING-3.6, UPGRADING-3.8, and >> UPGRADING-4.0 documentation. >> >> You have a large upgrade ahead of you, but it's well documented and >> fairly straightforward. >> http://blog.bestpractical.com/2011/07/upgrading-to-rt-4.html is a >> gentle introduction, but it does not try to cover all of the >> individual steps you'll need to take, just the general process. >> >> Thomas >> -------- >> RT Training Sessions (http://bestpractical.com/services/training.html) >> * Boston March 5& 6, 2012 >> > -------- > RT Training Sessions (http://bestpractical.com/services/training.html) > * Boston March 5& 6, 2012 > -------- > RT Training Sessions (http://bestpractical.com/services/training.html) > * Boston March 5& 6, 2012 > -------- RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012 -------- RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012