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>
-----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