• Hello this will be my first post here so please be gentle with me.

    I am trying to restore a halfway made wordpress site.
    When I try to upload the old .sql file phphMyAdmin will not let me. Finds errors. I also exported the current newer database and importing will not work with that either. I am not the best when it comes to sql but I am not the worst either.

    Current db settings: Database server

    Server: 121424.blablabla.com via TCP/IP
    Server type: MariaDB
    Server version: 10.0.22-MariaDB-log – Source distribution
    Protocol version: 10
    User: schmengschmong
    Server charset: UTF-8 Unicode (utf8)

    Webserver: Web server

    Apache / DataZone
    Database client version: libmysql – 5.6.22
    PHP extension: mysqli Documentation
    PHP version: 5.5.26

    phpMyAdmin

    Version information: 4.5.5.1

    If I change the host and the database values below it still will not work.

    Beginning of the .sql file I can not import.

    — MySQL dump 10.13 Distrib 5.6.22, for Linux (x86_64)

    — Host: localhost Database: d40143sd88909
    — ——————————————————
    — Server version 5.6.22-log

    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    /*!40101 SET NAMES utf8 */;
    /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
    /*!40103 SET TIME_ZONE=’+00:00′ */;
    /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=’NO_AUTO_VALUE_ON_ZERO’ */;
    /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

Viewing 1 replies (of 1 total)
  • I would first look to check what version of mysql is running on the old system and on the new system. You may have some compatibility issues with the sql backup.

Viewing 1 replies (of 1 total)

The topic ‘Importing old database.’ is closed to new replies.