Migrating to New Site – Database error

  • Resolved dailyvideo

    (@dailyvideo)


    8 years, 1 month ago

    Moving a client from one site to another. When I go into PHP MyAdmin and try to import the SQL file I get the following error. Please note I have replaced some dbname info with xxxx for security. Thanks!

    Error

    SQL query:

    —
    — Database: tower_xxxx
    —
    — ——————————————————–
    —
    — Table structure for table xxxx_aiowps_events
    —
    CREATE TABLE IF NOT EXISTS xxxx_aiowps_events (
    id bigint( 20 ) NOT NULL ,
    event_type varchar( 150 ) NOT NULL DEFAULT ”,
    username varchar( 150 ) 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 ) DEFAULT NULL ,
    referer_info varchar( 255 ) DEFAULT NULL ,
    url varchar( 255 ) DEFAULT NULL ,
    event_data longtext,
    country_code varchar( 50 ) DEFAULT NULL
    ) ENGINE = MYISAM AUTO_INCREMENT =89041 DEFAULT CHARSET = utf8;

    MySQL said: Documentation
    #1046 – No database selected

    https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter dailyvideo

    (@dailyvideo)

    8 years, 1 month ago

    Update. I didn’t realize I had to create a blank database first to import to. The db has a different name because it’s on a different host. Where do I need to update names in WP files or else where for this to work?

    Thanks. Halfway there!

    Love this plugin!

    Plugin Contributor mbrsolution

    (@mbrsolution)

    8 years, 1 month ago

    Hi, can you explain further what you mean by.

    Where do I need to update names in WP files or else where for this to work?

    Thread Starter dailyvideo

    (@dailyvideo)

    8 years, 1 month ago

    I guess it’s not related to the plugin. I’ve never transferred a WP database to a new host. So I didn’t know if I had to change the name of the database in like the config file or .htaccess or how AIOWPS might need to be adjusted, turned off or whatever to get the site to work.

    Plugin Contributor mbrsolution

    (@mbrsolution)

    8 years, 1 month ago

    Hi, yes that is correct. Your issue is more related to moving a website to a new host. If you ask your question in the general forum section someone will help you much faster.

    If you have issues that are related to this plugin please don’t hesitate to start a new support thread. We are here to assist you as much as we can 🙂

    I will mark this support thread as resolved.

    Kind regards

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Migrating to New Site – Database error’ is closed to new replies.