[Camps-users] mkcamp mysql database creation script missing name

[Harry Batschelet]

On Aug 19, 2012, at 8:30 PM, Richard Templet wrote:

> On Sun, Aug 19, 2012 at 10:02:34AM -0400, Sam Batschelet wrote:
>> I am using the most current version of camps from git with
>> interchange.  During mkcamp I get a failure from mysql during the
>> database creation step.  From what I can gather Master.pm created
>> the following mysql command
>> 
>> mysql -u root -p'password' --socket=/socket/location.mysql.sock < /home/camp/campname/mysql/tmp/camp.sql
>> 
>> which gives me
>> ERROR 1046 (3D000) at line 22: No database selected
>> Error importing data
>> 
>> The fix for this as far as myql is concerned would be to include the
>> db name so the command would read
>> 
>> mysql -u root -p'password' dbname
>> --socket=/socket/location.mysql.sock <
>> /home/camp/campname/mysql/tmp/camp.sql
>> 
> 
> Sam,
> 
> The easiest way to handle this is to just adjust the script you are
> using to create your MySQL dump that mkcamp is using to include the use
> $dname; in the file.  You just need to use the -B option to mysqldump.
> 
Richard,
Thanks so much that did the trick everything is working now.

-Sam