Cloning a Joomla site

From Bitpost wiki
  I've gotten far enough that i'm ready to clone it
       I need one for waves, one for spirit
       looks like i can do this:
             copy the joomla directory
             copy the joomla database
             edit joomla_new/configuration.php
             can that be all I need??  let's test and see...
                 creating hollyspringswaves.com site
                 cp /usr/local/joomla /home/m/development/tdm_cvs_view/joomla-waves
             signed up for hollyspringswaves.com
             at 1and1.com for $7/year including DNS mgmt
                hollyspringswaves.com
             waiting for reply email (m@thedigitalmachine.com)
             updated configuration.php
                     $mosConfig_absolute_path = '/home/m/development/tdm_cvs_view/joomla-waves';
                     $mosConfig_cachepath = '/home/m/development/tdm_cvs_view/joomla-waves/cache';
                     $mosConfig_db = 'joomla-waves';
                     $mosConfig_live_site = 'http://www.thedigitalmachine.com/hollyspringswaves.com';
             once 1and1.com gets its act together i will update live_site
                  ok now they're back, and hollyspringswaves.com is ready
                  went to do DNS management, there is only space for one A and one MX record, I added tho\
  se
                  looks like you have to ADD subdomains, and you are allowed up to 5
                        adding www.hollyspringswaves.com
                        now I can do DNS management, cool, just used the same settings
                  stupid me put in all my juicy details, including address and phone and m@thedigitalmach\
  ine.com
                         updated official DNS contacts to just have my name and city
             now to clone the database... using phpmysql
                 i guess i need to export, then import, hrmph...
                 exported joomla using all defaults
                      [x] include Autoincrement
                      [-] include complete inserts
                      [x] save to file
                 create new database joomla-waves
                 oops, no need, i found "database copy" under "database->operations", GROOVY!
                 now it's complaining that i haven't added the tables that mysql wants
                     - no worries, that's just for additional linking features of some kind
                 copied to joomla-waves, looking good!
                 now set up a virtual host!
                     cd virtualhosts
                     cp boxcarkid.conf hollyspringswaves.conf
                     xe /home/m/config/machine_globals.conf
                        add an include for virtualhosts/hollyspringswaves.conf
                     then set up hollyspringswaves.conf
                     well ok, i did it, time to DEBUG ( not like it's going to work first try!! )
  1&1 Name Servers are:
  ns47.1and1.com
  ns48.1and1.com
  nslookup
  server ns47.1and1.com
  hollyspringswaves.com
  (that works fine)
  adding hollyspringswaves.com to /etc/hosts
  bouncing apache... failed
  needs this:
  mkdir /usr/local/apache/logs/hollyspringswaves.com
  whoooooooop apache started up!
  it's there!  but says "The site is temporarily unavailable." and a "3"
       The number following the message indicates a database problem. The error number is generated by jo\
  omla/mambo and error numbers 1, 2 and 3 indicate the following:
       Error 1 = FATAL ERROR: MySQL support not available.
       Error 2 = FATAL ERROR: Connection to database server failed.
       Error 3 = FATAL ERROR: Database not found
  Sounds like I need to set up PERMISSIONS for that new db, doh.
  where is the joomla mysql user specified... I think it is here in the configuration.php...
  $mosConfig_user = 'joomla';
  $mosConfig_password = '*****';
  changing to this:
  $mosConfig_user = 'joomla-waves';
  $mosConfig_password = '*****';
  and creating permissions with this:
  mysql -u root -p
  GRANT ALL PRIVILEGES ON joomla-waves.* TO joomla-waves@localhost IDENTIFIED BY '*****';
  (argee, you'll need to add some single-tick quotes around each part of that)
  I ended up adding a global user in phpmyadmin, adding db rights, then revoking global rights
  OK THAT DID IT!
  next, there's no css, weird.
  and when I logged in i got a bad url - need to fix _live_site in configuration.php, that should fix it.
  i logged in, said "bad password" but i was in - so i went to profile and updated password
    u      Coach Mike
    p      *****
  IT IS LIVE!  ALL IS FULL OF LIGHT, whoop!!