phpmyadmin

**rajeev83** · 24 Oct 2007, 06:57 PM

Any suggestions that how can i import my database from one server to another as the problem is both the servers do not have compatible version of mysql

I did everything as in tutorial but when it comes to database transfer the phpmyadmin of new server starts giving errors of incompatibility if there is some solution then please suggest else will have to manually add near around 500 products

**Merlinpa1969** · 24 Oct 2007, 07:51 PM

yuo need to use the compatability setting on the right hand of the page when oing the export,

they when you do the import you need to set the same compatability in the import page of the new server,

compatability mysql4 is a good one to use

**rajeev83** · 28 Oct 2007, 05:21 PM

Hi MerlinPa
I am trying to follow the instructions that you gave about mysql compatibility but cannot copy the database
The server where i want to copy the database has something like
MySQL 5.0.32-Debian_7etch1~bpo.1-log running on supremecenter51.com as sell4noth_eshop AT supremecenter51 DOT com

and the biggest problem is that there is no import unless i click on sql that is unlike the export button there is no import when I click at home

**Merlinpa1969** · 28 Oct 2007, 05:58 PM

across the top you shoud see tabs like browse sql import export

**rajeev83** · 28 Oct 2007, 06:16 PM

Hi MerlinPa
Thanks for your concern but it didn;t work i still get the error
[FONT=Courier New]#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 'PK' at line 1[/FONT]

[FONT=Courier New]anyway thanks for your time and help I have decided that i will move to new host where my current site is hosted [/FONT]

[FONT=Courier New]Kind Regards[/FONT]