[Wolves] Teminal & Mysql questions

[Simon Morris]

On Wed, 2006-08-16 at 11:45 +0100, Peter Cannon wrote:

> 
> 1. Whats the command to cp all the contents of a folder (including sub
> folders) to a folder in another location?
> 
> I did
> #cd covide-6.1
> #cp -R *.* /var/covide_files/covide

> But it did not copy over the folders .beagle ect I want to copy
> everything
> inside the covide-6.1 folder

The problem you have here is of bash variable expansion.

When you say * you mean "all files in this directory". Unfortunately *
doesn't include "dot files" or any directory or file beginning with a .

I would copy the containing directory rather than use the * wildcard

cp -r ./covide /var/covide_files/



> 
> 2. In Mysql I've created a database 'Contacts'  is it permissible to
> add
> the 'username' and 'password' prior to importing the covide.sql tables
> file?

Yep the syntax is

grant all privileges on Contact.* to dbuser at localhost identified by
'password';

Cheers

~sm
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://mailman.lug.org.uk/pipermail/wolves/attachments/20060816/35c64332/attachment.bin