WampServer

Hello,

I have installed WAMP on my 64bit OS in the following order:

wampserver3_x86_apache2.4.17_mysql5.7.9_php5.6.15
wampserver3_x86_x64_phpmyadmin4.6.0
wampserver3.0.4_x64_apache2.4.18_mysql5.7.11_php5.6.19-7.0.4

Everything is working fine but my hosting provider is using PHP5.4.45. It becomes quite complicated when I have to import my DBs from there to my local WAMP.

Is there a way I can get PHP 5.4.x on WAMP without messing up things ?

Hi,

PHP 5.4.45 only on Wampserver 32 bit.
There is no 64 bit version of php 5.4.*

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Hello and thanks,

Actually my issue is with import / export process from 5.4.x (Hosting provider) to 5.6.x (WAMP).

What I need to do if I need to get a copy of my live sites running on WAMP:

Export DB from hosting provider (don't have access to mysqldump here), import on an old laptop running WAMP 32 with PHP 5.4, run mysqldump from there to dump a copy of DB, import on my new WAMP on my laptop.

Any idea how I can make this process quicker ?

P.S. am planning to get rid of the WAMP 32b version on the old laptop.

Hi,

I cannot answer with details because my Internet connection is broken. I use Smartphone.

Database export does not depend of PHP version nor mysql version if it is done into SQL file.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Hello, thanks for your reply.

My Hosting Provider (just upgraded): PHP Version 5.5.34 / MySQL Version 5.5.48-cll
My current PC : WAMP 64 bits : PHP Version: 5.6.19 / MySQL Version 5.7.11
My old PC : WAMP 32 bits : PHP Version: 5.4.12 / MySQL Version 5.6.12

What happen is when I export some DBs from Hosting provider (whether I make a backup through cPanel or export from phpmyadmin) and I import it on my current PC (phpmyadmin) , sometimes the import process will work correctly, sometimes I will get:

Static analysis:
2 errors were found during analysis.
1.Ending quote ' was expected. (near "" at position 37712)
2.10 values were expected, but found 2. (near "(" at position 37673)

If I import to my old PC, I don't have any issue.

I'm thinking that running PHP Version: 5.5.x / MySQL Version 5.6.x (on my current pc) might solve the issue.

Hi,

Don't use PhpMyAdmin 4.5.5.1 there is some problems with it.

Use PhpMyAdmin 4.5.4.1 or 4.6.0.

See all thread : [forum.wampserver.com]

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Hello,

in phpmyadmin it says "Version information: 4.6.0 (up to date)"

phpMyAdmin seem to be having a few issues lately, so it might be simpler to use the mysql console to import your backups

wampmanager->mysql->Mysql console


To import a file do this at the mysql command prompt


mysql> use database_you_want_to_restore;
mysql> source 'C:/path/to/exported/backup.sql';

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-



Edited 1 time(s). Last edit at 04/22/2016 12:03PM by RiggsFolly.

Hello and thanks,

syntax:

use mau1f_0d5
source c:/mau1f_0d5.sql


Then:

Error
Static analysis:
2 errors were found during analysis.
Unexpected character. (near ":" at position 8)
Unrecognized statement type. (near "source" at position 0)
SQL query:
source c:/mau1f_0d5.sql
MySQL said: Documentation
#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 'source c:/mau1f_0d5.sql' at line 1

Did you notice the semi colons, they are important

use mau1f_0d5;
source c:/mau1f_0d5.sql;

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

thanks,

just tried with ";" at the end.

Same error message as above.

Hi,

It seems that your export file has problems ; may be it is corrupted.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Hi and thanks for your reply,

like I've mentioned, no issue when importing the sql on these 2:

My Hosting Provider : PHP Version 5.5.34 / MySQL Version 5.5.48-cll
My old PC : WAMP 32 bits : PHP Version: 5.4.12 / MySQL Version 5.6.12

Use a decent editor to make sure the .sql file is converted to DOS format/Line Endings

Maybe that is your issue, it has caught me a could of times


But it does seem like the issue may be in the exported file from your server. What version of phpMyAdmin are they running there?

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Hello and thanks !

When Opened with Notepad++, cannot see anything wrong.


Here are the full details with phpMyAdmin :

My Hosting Provider : PHP Version 5.5.34 / MySQL Version 5.5.48-cll / phpMyAdmin Ver: 4.0.10.7

My current PC : WAMP 64 bits : PHP Version: 5.6.19 / MySQL Version 5.7.11 / phpMyAdmin Ver: 4.6.0

My old PC : WAMP 32 bits : PHP Version: 5.4.12 / MySQL Version 5.6.12 / phpMyAdmin Ver: 4.0.4

Hello,


Just to give an update.

One of my site (on my new PC) start getting errors today, it is telling me that there are some errors with DB. I found this strange since last time I've checked everything was working well (no change in the mean time). I even exported this local DB and imported it at hosting provider last time. Actually I develop locally and upload it on hosting provider when done. So the online version should have been the same as my local version.

Anyway, the site at hosting provider is still working well so I decided to export from there to import locally. In doing so am getting other errors during import. This DB has nothing to do with the DB causing errors in my last post.

I'm thinking that the problem may reside with my local MySQL installation (if it's not with the version).


Error
Static analysis:
8 errors were found during analysis.

Unexpected character. (near ":" at position 35379)
Unexpected character. (near ":" at position 35382)
Unexpected character. (near ":" at position 35935)
Unexpected character. (near ":" at position 35938)
Unexpected character. (near ":" at position 36062)
Unexpected character. (near ":" at position 36065)
Ending quote ' was expected. (near "" at position 36594)
A comma or a closing bracket was expected. (near "0" at position 34665)

Can you tell us where these messages are and what you do to generate them?

Can you tell us something about the site, is it your code, is it a package or a CMS? If its not your code what version of what package/CMS is it?

Look here : [wampserver.aviatechno.net]

There are many versions of MYSQL available, possibly you could consider installing a version similiar to the version of your hosting company, and then restoring data from you hosting co to this new database version.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Hello and thanks !

Can you tell us where these messages are and what you do to generate them? >>>>
In PhPmyadmin, import results.


Can you tell us something about the site, is it your code, is it a package or a CMS? If its not your code what version of what package/CMS is it? >>>
Joomla 3.5

Look here : [wampserver.aviatechno.net] >>>
I have downgraded to "MySQL 5.6.29 64 bit x64" since it is the oldest version available for 64bits. Asked wamp to use this version, Created a new DB and import again, same error message as in my previous post.

Hi,

What PhpMyAdmin versions are used for export and import ?

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Hello,

here are the updated info:


My Hosting Provider :
PHP Version 5.5.34 / MySQL Version 5.5.48-cll / phpMyAdmin Ver: 4.0.10.7

My current PC (where am having the issues) : WAMP 64 bits :
PHP Version: 5.6.19 / MySQL Version both 5.7.11 & 5.6.29 / phpMyAdmin Ver: 4.6.0

My old PC (No issues) : WAMP 32 bits :
PHP Version: 5.4.12 / MySQL Version 5.6.12 / phpMyAdmin Ver: 4.0.4