phpmyadmin Question posted in
The official documentation can be found here.

Can't import a data base using PHPMyAdmin

We have a database on webserver that works there:~

Apache 2.4.23
PHP 5.5.38
MySQL 5.5.61cll

Through PHPMyAdmin, I saved a file on my laptop.
We have a new webserver and I need to ‘transfer’ the database here:

Apache 2.4.39
PHP 5.6.36

MySQL 5.6.43cll-lve

Can’t import! Can you guide me (step-by-step) on this? I’m a journalist, not a ‘computer man’.

I export (a month ago) the database that we work on the original website. It has a lot of articles that we don’t want to lose.
I tried to import on the new website to work with it and improve it.
I’ve received the message that follow:

Error

Static analysis:

1 errors were found during analysis.

1 Unexpected beginning of statement. (near “jos” at position 0)

SQL query:

jos– phpMyAdmin SQL Dump — version 4.8.3 — https://www.phpmyadmin.net/ — — Servidor: localhost:3306 — Tiempo de generación: 18-03-2019 a las 18:52:56 — Versión del servidor: 5.5.61-cll — Versión de PHP: 7.2.7 SET SQL_MODE = “NO_AUTO_VALUE_ON_ZERO”

MySQL said:

1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘jos– phpMyAdmin SQL Dump
— version 4.8.3

I need your help. I have another question about this, I’ll take one step at a time.

Tags:

3

Answers


  1. Chosen as BEST ANSWER
    0

    I got it. It took time and thanks to your guidance... I got it. You must create the database in cPanel, import the tables and wait a 'few' hours for it to be enabled in phpMyAdmin. Thank you, @Matija.


  2. 0

    If you exported your database from the phpmyadmin by selecting a database from the left sidebar and then exported them by pressing Export Button you can import that database in phpmyadmin using Import Button.

    1. Create a new table by pressing New from the left sidebar where is listed all of your databases
    2. Select database where you want to import data
    3. Browse to the .sql file which you’ve downloaded previously using the export command
    4. Press Go button at the end of the page.
    Login or Signup to reply.
  3. 0

    1st step – Click New enter image description here

    2nd step – Choose collation and click Create enter image description here

    And you will see your database test in sidebar db listenter image description here

    After that you click on test database to select them and click button Import(choose sql file with your database and click Go to import data from the sql file)

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search