Nicepage: Export and Update of WP Content from App

Exporting Pages and Plugin from Application

If you have changes in your Nicepage desktop projects, you can export and

import the Nicepage pages and Plugin to your existing WordPress website. 

Run the installed Nicepage application for Windows or Mac OS.

Open your working project.

Create a new page using templates or from scratch.

Click the Export button. 

In the Export Dialog, select the WordPress Tab.

Uncheck the Theme box.

Please make sure you have the "Pages and Editor Plugin" box checked.

Click the "Export" button to export the zip file with the Pages and Plugin.

Reinstalling Plugin

Open your WordPress Administration.

Deactivate and delete the previously installed Nicepage plugin, if it exists.

Your pages will not be affected by the removal of the Nicepage Plugin.

Click "Add New" to reinstall the Plugin.

Click the "Upload Plugin" button.

Browse for the zip file or drag it from the file explorer. 

Click "Install Now."

Activate the installed Plugin.

You can skip the Content import If you do not need it.

Replacing Content

You can update pages previously created in the desktop application by

exporting and replacing them on your WordPress website. All other pages will

stay unchanged. It helps if you work mainly in your desktop application, and then

move changes to your WordPress website.

While staying in the Wizard, click the "Replace previously imported content" button.

Note that you can restart the Wizard from "Nicepage -> Plugin Wizard."

When finished, open Pages.

Switch windows to compare your WordPress pages to your desktop ones.

Summary

You have learned:

How to export the Plugin and Pages from the Nicepage Desktop Application.

How to update the Nicepage WordPress Plugin and replace the WordPress Content.

 https://nicepage.com/doc/67690/export-and-update-of-wp-content-from-app

Create First Root User

mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'PASSWORD';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

Grant Single DB to MYSQL User

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON dbname.* TO 'username'@'%';

FLUSH PRIVILEGES;

Apache permission denied (Ubuntu)

[Mon Mar 22 06:43:51.067590 2021] [core:error] [pid 25490] (13)Permission denied: [client 27.109.115.156:55380] AH00035: access to /pssusermanipulation/ denied (filesystem path '/var/www/api/folder/folder') because search permissions are missing on a component of the path 

Solution: chmod a+rX -R /var/www

Configure Django with Apache

Python2

sudo apt-get install python-pip apache2 libapache2-mod-wsgi

Python3

sudo apt-get install python3-pip apache2 libapache2-mod-wsgi-py3 

<VirtualHost *:80>

        ServerName abc.com

        ServerAlias abc.com

        Alias /static /var/www/api/env/lib/python3.6/site-packages/django/contrib/admin/static

        <Directory /var/www/api/folder/folder >

                <Files wsgi.py>

                        Require all granted

                </Files>

        </Directory>

        WSGIDaemonProcess tigergourd python-path=/var/www/folder/folder python-home=/var/www/api/env

        WSGIProcessGroup groupname

        WSGIScriptAlias / /var/www/api/folder/folder/wsgi.py

</VirtualHost>

-- In case error when run manage.py-----

mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported

pip install mysql-connector-python

Running setup.py clean for Pillow

  Building wheel for pycrypto 

  

  pip uninstall pycrypto

  pip install pycryptodome

MySQL: Necessary Command

sudo service mysql status

sudo service mysql restart

sudo mysql_secure_installation

—-- Disable root password

Sudo /etc/mysql/mysql.conf.d/mysqld.cnf

[mysqld]

skip-grant-tables

———— Setup Mysql 

sudo apt update

sudo apt install mysql-server

sudo mysql_secure_installation

--- Remove MySQL 

sudo apt purge mysql-server mysql-common

sudo apt autoremove mysql-server mysql-common

— Grant remote permission to user

GRANT ALL PRIVILEGES on *.* to root@'%' identified by ‘password’;

FLUSH PRIVILEGES;

MySQLDump

Bakup table structure and data

mysqldump -u root -p[password] [database_name] > dumpfilename.sql

Bakup table structure 

mysqldumpd -u root -p[password] [database_name] > dumpfilename.sql