Tag Archives: mysql

How to migrate from EZG v3 to v4


System requirements:

 

  • Windows XP/ Vista / Windows 7 /Windows 8
  • Internet Explorer 8 (or higher version)
  • Screen resolution: 1024 x 768 pixels or higher
  • Internet connection
  • Latest Flash installed in Internet Explorer

 

Server Requirements:

 

EZGenerator created sites will work on any web server.

  • PHP Requirements - you need minimum PHP 5 installed on server, if you use any of the PHP pages and features (as Blog, Podcast, Photoblog, Calendar, Newsletter, Guestbook, Tell a friend, Request, Shop, Search, Counter, RSS Parser and Online Administration panel ).
  • MySQL Requirements - you also need minimum MySQL 4.1, if you have switched project to MySQL and use any of the PHP driven pages and features.

 

How to install EZG v4:

 

 My Licenses

 

If you have problems with your account and can't find My Licenses section, visit our Ticketing system and post request at: http://support.image-line.com/ticketing/issue.php

  • Go to EZGenerator 4.x procedure section and download EZG 4 installer

 

 Download box

 

  • Download the registry file by clicking on regcode link (.reg)
  • Install EZG 4. You don't need to uninstall EZG 3. Install EZG 4 in different folder in Program Files.
  • Run the registry code file that you have already downloaded

 

How to transfer v3 project to v4:


  • Make sure your project is using latest available version of template, still in V3, search for template updates and if newer version of template is available, download and apply it to project before moving project to V4! 
  • Copy your project from Program Files/ezgenerator3/data/ folder and paste it into Program Files/ezgenerator4/data/ folder
  • Open your project in EZG 4
  • Do Full Build

 

Possible problems with v4:

 

    • Catalog and Contacts modules are removed. You don't have local database anymore. All pages that read data from this local database will not work in EZG v4 (as non-php Catalog/Contacts lister). You will have to replace them with the new MySQL pages (catalog and shop).
    • In EZG v3 standard shop/catalog pages use Catalog module to store data. You can have multiple shop pages using same database from catalog module. In EZG v4 shop/catalog pages use MySQL only and each shop/catalog page has its own database table.

 

Important: If you use standard shop (non-mysql) along with Catalog module and you want to keep them,  DON'T move to EZG v4.

If you have standard shop/catalog (non-mysql) and want to move to MySQL shop/catalog, you have to add new shop/catalog page and make one time data conversion. Don't panic, you will not loose your existing shop data. After you add new shop page and upload on server, you have to go to Shop online admin panel. There is option Import, where you will be lead step by step into the date conversion process.

 

  • You may encounter problems with old page layouts. If this is the case, re-load the layout - right-click inside page and select Page Layout Presets, then Load Page Layout Preset and select certain layout.
  • For all form pages (as Newsletter and Request) make sure to open email field properties (by double-clicking on the email field in EZG) and check Validate as email.
  • You have to use only v4 compatible templates. You can check if your template is v4 compatible at http://www.ezgenerator.com/documents/webtemplates.html (simply check if it is in the list). Also make sure you are using latest version of template. If you are using template that is not in this list, you better continue using EZG v3 for this project.

 

MySQL support:

 

EZG V4 can use MySQL for all php features (Blog, Calendar, Counter, Search, etc).

You set your project to either use MySQL, or flat files. You can't have MySQL blog and flat file calendar in same project.

Only shop/catalog page always use MySQL. There is no flat file catalog/shop.

 

To switch your existing project to MySQL, you have to go to Project Settings >> MySQL Settings an check Use MySQL for all Live pages and do Full build.

 

Important: If you switch your existing project to MySQL, all php features (Blog, Calendar, Counter, Search, etc) will be automatically transferred to MySQL, which means data will be moved from flat file to MySQL. So, you will not loose existing data!

 

 

What if I use separate database for each MySQL shop page?


In v4 all pages use same database, but each has its own database table.


1) you need to use phpmyadmin panel (this is administrator MySQL panel)
2) you have to choose one database that you will use for your project
3) you have to export all other databases (that you use for shop pages) and then import the tables in the central database that you will use

 

 

 


Print  posted by miro   Install/Registration tags:  • Migrate • requirements • mysql • registration   permalink
0 0

MySql Backup


EzGenerator doesn't make backup of online database.

To create backup, use online tools available in control panel of your hosting.

PhpMyAdmin utility is available on most of then hostings.

To make backup of online database in PhpMyadmin :

1. login to your phpmyadmin account

2. select database used in your project and click on export:

 


 

3. in export screen left all settings untouched, scroll down and in save as file" select zip option, then click on GO button:

 


 

save file, this file is your database backup

notice, on many accounts, database backup is done automatically by host, check your server documentation.

 

 

 


Print  posted by miro   MySql/Php tags:  • mysql • backup • php   permalink
5 1

MySQL support in EzGenerator v4


MySQL support:

 

EZG V4 can use MySQL for all php features (Blog, Calendar, Counter, Search, etc).

You set your project to either use MySQL, or flat files. You can't have MySQL blog and flat file calendar in same project.

To use Shop/Catalog you need to enable MySQL, there is no flat file catalog/shop.

 

To switch your existing project to MySQL, you have to go to Project Settings >> MySQL Settings an check Use MySQL for all Live pages and do Full build.

 

Important: If you switch your existing project to MySQL, all php features (Blog, Calendar, Counter, Search, etc) will be automatically transferred to MySQL, which means data will be moved from flat file to MySQL. So, you will not loose existing data!

 

 

What if I use separate database for each MySQL shop page?


In v4 all pages use same database, but each has its own database table.


1) you need to use phpmyadmin panel (this is administrator MySQL panel)
2) you have to choose one database that you will use for your project 
3) you have to export all other databases (that you use for shop pages) and then import the tables in the central database that you will use

 


Print  posted by atanas   MySql/Php tags:  • MySql • support   permalink
3 3

Set up Catalog/Shop in EZG v4


To set up a Catalog/Shop page in EZGenerator 4, first of all you need MySQL to do this. Get credentials from your provider (or set up MySQL database in your server, if server is yours). EZGenerator cannot create the database automatically. The database is one of the parameters required in the MySQL settings inside EZGenerator, so make sure you have this set up before you activate the MySQL in your project.

 

To make a shop page:

  1. Go to EZGenerator program and open Project Settings -> MYSQL Settings;
  2. Fill the information required. Ask your provider or check your server settings for the credentials;
    • In most cases (when the site and the MySQL server are on the same working station, the host is "localhost";
    • Note: It's recommended to add project prefix for every project you have. This prefix should be unique (different for every project)!;
  3. Check the "Use MySQL for all live pages" checkbox. You won't be able to do this until all the other fields are filled;
  4. Now you have the Shop/Catalog pages non-grayed (and also included in the page types list) when you try to add one of them.
  5. Add the desired page and make all the layout changes you want (using the macros and custom code on the template pages);
  6. Add payment process partner (if needed). It's explained in this howto section (one of the other threads);
  7. Publish the site;
  8. In Online Administration go to your Shop/Catalog back office and manage the page. All the changes (adding/editing products, part of the Shop/Catalog pages settings, orders, categories) are managed via the Online Administration;


Note: What you cannot find in the Settings module of the Shop/Catalog inside Online Administration, you can find inside EZGenerator. When your Shop/Catalog is selected in the project tree, click on the Shop/Catalog Settings tab or the Page Settings tab to change the current settings.


Print  posted by atanas   General tags:  • shop • catalog • setup • mysql   permalink
4.5 2


[home] 1-4 of 4


CATEGORIES



TAGS


RECENT ENTRIES