DATABASE

  • Resolved tipooz

    (@tipooz)


    3 years, 12 months ago

    i use UpdraftPlus – Backup/Restore
    and i not get Restore platinum-seo-pack database ( noindex and nofollow and np keywords )
    even i try to import it in manual i get this error
    Error
    SQL query: Copy

    —
    — Database: xxx
    —

    — ——————————————————–

    —
    — Table structure for table wp_platinumseometa
    —

    CREATE TABLE wp_platinumseometa (
    meta_id bigint(20) UNSIGNED NOT NULL,
    platinumseo_id bigint(20) UNSIGNED NOT NULL DEFAULT ‘0’,
    meta_key varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    meta_value longtext COLLATE utf8mb4_unicode_ci
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

    MySQL said: Documentation

    #1050 – Table ‘wp_platinumseometa’ already exists

    is there any way to import it to another site ( from site 1 to site 2 ) and the Database name site 1 is diffrent from Database name site 2

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Rajesh

    (@rajesh-babu)

    You will have to just import the data and not create the table. But I think you are doing it without an understanding of what you are doing. If Site 1 and site 2 have different posts/pages, this cannot be done as the platinum seo meta data stored in that table (wp_platinumseometa) are specific to the posts/pages in site 1.

    Only the sitewide settings stored in wordpress wp_options table may be imported to another site.

    • This reply was modified 3 years, 12 months ago by Rajesh.
    • This reply was modified 3 years, 12 months ago by Rajesh.
    • This reply was modified 3 years, 12 months ago by Rajesh.
    • This reply was modified 3 years, 12 months ago by Rajesh.
    • This reply was modified 3 years, 12 months ago by Rajesh.
    • This reply was modified 3 years, 12 months ago by Rajesh.
    • This reply was modified 3 years, 12 months ago by Rajesh.
    • This reply was modified 3 years, 12 months ago by Rajesh.
    Thread Starter tipooz

    (@tipooz)

    ( in site 2 i install the platinum seo)
    and site 1 and site 2 it’s 100 % same content and same everything ( page post tag etc …)
    but the site 2 has different database name
    so can manual import, working ?

    Plugin Author Rajesh

    (@rajesh-babu)

    You will have to it manually. and it all depends on the plugin you use or how you do the manual export and import. It is outside the scope of this plugin and I may not be able to guarantee you anything. But if all the posts and pages are the same in site 2 (including the Post IDs) and you are planning to use the same SEO titles, meta description etc., then it should work if you do it right and you are clear about what you are doing.

    • This reply was modified 3 years, 11 months ago by Rajesh.
    • This reply was modified 3 years, 11 months ago by Rajesh.
    Thread Starter tipooz

    (@tipooz)

    the manually is not useful and is painful if
    site 1 and site 2 working the same content
    so new content in site 1 u have do all thing manually again ( big site and big database )
    that’s why all SEO have export setting plugin
    but this one not have it yet =(
    cuz i need it to from keywords and meta tag ( noindex nofollow )
    any idea or some help ?

    Plugin Author Rajesh

    (@rajesh-babu)

    Have added utilities to export and import platinum seo meta data of post types and platinum seo options (that goes into WordPress options table).

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘DATABASE’ is closed to new replies.