On Fri, Jul 29, 2011 at 6:47 PM, Thomas Sibley <[email protected]> wrote: > On 07/29/2011 10:44 AM, Wikus Smit wrote: >> I dropped the rt4 database and tried to import the rt3 database dump >> with 'mysql -p rt4 < rt3.sql ' as suggested but received an 'ERROR >> 1049 (42000): Unknown database 'rt4'' error. >> >> How can I import the rt3.sql dump file into mysql now that the rt4 >> database has been dropped? > > This is basic MySQL administration. Just create an empty database > before hand with: > > create database rt4;
In addition to this command people should setup permissions for rt_user on this new database. Wikus got lucky as `make initialize-database` setups permissions and 'drop database rt4;' doesn't clear them. rt-setup-database tool can be used to create database and grant required rights: sbin/rt-setup-database --help sbin/rt-setup-database --action 'create,acl' --datadir etc/ ... other options ... This works for mysql. -- Best regards, Ruslan. -------- 2011 Training: http://bestpractical.com/services/training.html
