Magento Forum

   
check the manual that corresponds to your MySQL server version for the right syntax
 
itpath
Jr. Member
 
Total Posts:  1
Joined:  2013-02-02
 

i tried to transfer one site from server to other server
i moved all the files and backup the DB
when i tried to restore the DB i got 2 errors

1- db restore error
ERROR 1064 (42000) at line 7051: 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 “http://daralwarrak.com/catalogsearch/result/index/?author_name=101&book;_size=15\\\\\\\’ at line 1

2- when we try to access the site error
[error] [client 184.145.59.79] PHP Fatal error:  Call to a member function extend() on a non-object in /usr/home/alwarrak/domains/daralwarrak.com/public_html/lib/Varien/Simplexml/Config.php on line 600

 
Magento Community Magento Community
Magento Community
Magento Community
 
SimpleHelixcom
Enthusiast
 
Avatar
Total Posts:  906
Joined:  2007-08-31
Huntsville, AL
 

Hello itpath,

Are you trying to restore the database using a control panel / phpMyAdmin, or from the command line / shell? Can you tell us the exact command that is being entered?

 
Magento Community Magento Community
Magento Community
Magento Community
 
GoMageTeam
Guru
 
Avatar
Total Posts:  356
Joined:  2013-01-13
Warsaw, Poland
 

Hello,

Dump database is imported badly by phpMyAdmin. We recommend you to import the database from the console. Here are the console commands:

mysql -u user -h db_host -p
use your_db_name
source path\to\dump
.sql

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top