Skip to main content

Home/ BI-TAGS/ Group items tagged db

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
cezarovidiu

Moving Sugar to Another Server - SugarCRM Support Site - 0 views

support.sugarcrm.com/...Moving_Sugar_to_Another_Server

sugarcrm

shared by cezarovidiu on 20 Mar 13 - No Cached
    • cezarovidiu
      cezarovidiu on 20 Mar 13
       
      japtone   Senior Member Join Date Nov 2010 Posts 49  Re: Transferring SugarCRM to a new server If you're using Linux try to have the same version of PHP, Apache, and DB (MySQL for instance) in order to avoid compatibility issues. In your production server tar up the sugarcrm root directory, transfer it to the new server and untar wherever your new root directory will be.  Next take a db dump of your database, transfer it to the new server and do a restore. Make sure apache is configured on the new server to point to the root of sugarcrm and start it up.  Make sure to modify config.php to account for any change in paths and hostname.  that's what I've found to be the easiest way to 'clone' sugar.
  • mysqldump -h localhost -u [MySQL user, e.g. root] -p[database password] -c --add-drop-table --add-locks --all --quick --lock-tables [name of the database] > sqldump.sql
  • Extract the Database
  • ...5 more annotations...
  • Copy Filesystem Copy all your files to the new server.  This can be done simply by locating the root directory on your old instance and copy and pasting it to the new server location.
  • Import Database Import the mysql database into the new server.  Here's how you would restore your custback.sql file to the Customers database. mysql -u sadmin -p pass21 Customers < custback.sql Here's the general format you would follow: mysql -u [username] -p [password] [database_to_restore] < [backupfile]
  • Check Files and Permissions Check Config.php Open <sugarroot/config.php> and make sure that all settings still apply to the new server, such as: array ( 'db_host_name' => 'localhost', 'db_user_name' => 'root', 'db_password' => 'PASSWORD', 'db_name' => 'DATABASE_NAME', 'db_type' => 'mysql', ), 'site_url' =>, etc...
  • Check htaccess Open <sugarroot/.htaccess> and ensure that the new server URLs are used correctly.
  • Check Permissions Check that the permissions are correct on the new server. That is the entire custom and cache directories (and all the sub directories) in addition to the config.php file are owned and writable by the user that runs the application on the server.
cezarovidiu

Using Oracle SQL Developer to Setup SQL*Loader Runs - 0 views

www.thatjeffsmith.com/...eloper-to-setup-sqlloader-runs

sqlloader oracle db

shared by cezarovidiu on 12 Sep 13 - No Cached
  • Using Oracle SQL Developer to Setup SQL*Loader Runs
cezarovidiu

Building Dynamic Actions in Oracle Application Express 4.1 - 0 views

www.oracle.com/...dynactions.htm

apex obe action links

shared by cezarovidiu on 13 Nov 13 - No Cached
  • cezarovidiu on 13 Nov 13
     
    "select d.loc location, count(e.empno) num_employees from dept d, emp e where d.deptno = e.deptno(+) and d.deptno = :P3_DEPTNO group by d.loc"
1 - 9 of 9
Showing 20▼ items per page