a problem with importing database online

  • Mussab07

    (@mussab07)


    10 years, 3 months ago

    after uploading my website using “filezilla” and exported my database from phpMyAdmin with sql extention , I compressed it to gzip , but when I want to import it to online server it gave me an error

    “

    Error
    SQL query:

    —
    — Database: wordpress
    —
    — ——————————————————–
    —
    — Table structure for table wp_aiowps_events
    —
    CREATE TABLE wp_aiowps_events (

    id BIGINT( 20 ) NOT NULL AUTO_INCREMENT ,
    event_type VARCHAR( 150 ) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ”,
    username VARCHAR( 150 ) COLLATE utf8mb4_unicode_ci DEFAULT NULL ,
    user_id BIGINT( 20 ) DEFAULT NULL ,
    event_date DATETIME NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
    ip_or_host VARCHAR( 100 ) COLLATE utf8mb4_unicode_ci DEFAULT NULL ,
    referer_info VARCHAR( 255 ) COLLATE utf8mb4_unicode_ci DEFAULT NULL ,
    url VARCHAR( 255 ) COLLATE utf8mb4_unicode_ci DEFAULT NULL ,
    event_data LONGTEXT COLLATE utf8mb4_unicode_ci,
    PRIMARY KEY ( id )
    ) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci AUTO_INCREMENT =1;

    MySQL said: Documentation

    #1273 – Unknown collation: ‘utf8mb4_unicode_ci’

    ”

    if anyone know why I have this error tell what I can do ?

Viewing 6 replies - 1 through 6 (of 6 total)
  • jon

    (@adiant)

    10 years, 3 months ago

    You are going from a newer version of MySQL to an older version that does not support utf8mb4_unicode_ci collation, which WordPress switched to in a recent version.

    As explained in other threads referenced below, the best solution is to upgrade MySQL on the “online server” that you mentioned to a newer version of MySQL that supports utf8mb4_unicode_ci. Or switch to another hosting solution with a newer MySQL.

    If that is not feasible, then you’ll have to do a conversion somewhere, which is discussed in these threads:
    https://ww.wp.xz.cn/support/topic/unknown-collation-utf8mb4_unicode_ci?replies=13#post-6884250
    https://ww.wp.xz.cn/support/topic/sql-error-when-importing-database-1?replies=1
    https://ww.wp.xz.cn/support/topic/unknown-collation-utf8mb4_unicode_ci?replies=45

    The utf8mb4 Upgrade

    Thread Starter Mussab07

    (@mussab07)

    10 years, 3 months ago

    thanx , it worked ^^

    but I face another problem , please if you know how can I solve it

    after I finish uploaded database and edit the url , then edit wp-config.php file , then tried to access site , error message appeared :

    Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 122880 bytes) in /home/a7415405/public_html/wp-content/themes/minamaze/admin/main/inc/class.p.php on line 267

    jon

    (@adiant)

    10 years, 3 months ago

    I hope that you won’t be offended if I cut and paste the answer I gave to the same problem 3 days ago:

    There is not enough PHP memory allocated for WordPress the way you have it installed. That message indicates that yours is set to 64MB and that is not enough.

    This is the best place to start:
    http://codex.ww.wp.xz.cn/Editing_wp-config.php#Increasing_memory_allocated_to_PHP

    As it says, get your web hosting Support folks involved if the wp-config.php statements do not solve your problem.

    Thread Starter Mussab07

    (@mussab07)

    10 years, 3 months ago

    well , I started to think they play with me :/
    after this fixed , another problem showed :

    Fatal error: Call to undefined function wp() in /home/a7415405/public_html/wp-blog-header.php on line 14

    I’m so so sorry !

    jon

    (@adiant)

    10 years, 3 months ago

    It looks like some WordPress files are missing or corrupted. Sorry that I cannot be more specific. I suggest you do the following Google search and just read through all the problems until you find a solution that addresses your problem. Be sure to keep backups as you make changes in case your change is not the one that solves the problem.

    The Google Search (you must use quotation marks):
    “Fatal error: Call to undefined function wp()”

    Thread Starter Mussab07

    (@mussab07)

    10 years, 3 months ago

    okay , thank you ver much 🙂

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘a problem with importing database online’ is closed to new replies.