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.
3
Answers
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.
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.
1st step – Click New
2nd step – Choose collation and click Create
And you will see your database
test
in sidebar db listAfter 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)