Title: Importing old database.
Last modified: August 31, 2016

---

# Importing old database.

 *  [paeluss](https://wordpress.org/support/users/paeluss/)
 * (@paeluss)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/importing-old-database-1/)
 * 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)

 *  [Bob Cristello](https://wordpress.org/support/users/gntmidnight/)
 * (@gntmidnight)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/importing-old-database-1/#post-7176900)
 * 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.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [Bob Cristello](https://wordpress.org/support/users/gntmidnight/)
 * Last activity: [10 years, 2 months ago](https://wordpress.org/support/topic/importing-old-database-1/#post-7176900)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics