Manual de Instalación de Pymetec Retail con Mysql
Contents
1. m M I C Facil de aprender simple de usar Manual de Instalaci n de Pymetec Retail con Mysql Archivos de Instalaci n necesarios Paso Programa Archivo 1 Motor de datos MySql 2 o Software Pymetec Setup_3 3 6 exe 3 Utilitarios MySql 2 4 Archivos de Actualizaci n RETAIL_ zip 5 Crystal Reports 9 1 Instalar Motor de datos MySq ie MySQL Server 5 0 Setup Wizard Welcome to the Setup Wizard for MySOL Server 5 0 The Setup Wizard will install MySQL Server 5 0 release 5 0 24a on our computer To continue click Next WORKING This program is protected by copyright law Haga clic en Next Le MySOL Server 5 0 Setup Wizard Setup Type Choose the setup type that best suits your needs Please select a setup type 3 Typical Common program features will be installed Recommended For general use Complete All program Features will be installed Requires the most disk Custom t Choose which program Features vou want installed and where they 1 will be installed Recommended For advanced users Seleccione la Opci n Typical y luego haga clic en Next ie MySOL Server 5 0 Setup Wizard Ready to Install the Program The wizard is ready to begin installation TF you wank to review or change any of your installation settings click Back Click Cancel to exit the wizard Current Settings Setup Type Typical2. Controladores Trazas Agrupaci n de conesiones Acerca de DSN de usuaria DSN de sistema DSN de archivo Origenes de datos de sistema Agregar LASS SOL Server Cristal Repository Microsoft Access Driver mdb treme Sample Database 9 Microsoft Access Driver mdb Un Origen de datos de sistema ODBC almacena informacion acerca de c mo conectarse al proveedor de datos indicado Un Origen de datos de sistema es visible para todos los usuarios de este equipo incluidos los servicios NT Aceptar Cancelar Apli Ayuda Haga clic en Agregar 2 Crear nuevo origen de datos Seleccione un controlador para el que dezee establecer un origen de datos gt Nombre Microsoft Paradox Driver P db Microsoft Parados Treiber P db Microsoft Test Driver bak 9 cs Microsoft Text Treiber text csv Microsoft Visual FoxPro Driver Microsoft Visual FoxPro Treiber SGL ODBC 3 51 Driver SOL Server Pd o fa fs A fa 4 gt Finalizar Cancelar Seleccione MySql ODBC 3 51 Driver y luego haga clic en Finalizar Connector ODBC 3 51 12 Add Data Source Hame Connector ODBC A Login Connect Options Advanced Database Data Source Name pymetec The database to be current upon connect Description Server 1921 E515 Optional es es Default none User ventas
3. Destination Folder Cu Archivos de programaiMySOLiMySOL Server 5 01 Haga clic en Install 3 MySOL Server 5 0 Setup Wizard Installing MySQL Server 5 0 The program Features you selected are being installed Please wait while the Setup Wizard installs MySQL Server 5 0 This may take several minutes Status Cancel Espere mientras se cargan los archivos de instalacion MySOL com Sign Up Setup Wizard MySOL com Sign Up Login or create a new MySQL com account Please log in or select the option to create a new account O Create a new free MySQL com account IF vou do not yet have a MySGQL com account select this option and complete the Following three steps O Login to MySOL com Select this option if vou already have a MySQL com account Please specify your login information below Email address Password Seleccione la Opci n Skip Sign Up y luego haga clic en Next iy MySQL Server 5 0 Setup Wizard Wizard Completed Setup has Finished installing MySQL Server 5 0 Click Finish to exit the wizard Configure the MySQL Server now Use this option to generate an optimized MySQL config File setup a Windows service running on a dedicated port and to set the password For the root account Seleccione la Opci n Configure the Mysql y luego haga clic en Finish MySOL Server Instance Configuration Wizard Welcome to the MySOL Server Instance Configuration Wizard 1 0 8 The Configuration Wizar
4. acceso directo Eliminar Cambiar nombre Propiedades Al archivo ejecutable RETAIL USB Ren mbrelo como PYMETEC Archivo Edici n Wer Favoritos Herramientas Ayuda atr s hi EJ Bi yo B squeda Es Carpetas BEE Direcci n Cgestwin3 Tareas de archivo y carpeta A RACKLIP ro images a Crear nueva carpeta cd Publicar esta carpeta en Web reports ES Compartir esta carpeta gestdat Otros sitios Aplicaci n de Microsoft Access 160 KE PYMETEC 6 4 0 4 sa Disco local Co PYMETEC w395 E Mis documentos Documento de texto E Pocumentos compartidos 0 2 KB La carpeta Gestwin3 deber a quedar con estos archivos 1 Instalaci n de la Base de Datos Fig 5 1 MicrosorFt rce word UUs eF 7 QuickTime 7 MySQL Server 5 0 W NN Editor de Reportes PYMETEC E MYSOL Administrator a IET Crystal Reports 9 Tools O MySQL Migration Toolkit EL Editor de Reportes PYMETEC E RETAIL MySQL Query Browser ae Crystal Reports 9 o MySQL System Tray Monitor Todos los programas f MySQL ES MySQL Workbench de Cerrar sesi n O Apagar equipo rd Inicio Abra al Administrador de MySql que se encuentra en el men de inicio HySOL Administrator 1 2 4 re T MUSQU Administrator Connect to MySQL Server instance Stored Conmectiore Server Hos 127 0 0 1 Pot 3206 Usemame rock eer Password Server Host Ingrese la ip del Servidor en nuestro
5. ae Load Mom dls E lesi Image New User Apply changes En el menu seleccione User Administration e ingrese en Mysql User ventas y como Password ventas 25 Fig 5 10 MySQL Administrator rootolocalhost 3306 File Edit view Tools Window Help Mm Service Control New User aa User Administration Pa Server Connections 2 VW Health E eda 8 Server og E Informations schema ESA Server L sch 7 Replication Status mse test qa Backup qa Restore E Catalogs Users Accounts 3 New User 98 Server Information RERA A E User Information Schema Privileges Resources i Ji A Startup YWarables Schema Privileges assigned to the User Assigned Privileges A SELECT INSERT A UPDATE 2 DELETE A CREATE 2 DROP TA GRANT wA REFERENCES INDEX ALTER T CREATE TM LOCK TABL A CREATE WI A SHOW VIEW TA CREATE_RO TA ALTER_AOU A EXECUTE Apply changes Discard changes Seleccione la pesta a de Schema Privileges luego seleccione la Base Gestdat y pulse el bot n lt lt luego pulsar el bot n Apply Changes Finalmente cierre la aplicaci n 26 Configuraci n del DNS de Sistema Para configurar el DNS dir jase a la siguiente ruta Panel de Control Herramientas Administrativas haga doble clic sobre Or genes de datos ODBC y seleccione la pesta a DNS de Sistema Fig 6 1 A Administrador de or genes de datos ODBC 7x
6. ejemplo es 127 0 0 1 Username root Password pymetec Haga clic en Ok 22 D Service Control CA Startup Variables del User Administratior ge Server Connections y Health S00 Server Logs Fig 5 4 Open Backup File Seleccione Restore Haga clic en el boton Open Backup File ubicado parte inferior derecha Buscar er RETAIL_USB_3 8 0 Y E E gt Documentos pens recientes El PYMETEC_V395 Escritorio Mis documentos Nombre RETAIL USB 3 8 0 vi Mis sitios de red Tipo SOL Files Cancelar Seleccione el archivo de texto PYMETEC V395 ubicado en C gestwin3 y haga clic en abrir 23 38 Server Information renek i eneral Restore Content D Service Control hy cz Restore Options By Startup Variables Sa Please select how the backup should be restored Aa User 4dministration j General Qu Server Connections M 5 File to restore 2 Gestwind Gestdat 20061129 1529 sal Name of the backup file that should 13 Health E be restored er Server Logs a es oy Schema to use when restoring tables If Original Schema is E 2 MS selected the tables will be restored where they were backuped p Replication Status fror Backup Type SOL Files o Type of backup file Options E Ignore Errors Create database s if they don t exist Character Set IF vou are importing a SOL file that has not been created with File Charset mE MySQL Administrator vou have to c
7. ms o Password Database Ingrese los siguientes datos en los campos correspondientes Data Source Name pymetec Server aqui debe colocar la ip del servidor en este ejemplo seria 192 168 1 5 en el caso de trabajar nada mas que con un pc escriba 127 0 0 1 User y Password ventas Database gestdat Finalmente Haga clic Test y luego Ok 1 Administrador de or genes de datos ODBC Controladores Traza Agrupaci n de conexiones Acerca de DSN de usuario DSN de sistema DSM de archivo Origenes de datos de sistema Mombre O Controlador l Agregar CRASS SQL Server Crystal Repository Microsoft Access Driver mdb prmetec MySQL ODBC 3 51 Driver streme Sample Database 9 Microsoft Access Driver mdb Un Origen de datos de sistema ODBC almacena informaci n acerca de c mo conectarse al proveedor de datos indicado Un Origen de datos de sistema es visible para todos los usuarios de este equipo incluidos los servicios MT Por ultimo haga clic en Aceptar 29 Configuraci n de IP de Servidor en el Sistema Fig 7 1 onexi n Salir METE Www pymetec cl Password Abra el sistema Pymetec desde el icono que creo en el escritorio y luego Haga clic en el Menu Conexi n w Datos de conexi n al servidor de datos Finalizar AP del Servidor 127 0 0 1 Hombre de la Base de Datos gestdat Usuario Password PYMEMEC Www pymetec cl S1 trabaja solo en u
8. Tools for 5 0 The program Features vou selected are being installed Please wait while the Setup Wizard installs MySQL Tools For 5 0 This may take several minutes Status Cancel Espere a que instale 17 i MySOL Tools for 5 0 Setup Wizard Wizard Completed Setup has Finished installing MySQL Tools For 5 0 cee E Haga clic en Finish Cancel 18 Archivos de actualizaci n Fig 4 1 Archivo Ver Favoritos Herramientas Ayuda da gt Carpetas Hae CHEZ Deshacer Q AA Cortar Ctrl Direcci n Copiar CEHE Pegal Pegar acceso directa i Tarey Fager acceso directe BaCKUP images Copiar a la carpeta Mover a la carpeta E Seleccionar todo Crri E i Invertir selecci n qu or elementos siguientes gestdat EE X Eliminar los elementos Aplicaci n de Microsoft Access SOL Manager SOL Script seleccionados ES 160 KB e a5 EE cB oo unidad i VET AIL USE 3 9 7 a l guna Otros sitios A D SADA ee por lotes MS DOS A DETAT LER 40 Copie los archivos aqu destacados Disco local Archivo Edici n Ver Favoritos Herramientas Ayuda atr s gt wi POS B squeda gt Carpetas Eb Direcci n ge ci Tareas del sistema Archivos de programa Ocultar el contenido de esta unidad T Agregar o quitar programas skina Po 1150 1300 po Buscar archivos o carpetas FN WINDOWS Tareas d
9. d will allow vou to configure the My SOL Server 5 0 server instance To Continue click Next Haga clic en Next gt MySOL Server Instance Configuration Wizard MySQL Server Instance Configuration Configure the MySQL Server 5 0 server instance Please select a configuration type Detailed Configuration Choose this configuration type to create the optimal server setup For this machine Use this only on machines that do not already have a MySQL server installation This will use a general purpose configuration For the server that can be tuned manually Seleccione Detailed Configuration y luego haga clic en Next gt MySOL Server Instance Configuration Wizard MySQL Server Instance Configuration Configure the MySQL Server 5 0 server instance Please select a server type This will influence memory disk and CPU usage Developer Machine l a This is a development machine and many other applications will be ton on it MySQL Server should only use a minimal amount of Menor Server Machine a Several server applications will be running on this machine Choose e this option For websapplication servers MySQL will have medium memory Usage Dedicated MySQL Server Machine This machine is dedicated to run the MySQL Database Server No other servers such as a web or mail server will be run MySQL will utilize up to all available memory Seleccione Server Machine y lu
10. e archivo y carpeta Dirijase al disco C carpeta gestwin3 c gestwin3 e ingrese a esta carpeta 19 Archivo Mame Ver Favoritos Herramientas Ayuda Deshacer Mover Q ar Tartar Direcci n Cte J B4CKUP images reporks 4 gestdat Gestdat 3 5 9 Pata A PYMETEC E o CE Aplicaci n de Microsoft Access eee SOL By GADA Ctrlt 2 Ba E Carpetas trie Invertir selecci n Otros sitios Pegue y reemplace los archivos anteriormente Copiados v Ir reports ar Abrir Ejecutar como Unregister Application RJMOD32 antivirus system TuneUp Shredder A adir al archivo 3 A adir a PYMETEC rar 3S A adir y enviar por email 33 A adir a PYMETEC rar y enviar por email Anclar al men Inicio Enviar a Cortar Copiar Pegar Crear acceso directo Eliminar Cambiar nombre Propiedades Elimine el archivo PYMETEC 20 BACKUP reports 4 gestdat Aplicaci n de Microsoft Access e E Fi L60 KB Abrir Ejecutar como Unregister Application FO MOD3S2Z antivirus system TuneUp Shredder 3S A adir al archivo A adir a RETAIL_USB_3 9 7 rar 3S A adir y enviar por email Sa adir a RETAIL_USB_3 9 7 rar y enviar por email Anclar al men Inicio Enviar 4 Cortar Copiar Pegar Crear
11. e wizard Current Settings Setup Type Typical Destination Folder Terminar Haga clic en Install gt ig MySOL Connector ODBC 3 51 Setup Wizard Wizard Completed Setup has Finished installing MySQL Connector ODBC 3 51 Click Finish to exit the wizard emna Cancela Haga clic en Finish gt 7O Retail USB MySql Setup Retail USB Mysai v3 3 1 Programa de instalaci n de Retail USB MySql Instalaci n Completada La instalaci n de Retail USB MySql 3 3 1 ha terminado N Gracias por elegir Retail USB MySql Por favor haga clic en Finalizar para salir del programa de Q laci n 1 Haga clic en Terminar 14 Instalar utilitarios ig MySOL Tools for 5 0 Setup Wizard Welcome to the Setup Wizard for MySQL Tools for 5 0 The Setup Wizard will install MySQL Tools for 5 0 on your computer To continue click Mex WARNING This program is protected by copyright law and international treaties Haga clic en Next gt ig MySOL Tools for 5 0 Setup Wizard License Agreement Please read the Following license agreement carefully Copyright 124 2003 2006 MySQL AB This program is free software you can redistribute it and or modify it under the terms of the GNU General Public License as published by the Free Software Foundation either version 2 of the License or at your option any later version This program is distributed in the
12. ego haga clic en Next gt MySOL Server Instance Configuration Wizard MySQL Server Instance Configuration Configure the MySQL Server 5 0 server instance Please select the database Usage O Multifunctional Database A General purpose databases This will optimize the server For the use of the Fast transactional InnoDb storage engine and the high speed MyISAM storage engine Transactional Database Only Optimized For application servers and transactional web applications TL This will make InnoDB the main storage engine Mote that the ee MyISAM engine can still be used Non Transactional Database Only a Suited For simple web applications monitoring or logging applications ae as Well as analysis programs Only the non transactional MyISAM storage engine will be activated Cancel Seleccione Multifunctional Database y luego haga clic en Next gt MySOL Server Instance Configuration Wizard MySQL Server Instance Configuration Configure the MySQL Server 5 0 server instance Please select the drive For the InnoDB datafile iF vou do not want to use the default settings InnoDB Tablespace Settings Ca Please choose the drive and directory where the InnoDB tablespace 2 should be placed Installation Path Drive Info volume Mame File System MN 2 3 GB Diskspace Used _ 1 3 GB Free Diskspace Haga clic en Next gt MySOL Server Instance Configuration Wizard MySQL Server Ins
13. er set Standard Character Set Makes Latini the default charset This character set is suited For English and other West European languages Best Support For Multilingualism Make UTFS the default character set This is the recommended character set for storing text in many different languages 5 Manual Selected Default Character Set y Collation Please specify the character set to use Character Set latin v Seleccione Standard char cter Set y Haga clic en Next gt MySOL Server Instance Configuration Wizard MySQL Server Instance Configuration Configure the MySQL Server 5 0 server instance Please set the Windows options Install 45 Windows Service plein E This is the recommended way to run the MySQL server TI on Windows Service Mame MySQL ye Launch the MySOL Server automatically _ Include Bin Directory in Windows PATH Check this option to include the directory containing the server client executables in the Windows PATH variable so they can be called from the command line Seleccione Install as Windows Service y Haga clic en Next gt MySOL Server Instance Configuration Wizard MySQL Server Instance Configuration Configure the MySQL Server 5 0 server instance Please set the security options Modify Security Settings New rook password Enter the root password Confirm cen Retype the password _ Enable root access from remote machines d Create 4n 4nonymous Accou
14. hoose the corect character gt set of the file If vou have created the backup with MySQL Administrator the file was written in LUT F 8 Open Backup File Start Restore Haga clic en Start Restore para comenzar a cargar la base de datos Restoring A GestwindiGestdat 20061129 1529 sql Restoring Backup File A GestwinstGestdat 20061129 1529 sql Total Number of Bytes 142081 Number of Bytes processed 16384 LETTE Elapsed time 00 00 01 Remaining time 00 00 16 Stop stop Espere a que cargue la base de datos y al finalizar seleccione Close 5 chemata 4 gestdat Information scherna mysql ES test En el ment seleccione Catalogs y verifique que se haya cargado la base de datos Gestdat Fig 5 9 E MySOL Administrator rootelocalhost 3306 File Edit View Tools Window Help La i Mysql User ventas E Server Information User Information Schema Privileges ysq Y eres Password ventas Maa 29 No user selected Confirm Password ventas CO Startup Variables Login and additional information on the user User Administratior 3 aa User Administration action E Server Connections ay Health Ww Ea Server Logs 3 Replication Status qa Backup a Fest sa AE Additional Information Catalogs Evil Mame Users Accounts TA i j ME Uzel PAM Pame Aa ee A UE A A elo E dato ESENCIA OF Ae ase Fi ET ra ke HANN ANEA CE TA TAA a qe
15. hope that it will be useful but WITHOUT ANY WARRANTY without even the implied warranty of MERCHANTABILITY or FITNESS FOR 4 PARTICULAR PURPOSE See the GNU General Public License for more details I accept the terms in the license agreement 51 do not accept the terms in the license agreement Seleccione la primera opci n y luego Haga clic en Next gt 15 E MySQL Tools for 5 0 Setup Wizard Destination Folder Click Next to install to this Folder or click Change to install to a different Folder O Install MySQL Tools for 5 0 to Cu Archivos de programa PMYySOL MYSOL Tools For 5 01 Haga clic en Next gt Pa MySOL Tools for 5 0 Setup Wizard Setup Type Choose the setup type that best suits your needs Please select a setup type Complete All program Features will be installed Requires the most disk Space Choose which program Features vou want installed and where they Will be installed Recommended for advanced users Seleccione Complete y Haga clic en Next gt E MySOL Tools for 5 0 Setup Wizard A The wizard is ready to begin installation Ready to Install the Program gt IF vou want to review or change any of your installation settings click Back Click Cancel to exit the wizard Current Settings Setup Type Complete Destination Folder Cu Archivos de programalMySQLMySGL Tools For 5 01 Haga clic en Install i MySOL Tools for 5 0 Setup Wizard Installing MySQL
16. n PC escriba 127 0 0 1 en el caso de instalar en un servidor agregue la IP de este la cual debe ser fija luego guarde Finalmente puede arrancar su sistema 30
17. nt This option will create an anonymous account on this server Please note that this can lead to an insecure system Seleccione Modif Security Settings e ingrese como Password pymetec repitala en Confirm Luego Haga clic en Next gt MySOL Server Instance Configuration Wizard MySQL Server Instance Configuration Configure the MySQL Server 5 0 server instance Ready to execute _ Prepare configuration J Write configuration File _ Stark service _ Apply security settings Please press Execute to start the configuration Execute j Cancel Haga clic en Execute MySOL Server Instance Configuration Wizard MySQL Server Instance Configuration Configure the MySQL Server 5 0 server instance Processing configuration o iw Prepare configuration 6A Write configuration File C Archives de programalMySQU MySQL Server 5 0my in vi Start service 64 Apply security settings Configuration file created Windows service MySQL installed Service started successfully Security settings applied Press Finish to close the Wizard Finalmente verifique que las 4 casillas tengan un victo bueno y luego haga clic en Finish 10 2 Instalar Software Pymetec S Programa de instalaci n de Retail USB MySql Bienvenido Bienvenido al programa de instalaci n de Retail USB MySql Se recomienda que cierre todos los programas en ejecuci n antes de continuar con la instalaci n Si Ud tiene alg n otro
18. programa en ejecuci n por favor haga clic en Cancelar cierre los programas y ejecute la instalaci n de nuevo De no ser asi haga clic en Siguiente Cancelar Haga clic en Siguiente gt 5 Programa de instalaci n de Retail USB MySql Instalando Retail USB MySql For favor espere Preparando para instalar Cancelar Este Proceso puede tardar varios Minutos 11 Welcome to the Setup Wizard for MySQL Connector ODBC 3 51 The Setup Wizard will install MySQL Connector ODBC 3 51 release 3 51 12 on your computer To continue click Mex WARNING This program is protected by copyright law Haga clic en Next gt i MySOL Connector ODBC 3 51 Setup Wizard Setup Type Choose the setup type that best suits your needs Please select a setup type 5 Typical Common program features will be installed Recommended For La general use CI Complete 2 All program Features will be installed Requires the most disk A space Choose which program Features you want installed and where they Will be installed Recommended for advanced users Haga clic en Next gt ie MySQL Connector ODBC 3 51 Setup Wizard Ready to Install the Program The wizard is ready to begin installation IF vou want bo review or change any of your installation settings click Back Click Cancel to exit th
19. tance Configuration Configure the MySQL Server 5 0 server instance Please set the approximate number of concurrenct connections to the server Decision Support DSS OLAP Select this option for database applications that will not require a high number of concurrent connections 4 number of 20 connections will be assumed Online Transaction Processing OLTP Choose this option For highly concurrent applications that may have at any one time up to 500 active connections such as heavily loaded Web Servers Please enter the approximate number of concurrent connections he Concurrent connections 15 ye Seleccione Online Transaction Procesing OLTP y Haga clic en Next MySOL Server Instance Configuration Wizard MySQL Server Instance Configuration Configure the MySQL Server 5 0 server instance Please set the networking options Enable TCP IP Networking Enable this to allow TCP IP connections When disabled only local connections through named pipes are allowed Port Number Please set the server SOL mode Enable Strict Mode This option Forces the server to behave more like a traditional database server Itis recommended to enable this option Seleccione ambas opciones y el puerto 3306 luego Haga clic en Next gt MySOL Server Instance Contiguration Wizard MySQL Server Instance Configuration Configure the MySQL Server 5 0 server instance Please select the default charact
Download Pdf Manuals
Related Search